Oracle Database 12c: Advanced Administration (1z1-063) Free Practice Test

Question 1

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A. The PDB data files are automatically removed from disk.

B. The PDB must be dosed.

C. The unplugged PDB can be plugged into the same multitenant container database (CDB)

D. The unplugged PDB becomes a non-CDB.

E. The unplugged PDB can be plugged into another CDB.

F. The PDB must be open in read only mode.

Correct Answer: B,C,E

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

Question 2

Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?

A. Flashback archive FDA1 retains all data and the retention period is increased by 2 years.

B. An error is returned because the retention period cannot be reduced.

C. Data from the first and third years is purged from the flashback archive FDA1.

D. Data older than two years, if any, is purged from the flashback archive FDA1.

E. Data from the third year is purged from the flashback archive FDA1.

Correct Answer: A

Question 3

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?

A. It is created in all the PDBs with the CREATE SESSION privilege.

B. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

C. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

D. It is created and has the CREATE SESSION privilege only in a PDB that is open.

Correct Answer: C

Question 4

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A. The database must be backed up as an image copy.

B. The tablespace must be taken offline.

C. All files must be backed up as backup sets.

D. The backup must be performed in MOUNT state.

Correct Answer: C

Question 5

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

A. to automatically delete obsolete backups after a specified period of time

B. to restrict the amount of space that is used by backups

C. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog

D. to store backup information of multiple databases in one place

E. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

Correct Answer: C,D,E

Question 6

You take your database backups by using the RMAN media management interface (MMI).
Which two are true about the use of the RMAN MMI? (Choose two.)

A. You can use it to create proxy copies for database files.

B. You can use it to create image copies for database files.

C. You can use it to create proxy copies for entire file systems.

D. You can use it to create image copies for entire file systems.

E. You can use it to create backup sets for database files.

Correct Answer: B,E

Question 7

One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIX is C##.
These commands executed successfully while connected as SYS to CDB$ROOT:
SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;
SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;
SQL> GRANT c##role1 to system CONTAINER=ALL;
Which three are true? (Choose three.)

A. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED.

B. The c##role1 role will always have the same privileges in all current and future PDBs.

C. The C##DBA_ADMIN user is a local user in CDB$ROOT.

D. SYSTEM is able to create views in any PDB as a result of being a DBA user.

E. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

F. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

Correct Answer: B,E,F

Question 8

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

A. Use PDB$SEED for creating a PDB.

B. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

C. Clone an existing PDB.

D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.

E. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

Correct Answer: C,D,E

Question 9

user_data is a non-encrypted tablespace containing tables with data.
You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)

A. Use altertablespace to encrypt the tablespace.

B. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space

C. Use CREATE TABLE AS SELECT

D. Use ALTERTABLE. . .MOVE

E. Use Data Pump.

Correct Answer: C,D,E

Question 10

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. usage of the AUDIT statement

B. configuration of unified auditing mode

C. creation of a fine grained audit policy

D. execution of SQL statements by users connected with the SYSDBA privilege

Correct Answer: A

Question 11

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

A. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

B. Database Replay

C. Active Session History (ASH) report

D. SQL Performance Analyzer

Correct Answer: A

Question 12

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? (Choose two.)

A. The value of the memory_max_target parameter remains zero for the database instance.

B. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

C. The pga_aggregate_target and sga_target parameters are automatically set to zero.

D. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

E. The memory_max_target parameter is automatically set to 500 MB.

Correct Answer: B,E

Question 13

Which three RMAN persistent settings can be set for a database? (Choose three.)

A. default section size for backups

B. backup retention policy

C. default backup device type

D. default destinations for backups

E. multiple backup device types for a single backup

Correct Answer: B,C,D

Question 14

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

A. Tables or table partitions can be recovered by using an auxiliary instance only.

B. Tables with NOT NULL constraints cannot be recovered.

C. Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.

D. Tables or table partitions can be recovered only when the database is in MOUNT state.

E. Tables or table partitions with a foreign key cannot be recovered.

Correct Answer: A,C

Question 15

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 CDB1 container database (CDB):
SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE
UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

A. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.

B. undotbs1 is used as the undo tablespace for both the root and seed databases.

C. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

D. The files created for both the root and seed databases use Oracle Managed Files (OMF).

E. It sets the users tablespace as the default for both the root and seed databases.

F. It creates a multitenant container database with the root database opened and the seed database mounted.

Correct Answer: B,C,D

Welcome to TestSimulate

Oracle Database 12c: Advanced Administration (1z1-063) Free Practice Test