Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 91:

  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 a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
  C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
  D. It sets the users tablespace as the default for both the root and seed databases.
  E. undotbs1 is used as the undo tablespace for both the root and seed databases.
  F. It creates a multitenant container database with the root database opened and the seed database mounted.
  A. 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.
  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
  E. undotbs1 is used as the undo tablespace for both the root and seed databases.

• Question 92:

  You wish to create jobs to satisfy these requirements:

  1.

  Automatically bulk load data from a flat file.

  2.

  Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

  A. Create both jobs by using Scheduler raised events.
  B. Create both jobs using application raised events.
  C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
  D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
  C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

• Question 93:

  Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

  A. A window specifies a resource plan that will be activated when that window becomes active.
  B. A window specifies a job class that will be activated when that window becomes active.
  C. A job class specifies a window that will be open when that job class becomes active.
  D. A window in association with a resource plan controls a job class allocation.
  E. A window in association with a job class controls a resource allocation.
  A. A window specifies a resource plan that will be activated when that window becomes active.
  E. A window in association with a job class controls a resource allocation.

• Question 94:

  Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:

  1.

  Create media families for data files and archived redo log files.

  2.

  Configure database backup storage selectors or RMAN media management parameters.

  3.

  Create an OSB user preauthorized for RMAN operations.

  4.

  Configure RMAN Access to the OSB SBT.

  5.

  Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

  A. 1, 4, 3, 2, 5
  B. 1, 3, 4, 5, 2
  C. 4, 3, 1, 2, 5
  D. 4, 3, 5, 1, 2
  C. 4, 3, 1, 2, 5

• Question 95:

  One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.

  You connect to PDB2 as a common user with DBA privileges.

  The STATISTICS_LEVEL parameter is PDB modifiable.

  As the user SYS, you execute this command successfully on PDB2:

  SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;

  Which two statements are true about the result of this command?

  A. The data dictionary in PDB2 is updated.
  B. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.
  C. The SPFILE is updated.
  D. The data dictionary in CDB$ROOT is updated.
  E. The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.
  B. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.

• Question 96:

  Examine these RMAN commands:

  

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

  A. It fails because connection to the AUXILIARY instance must be as SYSDBA.
  B. It fails because no parallel channels are allocated for the auxiliary database.
  C. It succeeds only if the target database is greater than 400M.
  D. No catalogued backup of the TARGET is used to duplicate the database.
  E. It succeeds.
  C. It succeeds only if the target database is greater than 400M.
  D. No catalogued backup of the TARGET is used to duplicate the database.

• Question 97:

  LDAP_DIRECTORY_SYSAUTH is set to YES.

  Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).

  SSL has been configured for the database and OID and the password file has been configured for the database.

  User scott with sysdba privilege tries to connect remotely using this command:

  $sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.

  Which authentication method will be attempted first?

  A. authentication by password file
  B. authentication by using certificates over SSL
  C. authentication by using the Oracle Internet Directory
  D. authentication by using the local OS of the database server
  A. authentication by password file

• Question 98:

  You issue the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

  A. switching the online redo log
  B. backing up all data files as image copies and archive logs, and deleting those archive logs
  C. backing up only the used blocks in the data files
  D. backing up all used and unused blocks in the data files
  E. backing up all archived logs and marking them as obsolete
  A. switching the online redo log
  B. backing up all data files as image copies and archive logs, and deleting those archive logs
  D. backing up all used and unused blocks in the data files

• Question 99:

  RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

  

  What is the outcome?

  A. RMAN uses the push method to transfer image copies.
  B. RMAN uses the push method to transfer backup sets.
  C. RMAN uses the pull method to restore files using backup sets.
  D. RMAN uses the pull method to restore files using image copies.
  C. RMAN uses the pull method to restore files using backup sets.

• Question 100:

  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. Database Replay
  B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  C. Active Session History (ASH) report
  D. SQL Performance Analyzer
  B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report