OCA OCP Oracle Certification Exam Braindumps

7.Online index rebuild functionality has been extended to include which four index structures? (Choose four.)
A.bitmap indexes
B.reverse key indexes
C.function-based indexes
D.key-compressed indexes on regular tables
E.key-compressed indexes on IOT (including secondary indexes)
Correct:B C D E
8.Which two statements about dimensions are true? (Choose two.)
A.A hierarchy can consist of multiple levels.
B.A dimension can be based on multiple tables.
C.A dimension can contain only a single hierarchy.
D.No special privileges are required to create a dimension.
Correct:A B
9.Examine the statement: DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?
A.The contents and data files belonging to the IND2 tablespace are dropped.
B.The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.
C.The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF.
D.The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.
Correct:A
10.What do you need to do in order for the Database Resource Manager to estimate, in advance, the execution time of a statement?
A.Set the TIMED_STATISTICS initialization parameter.
B.Gather optimizer statistics on related objects.
C.Set the TIMED_OS_STATISTICS initialization parameter.
D.Nothing
Correct:B
11.Which type of index should be created to spread the distribution of index updates across the index tree?
A.B-tree indexes
B.bitmap indexes
C.reverse-key indexes
D.function-based indexes
Correct:C
12.What statement is true about taking a database default temporary tablespace offline?
A.You cannot take a default temporary tablespace offline.
B.The database must be quiesced before you perform this action.
C.You must ensure that all users are assigned to an alternative temporary tablespace first.
D.You must first ensure that the default temporary tablespace has the permanent tablespace characteristic.
Correct:A