Oracle database 10g:Administration I 認定 1Z0-042 試験問題:

1. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?

A) Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
B) Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
C) Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
D) Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
E) Use the CREATE DATABASE .. command to create the database with Oracle-managed files.

2. Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
Table dropped.
What happens in this scenario?

A) The table is renamed and remains in the TBSFD tablespace.
B) The table is moved to the SYSTEM tablespace.
C) The table is moved to the SYSAUX tablespace.
D) The table is removed from the database permanently.

3. Which two statements are true about a bitmap index? (Choose two.)

A) It can be converted to a B-tree index by using the ALTER INDEX command.
B) It is recommended for the columns that have unique values.
C) Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
D) It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.

4. View the Exhibit.
What would happen if you change the value of Desired Mean Time To Recover to 30?

A) The Redo Log Advisor would be disabled.
B) The redo log from log buffers would be written to redo log files at a slower rate.
C) Automatic checkpoint tuning would be disabled.
D) The MTTR Advisor would be enabled.

5. You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEE table. You plan to add a new column to EMPLOYEE table to achieve this. Which data type would you use for the new column?

A) BLOB
B) CLOB
C) LONG RAW
D) BFILE

質問と回答：