Question 91
You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in nomount state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the resetlog option.
10. Recover the database with the noredo option.
11. Recover the data file with the noredo option.
Identify the required steps in the correct order.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in nomount state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the resetlog option.
10. Recover the database with the noredo option.
11. Recover the data file with the noredo option.
Identify the required steps in the correct order.
Question 92
You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
----------------------------------------------------------------------- db_create_file_dest string db_file_name_convert string db_files integer 200 You verify that sufficient disk space is available and that no file currently exists in the '/u0l/app/oracle/ oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
----------------------------------------------------------------------- db_create_file_dest string db_file_name_convert string db_files integer 200 You verify that sufficient disk space is available and that no file currently exists in the '/u0l/app/oracle/ oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?
Question 93
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
Which statement is true about the execution of the last command?
Which statement is true about the execution of the last command?
Question 94
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.
Question 95
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv ORACLE_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
$ . oraenv ORACLE_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?