Far out Oracle 1z0-067 exam

Q1. You are administering a multitenant container database (CDB)cdb1. 

Examine the command and its output: 

SQL>show parameterfile 

NAMETYPEVALUE 

db_create_file_deststring db_file_name_convertstring db_filesinteger200 

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 

ADMINUSERsalesadmIDENTIFIED 3Y password 

ROLES=(dba) 

DEFAULTTABLESPACEsales 

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? 

A. SALESPDB is created and is in mount state. 

B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB. 

C. SALESPDB is created and is in read/write mode. 

D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB. 

View Answer

Q2. Which two statementsare true regarding SecureFile lobs? 

A. The amount of undo retained is user controlled. 

B. They can be used only for nonpartitioned tables. 

C. Fragmentation is minimized by using variable-sized chunks. 

D. They support random reads and writes of encrypted LOB data. 

View Answer

Q3. Which three conditions must be met before you create a Virtual Private Catalog (VPC)? 

A. A base recovery catalog should exist. 

B. The owner of VPC cannot own recovery catalog. 

C. At least one target database should be registered in the recovery catalog. 

D. The register database privilege should be granted to the virtual catalog owner. 

E. The recovery_catalog_owner role should be granted to the virtual catalog owner. 

View Answer

Q4. 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? 

A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted. 

B. All data files belonging to pdb2_1 are backed up along with the archive log files. 

C. Only the data files belonging to pdb2_ are backed up. 

D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database. 

View Answer

Q5. You execute the commands on a multitenant container database CDB1that 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? 

A. It succeeds and displays all the tablespaces that belong to the root database. 

B. It fails and returns an error because a connection is not made by using the sysdba privilege. 

C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases. 

D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt. 

View Answer

Q6. Which parameter must be set to which value to implement automatic PGA memory management? 

A. Set memory_target to zero. 

B. Set STATISTICS_LEVEL to BASIC. 

C. Set pga_aggregate_target to a nonzero value. 

D. Set pga_aggregate_target and sga_target to the same value. 

E. Set sgajtarget to zero. 

View Answer

Q7. Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. 

Examine the steps to recover the online redo log group and move it to a new location. 

1.Restore the corrupted redo log group. 

2.Restore the database from the most recent database backup. 

3.Perform an incomplete recovery. 

4.Relocate the member of the damaged online redo log group to a new location. 

5.Open the database with the resetlogs option. 

6. Issue a checkpoint and clear the log. 

Identify the required steps in the correct order. 

A. 1, 3, 4, 5 

B. 6, 3, 4, 5 

C. 2, 3, 4, 5 

D. 6, 4, 3, 5 

View Answer

Q8. Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. 

Which two actions would you take to solve this problem? 

A. Enable temporary undo for the database. 

B. Enable undo retention guarantee. 

C. Increase the size of the redo log buffer. 

D. Enable Automatic Memory Management (AMM). 

E. Increase the size of the temporary tablespace. 

View Answer

Q9. 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. 

A. 1, 3, 5, 6, 2, 4 

B. 1, 3, 6, 2, 5, 4 

C. 1, 3, 2, 5, 6, 4 

D. 1, 3, 5, 2, 6, 4 

View Answer

Q10. A database is running in archivelog mode.The database contains locally managed tablespaces. Examine the RMAN command: 

RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M 

DATABASE; 

Which statement is true about the execution of the command? 

A. The backup succeeds only if all the tablespaces are locally managed. 

B. The backup succeeds only if the RMAN default device for backup is set to disk. 

C. The backup fails because you cannot specify section size for a compressed backup. 

D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB. 

View Answer