Cert12c_067_121afin_passLeader

QUESTION 121 You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true?

QUESTION 122 Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

QUESTION 123 Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to seven days in RMAN. - The most recent backup to disk for the tools tablespace was taken on March 1, 2013. - The tools tablespace is read-only since March 2, 2013. On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

QUESTION 124 You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true?

QUESTION 125 Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr ---------------------- --------------------------- To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30. What is the effect of this setting on the database?

QUESTION 126 Which three statements are true about persistent lightweight jobs?

QUESTION 127 You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

QUESTION 128 Which two statements are true about unified auditing?

QUESTION 129 Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost. Examine the steps to recover the database: 1.Restore the control files by using the RMAN restore controlfile command. 2.Mount the database. 3.Restore the data files by using the RMAN restore database command. 4.Open the database with the resetlogs option. 5.Recover the data files by using the RMAN recover using backup controlfile command. 6. Start the database instance in nomount state. 7. Connect to the target database by using a recovery catalog. 8.Open the database. 9.Restore the data file. 10.Recover the data file. Identify the required steps in the correct order.

QUESTION 130 You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?

QUESTION 131 You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

QUESTION 132 Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

QUESTION 133 Which three types of failures are detected by the Data Recovery Advisor (DRA)?

QUESTION 134 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.

QUESTION 135 Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' You execute the following command to create the CDB1. container database (CDB): SQL>CREATEDATABASECDB1 DEFAULTTABLESPACE users DEFAULTTEMPORARY TABLESPACEtemp UNDO TABLESPACEundotbsl ENABLEPLUGGA3LEDATABASE SEED SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED SYSAUXDATAFILESSIZE100M; Which three statements are true?

QUESTION 136 Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1.Create media families for data files and archived redo log files. 2.Configure database backup storage selectors or RMAN media management parameters. 3.Create an OSB user preauthorized for RMAN operations. 4.Configure RMAN Access to the OSB SBT. 5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

QUESTION 137 Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

QUESTION 138 The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1.Set the evolve task parameters. 2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function. 3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

QUESTION 139 You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

QUESTION 140 Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2 While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used. What happens at the next log switch?

QUESTION 141 Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

QUESTION 142 Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

QUESTION 143 Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

QUESTION 144 You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true?

QUESTION 145 Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

QUESTION 146 You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

QUESTION 147 You issue the command: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command?

QUESTION 148 You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the command: SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12); Which statement is true about the execution of the command?

QUESTION 149 Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL; SQL> CREATE USER c##adnin IDENTIFIED BY orcl123; SQL> GRANT c##role1 TO c##admin CONTAINER=ALL; SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL; Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

QUESTION 150 Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: 1. Create a policy to capture the privileges used by a user for privilege analysis. 2. Generate a report with the data captured for a specified privilege capture. 3. Start analyzing the data captured by the policy. 4. Revoke the unused privileges. 5. Compare the used and unused privileges' lists. 6. Stop analyzing the data. Identify the correct sequence of steps

QUESTION 151 Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1. RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which statement is true about the execution of this command to back up the database?

QUESTION 152 You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

QUESTION 153 You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX- based Oracle 12c database: CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges Why does the startup command return the error shown?

QUESTION 154 Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: SQL>STARTUP Which two statements are true about the successful execution of the command?

QUESTION 155 Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group; Which two statements are true?

QUESTION 156 Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y'); Which two statements are true?

QUESTION 157 Examine the command: $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the execution of the command?

QUESTION 158 You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

QUESTION 159 Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?

QUESTION 160 You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this?