Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
Exhibit:
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
A user receives the following error while performing a large volume of inserts into a table:
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'USERS'
The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user may perform such transaction in the future. You want to ensure that the command waits rather than produce an error when such an
event occurs the next time.
What can you do to achieve this before running the command in the future?
A. Set RESUMABLE_TIMEOUT for the instance.
B. Set the RESOURCE_LIMIT Parameter to TRUE.
C. Enable the database instance to use asynchronous commit.
D. Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance.
View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id, _state_province)') FROM dual;
Which statement describes the significance of this command?
Exhibit:
A. It collects statistics into the pending area in the data dictionary.
B. It creates a virtual hidden column in the CUSTOMERS_OBE table.
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
D. It creates a histogram to hold skewed information about the data in the columns.
In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.)
A. SQL text
B. Shared server requests (Oracle MTS)
C. Bind variable values
D. Information about transactions
E. Remote DESCRIBE and COMMIT operations
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
Note the following parameters settings in your database:
You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What would happen?
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)
A. It's only supported for the backups performed on the tape
B. It is not supported for backup operations that produce image copies
C. Duplex backups need a parallelism for the device to be equal to number of copies
D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
Which command do you use to create a recovery-catalog schema?
A. create recovery catalog
B. create catalog
C. build catalog
D. catalog create
E. mount catalog
Which of the following does the recover command not do?
A. Restore archived redo logs.
B. Apply archived redo logs.
C. Restore incremental backups.
D. Apply incremental backups.
E. Restore datafile images.
