Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 101:

  You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command. What is the outcome?

  A. The PDB is closed and left in the mount state.
  B. The PDB is closed and left in the unmount state.
  C. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.
  D. The command results in an error because the PDB can be shut down only by a local user.
  B. The PDB is closed and left in the unmount state.

• Question 102:

  Which two statements are true about RMAN duplexed backups? (Choose two.)

  A. It is only supported for backups to tape via the media management interface.
  B. It is not supported for image copies.
  C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
  E. Duplex backups can contain only data files and control files.
  B. It is not supported for image copies.
  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

• Question 103:

  You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.

  One of the data files is corrupted and the current online redo log file is lost because of a media failure.

  You want to recover the data file.

  Examine the steps involved in the recovery process:

  1.

  Shut down the database instance.

  2.

  Start up the database instance in nomount state.

  3.

  Mount the database.

  4.

  Take the data file offline.

  5.

  Put the data file online.

  6.

  Restore the control file.

  7.

  Restore the database.

  8.

  Restore the data file.

  9.

  Open the database with the RESETLOGS option.

  10.

  Recover the database with the NOREDO option.

  11.

  Recover the data file with the NOREDO option. Identify the required steps in the correct order.

  A. 4, 8, 11, 5
  B. 1, 3, 8, 11, 9
  C. 1, 2, 6, 3, 7, 10, 9
  D. 1, 3, 7, 10, 9
  E. 1, 2, 6, 3, 8, 11, 9
  C. 1, 2, 6, 3, 7, 10, 9

• Question 104:

  Examine the RMAN commands executed in your database:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

  RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  You issue the command:

  RMAN> BACKUP DATABASE;

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

  A. It performs a log switch.
  B. It creates compressed backup sets by using binary compression by default.
  C. It backs up only the used blocks in data files.
  D. It backs up data files, the control file, and the server parameter file.
  E. It creates a backup of only the control file whenever the database undergoes a structural change.
  C. It backs up only the used blocks in data files.
  D. It backs up data files, the control file, and the server parameter file.

• Question 105:

  Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

  Which two best methods for recovering the truncated table data? (Choose two.)

  A. Table Point-in-Time Recovery
  B. Database Point-in-Time Recovery
  C. Tablespace Point-in-Time Recovery
  D. Flashback Database
  E. Flashback Transaction Backout
  B. Database Point-in-Time Recovery
  D. Flashback Database

• Question 106:

  Which three statements are true about a job chain? (Choose three.)

  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  C. It cannot invoke the same program or nested chain in multiple steps in the chain.
  D. It cannot have more than one dependency.
  E. It can be executed using event-based or time-based schedules.
  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  E. It can be executed using event-based or time-based schedules.

• Question 107:

  Your database is on ARCHIVELOG mode and an incremental backup exists. A media failure in the loss of a data file and an online redo log.

  Examine these commands:

  1.

  STARTUP NOMOUNT

  2.

  STARTUP MOUNT

  3.

  RESTORE DATABASE

  4.

  RECOVER DATABASE

  5.

  RECOVER DATABASE UNTIL CANCEL

  6.

  ALTER DATABASE OPEN

  7.

  ALTER DATABASE OPEN RESETLOGS Which commands are required to recover your database?

  A. 2, 3, 5, and 6
  B. 2, 3, and 4
  C. 2, 3, 5, and 7
  D. 1, 3, 5, and 6
  E. 1, 3, and 4
  E. 1, 3, and 4

• Question 108:

  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 pluggable 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_1 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 container database.
  B. All data files belonging to PDB2_1 are backed up along with the archive log files.

• Question 109:

  Examine the RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which prerequisite must be met before accomplishing the backup?

  A. The password for the encryption must be set up.
  B. Oracle wallet for the encryption must be set up.
  C. All the tablespaces in the database must be encrypted.
  D. Oracle Database Vault must be enabled.
  B. Oracle wallet for the encryption must be set up.

• Question 110:

  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 in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
  C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
  D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.
  B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.