Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 1:

  You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database (CDB) CDB1 and import it into the CDB2 CDB as the EMP_PDB1 PDB. Examine the list of possible steps required to perform the task:

  1.

  Create a PDB named EMP_PDB1.

  2.

  Export the HR_PDB1 PDB by using the FULL clause.

  3.

  Open the EMP_PDB1 PDB.

  4.

  Mount the EMP_PDB1 PDB.

  5.

  Synchronize the EMP_PDB1 PDB in restricted mode.

  6.

  Copy the dump file to the Data Pump directory.

  7.

  Create a Data Pump directory in the EMP_PDB1 PDB.

  8.

  Import data into EMP_PDB1 with the FULL and REMAP clauses.

  9.

  Create the same tablespaces in EMP_PDB1 as in HR_PDB1 for new local user objects. Identify the required steps in the correct order.

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

• Question 2:

  Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.

  Identify the minimum requirement for accomplishing the task.

  A. An RMAN channel must be configured to device-type disk.
  B. The database must be configured in ARCHIVELOG mode.
  C. Redo log groups must have at least two members each.
  D. All tablespaces in the database must be locally managed.
  B. The database must be configured in ARCHIVELOG mode.

• Question 3:

  Examine this command:

  RMAN> BACKUP VALIDATE DATABASE;

  Which three statements are true? (Choose three.)

  A. The command checks for blocks containing all zeros.
  B. The command checks for blocks containing an invalid checksum.
  C. The command checks for blocks containing a corrupt block header.
  D. The command checks for blocks that contain invalid column lengths.
  E. The command backs up the database regardless of the state of the blocks.
  F. The command backs up the database only if all blocks are valid.
  A. The command checks for blocks containing all zeros.
  B. The command checks for blocks containing an invalid checksum.
  C. The command checks for blocks containing a corrupt block header.

• Question 4:

  Your database is running in ARCHIVELOG mode and flashback is enabled.

  In which scenario must you use RMAN backups for recovering tables and table partitions?

  A. when recovering a table to a point in time
  B. when recovering a table that has been logically corrupted
  C. when recovering dropped tables that are present in the recyclebin
  D. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo
  E. when recovering data that was lost after a DDL operation modified the structure of a table
  A. when recovering a table to a point in time

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

  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.
  D. The valid time columns are visible by default when the table is described.
  E. 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.
  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.

• Question 6:

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

  A. When a PDB is created, a service is automatically started in the instance with the same name as the 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. Only a common user can create additional services for a PDB.
  E. When a PDB is created, a service with the same name as the PDB is created in the PDB.
  A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

• Question 7:

  Examine the RMAN command: Which statement is true about the command?

  

  A. It creates compressed backup sets.
  B. It uses asynchronous I/O for the backup.
  C. It uses parallelization for the backup set.
  D. It uses multisection backup.
  C. It uses parallelization for the backup set.

• Question 8:

  You execute the commands to configure settings in RMAN:

  

  Then, you issue the following command to take a backup:

  

  Which statement is true about the execution of these commands?

  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 backup 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.
  D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

• Question 9:

  Examine this command:

  SQL> CREATE DATABASE cdb1 DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbs1 ENABLE PLUGGABLE DATABASE SEED SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;

  Which two requirements must be met to ensure that CDB1 is created? (Choose two.)

  A. The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.
  B. The PDB_FILE_NAME_CONVERT parameter must be configured.
  C. The FILE_NAME_CONVERT clause must be added to the command.
  D. The USER_DATA TABLESPACE clause must be added to the command.
  E. The DB_CREATE_FILE_DEST parameter must be configured.
  A. The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.
  C. The FILE_NAME_CONVERT clause must be added to the command.

• Question 10:

  Examine the output:

  SQL > ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378

  Which three types of files are automatically placed in the fast recovery area? (Choose three.)

  A. Flashback data archives (FDA)
  B. Archived redo log files
  C. Control file autobackups
  D. Server parameter file (SPFILE)
  E. Recovery Manager (RMAN) backup pieces
  B. Archived redo log files
  C. Control file autobackups
  E. Recovery Manager (RMAN) backup pieces