I really can't find the answer of this two questions
102. Whar are the two methods used to add a second, or subsequent, block size to an existing database? (Choose two.)
A. Create a new tablespace and include a block size specification.
B. Transport a tablespace with a different block size into the database.
C. Re-create the control file to specify a new block size for specific data files.
D. Take a tablespace offline, and then put it back online with a new block size specification
The answer is C, D but I think A. B
109. 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 optimizier statistics on related objects
C. Set the TIMED_OS_STATISTICS initialization parameter
D. Nothing
The answer is B but I can't find it in the official student guide |
