1z0-067 | All About Top Quality 1z0-067 practice test
Q41. Which two statements are true about a multitenant architecture?
A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private undo tablespace.
C. Log switches occur only at the container database level.
D. A PDB can have a private temporary tablespace.
E. Each PDB has a private control file.
Answer: C,D
Q42. RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the duplicate command?
A. All archive redo log files are automatically copied to the duplicate database.
B. The duplicate database has the same directory structure as the source database.
C. The duplicate database is created by using the backups created during the execution of
D. the duplicate command.
E. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.
Answer: A,F
Q43. Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL; SQL>CONNsys/oracle@HR_PDB assysdba SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?
A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
B. B_admin can create and select any table in both the root container and kr_pdb.
C. c##admin can create and select any table in the root container and all the PDBs.
D. B_admin can create and select any table only in hr_pdb.
E. The grant c=.role1 to b_admin command returns an error because container should be set to ALL.
Answer: C
Q44. 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.
Answer: B
Q45. Which two statements are true about unified auditing?
A. A unified audit trail captures audit information from unified audit policies and audit settings.
B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
C. Audit records are created for all users except sys.
D. Audit records are created only for the DML and DDL operations performed on database objects.
E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
Answer: A,F
Q46. View the Exhibit showing steps to create a database resource manager plan.
SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed.
3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’)
PL/SQLproceduresuccessfullycompleted.
SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3',comment=>'dssprio’);
SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>' OLTP’,comraent=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?
A. The pending area is automatically submitted when creating plan directives.
B. The procedure must be executed before creating any plan directive.
C. The sys_group group is not included in the resource plan.
D. The other_groups group is not included in the resource plan.
E. Pending areas can not be validated until submitted.
Answer: B
Q47. 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
Answer: C
Q48. Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in mount state.
D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
E. Tables with not null constraints cannot be recovered.
Answer: D,E
Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat ions of Recovering Tables and Table Partitions from RMAN Backups)
Q49. View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?
A. because pga_aggregate_target is not set
B. because statistics_level is set to basic
C. because memory_target and memory_max_target cannot be equal
D. because sga_target and memory_target are both set
Answer: C
Q50. 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.
Answer: B