Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 171:

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

  A. Enable minimal supplemental logging.
  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
  C. Enable the recyclebin.
  D. Enable undo retention guarantee.
  E. Enable Fast Recovery Area.
  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
  E. Enable Fast Recovery Area.

• Question 172:

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

  A. to store backup information of multiple databases in one place
  B. to restrict the amount of space that is used by backups
  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
  D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
  E. to automatically delete obsolete backups after a specified period of time
  A. to store backup information of multiple databases in one place
  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
  D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog

• Question 173:

  Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

  A. A PDB opened in restricted mode allows only local users to connect.
  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
  C. When a CDB is in mount state, PDBs are automatically placed in mount state.
  D. All PDBs must be shut down before shutting down a CDB instance.
  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.
  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
  C. When a CDB is in mount state, PDBs are automatically placed in mount state.
  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

• Question 174:

  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 able to create views in any PDB as a result of being granted the C##ROLE1 role.
  B. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED.
  C. The c##role1 role will always have the same privileges in all current and future PDBs.
  D. The C##DBA_ADMIN user is a local user in CDB$ROOT.
  E. SYSTEM is able to create views in any PDB as a result of being a DBA user.
  F. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.
  A. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.
  C. The c##role1 role will always have the same privileges in all current and future PDBs.
  F. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

• Question 175:

  Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.

  LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'

  Identify the statement that correctly describes these settings.

  A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.
  B. Optional destinations cannot use the fast recovery area.
  C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.
  D. These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.
  C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.

• Question 176:

  You plan to create a new PDB by copying PDB$SEED.

  Which two requirements ensure a successful creation? (Choose two.)

  A. The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.
  B. A default service for the new PDB name must already exist.
  C. A PDB local administrative user must be granted the DBA role when creating the PDB.
  D. A PDB local administrative user must be specified when creating the PDB.
  E. The CDB, which will contain the PDB, must be in READ WRITE mode.
  F. The CDB must use Oracle Managed Files.
  C. A PDB local administrative user must be granted the DBA role when creating the PDB.
  E. The CDB, which will contain the PDB, must be in READ WRITE mode.

• Question 177:

  RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:

  

  Which two statements are true about the execution of the duplicate command? (Choose two.)

  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. C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
  D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
  E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.
  B. The duplicate database has the same directory structure as the source database.
  E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

• Question 178:

  You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

  A. MAXSETSIZE TO 2;
  B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

• Question 179:

  Which three statements are true about common roles? (Choose three.)

  A. A common role can be granted only to a common user.
  B. Only system privileges can be granted to a common role in a container database (CDB).
  C. Object privileges can be granted to a common role in a pluggable database (PDB).
  D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
  E. A common role cannot be created by a local user.
  C. Object privileges can be granted to a common role in a pluggable database (PDB).
  D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
  E. A common role cannot be created by a local user.

• Question 180:

  Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;

  Which two statements are true about the statistics level parameter? (Choose two.)

  A. It is immediately set to all in the SPFILE and the CDB instance.
  B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
  C. It is immediately set to all only for cd3Sroot.
  D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
  E. It is set to all for all PDBs only in the SPFILE.
  A. It is immediately set to all in the SPFILE and the CDB instance.
  B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.