Online Access Free 1Z0-035 Exam Questions

In order to speed foreign key creation, Oracle9i will cache the first _____ primary key values only where there are multirow DML statements.

• A.512
• B.32
• C.128
• D.256

What is true regarding fact tables having bitmap join indexes defined on them?

• A.You can create a bitmap join index on an index-organized table.
• B.You cannot have more than one dimension table being part of the join condition of a bitmap join index definition.
• C.Tables participating in the join condition of the bitmap join index definition cannot be updated concurrently.
• D.You can create a bitmap join index on a temporary table.

Examine the command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
What does the command accomplish?

• A.stores the primary key column values of each row involved in a DML operation in the online redo log files
• B.stores the primary key column values of each row involved in a DML operation in the supplemental log files
• C.stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files
• D.creates an additional copy of the database online redo log files

Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?

• A.Data blocks have to be written more frequently by DBWR.
• B.You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
• C.Redo blocks have to be written more frequently by LGWR.
• D.You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

Which two options are valid for LOBs during their creation? (Choose two.)

• A.REDO
• B.NOREDO
• C.LOGGING
• D.NOLOGGING