1z0-063 Exam Question 106
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
What type of backup do you recommend to improve the performance of the backup?
1z0-063 Exam Question 107
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') from dual statement.
2. Execute the dbms_stats.seed_col_usage (null, 'SH', 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage ('SH', 'customers') from dual statement.
Identify the correct sequence of steps.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') from dual statement.
2. Execute the dbms_stats.seed_col_usage (null, 'SH', 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage ('SH', 'customers') from dual statement.
Identify the correct sequence of steps.
1z0-063 Exam Question 108
The CATDB12cdatabase contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
The RCAT11database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
1z0-063 Exam Question 109
In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
1z0-063 Exam Question 110
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.