Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (1z0-067) Free Practice Test

Question 1

Which two statements are true about service creation for pluggable databases (PDBs)?

A. Only a common user can create additional services for a PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D. When a PDB is created, a service with the same name as the PDB is created in the PDB.

E. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

Correct Answer: C,E

Question 2

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. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

B. SALESPDB is created and is in mount state.

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

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

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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

A. It can be used to control the time interval for which the access privilege is available to a user.

B. It can be used to selectively restrict a user's access to different applications in a specific host computer.

C. It can be used to allow the access privilege settings for users but not roles.

D. It can be used to allow the access privilege settings for users as well as roles.

E. It can be used to selectively restrict the access for each user in a database to different host computers.

Correct Answer: A,D,E

Question 4

You execute the commands to configure settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DRVICE TYPE DISK TO 2;
Then you issue the following command to take a backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of these commands?
Choose the best answer.

A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.

B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

C. It backs up the data files and archived logs, making one copy of each data file and archived log on disk and media.

D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Correct Answer: B

Question 5

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The valid time columns are visible by default when the table is described.

C. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

D. The valid time columns are not populated by the Oracle Server automatically.

E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

Correct Answer: A,D,E

Question 6

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?

A. All redo log files are opened.

B. Only the root database is opened in read-write mode.

C. All the PDBs are in closed state.

D. All the PDBs are opened in read-write mode.

E. The root, the seed, and all the PDBs are opened in read-write mode.

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Examine the query and its output executed in an RDBMS instance:

Which three statements are true about the users (other than SYS) in the output? (Choose three.)

A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)

B. The C##A_ADMIN user can perform wallet operations

C. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only

D. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker

E. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus

Correct Answer: A,D,E

Question 8

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. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

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

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

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

Correct Answer: D

Question 9

Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

A. backup of noncritical tablespaces without shutting down the instance

B. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

C. backup of only those blocks that have changed since the last backup while the database is mounted

D. consistent whole database backup

E. backup of the database without shutting down the instance

Correct Answer: A,C,D

Question 10

A database is running in archive log 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 fails because you cannot specify section size for a compressed backup.

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

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

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

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=>'on 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 other_groups group is not included in the resource plan.

B. The sys_group group is not included in the resource plan.

C. Pending areas can not be validated until submitted.

D. The procedure must be executed before creating any plan directive.

E. The pending area is automatically submitted when creating plan directives.

Correct Answer: A

Question 12

You execute the command to recover your database.

Which statement is true?

A. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task

B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time

C. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".

D. It restores all data files from the specified time, and then applies the redo logs

Correct Answer: A

Question 13

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA I00M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

A. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tablespace does not exist in that PDB.

B. The command gives an error because the container=all clause is missing.

C. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

D. The command succeeds only if all the PDBs have the users and temp tablespaces.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 14

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?

A. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

B. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

C. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

E. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (1z0-067) Free Practice Test