3. You want to create a new optimized database for yourtransactional productionenvironmentto be used by a financial application. While creating the database, you want theOraclesoftware to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

A) Use the CREATE DATABASE.. command to create the database with Oracle-managed files.

B) Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.

C) Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.

D) Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.

E) Use the CREATE DATABASE.. command to create the database with Automatic Storage

Management (ASM) file system.

?

Editor’s note:the key of this question is transactional production environment（交易生产环境）.It seems to me that OLTP is needed. So ,you must create the OLTP db.

?????????????Answer A/B/E does not meet the requirement of the question.

???????????Answer C is wrong.OEM cann’t create db.

?

5. A constraint in a table is defined with theINITIALLY IMMEDIATEclause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? (Choose two.)

A) It fails if any existing rowviolates the constraint.