Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 131:

  One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:

  SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;

  SQL> CREATE ROLE C##CONNECT;

  SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

  SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

  Which three are true? (Choose three.)

  A. The C##CONNECT role can be granted different roles and privileges in each PDB.
  B. C##ADMIN has the orcl123 password in all PDBs.
  C. The C##CONNECT role is granted to the C##ADMIN user in all PDBs.
  D. CREATE SESSION is granted to the C##ADMIN user in all PDBs.
  E. The C##CONNECT role is a local role defined only in CDB$ROOT.
  A. The C##CONNECT role can be granted different roles and privileges in each PDB.
  C. The C##CONNECT role is granted to the C##ADMIN user in all PDBs.
  E. The C##CONNECT role is a local role defined only in CDB$ROOT.

• Question 132:

  You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

  A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
  B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
  C. by using Active Session History (ASH) data and performing hang analysis
  D. by running ADDM in diagnostic mode
  A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

• Question 133:

  Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.

  Which three are prerequisites to fulfill this requirement? (Choose three.)

  A. Minimal supplemental logging must be enabled.
  B. The database must be running in archivelog mode.
  C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
  D. The flashback any table privilege must be granted to the user.
  E. The select any transaction privilege must be granted to the user.
  F. The recycle bin parameter must be set to on.
  A. Minimal supplemental logging must be enabled.
  B. The database must be running in archivelog mode.
  E. The select any transaction privilege must be granted to the user.

• Question 134:

  One of your databases is in ARRCHIVELOG mode.

  You back up the database by using RMAN with a recovery catalog.

  One data file and all the control files are corrupt due to corruption in the storage array.

  Examine this list of possible actions to recover the database:

  1.

  Restore the control files by using the RESTORE CONTROLFILE command.

  2.

  Mount the database.

  3.

  Restore the data files by using the RESTORE DATABASE command.

  4.

  Open the database with the RESETLOGS option.

  5.

  Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.

  6.

  Start the target database instance in NOMOUNT state.

  7.

  Connect to the target database and the recovery catalog database instance.

  8.

  Restore the SPFILE by using the RESTORE SPFILE command

  9.

  Restore the corrupt data file.

  10.

  Recover the restored data file.

  Identify the minimum required steps in the correct order.

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

• Question 135:

  A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:

  RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;

  Which statement is true about the execution of the command?

  A. The backup succeeds only if all the tablespaces are locally managed.
  B. The backup succeeds only if the RMAN default device for backup is set to disk.
  C. The backup fails because you cannot specify section size for a compressed backup.
  D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.
  D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

• Question 136:

  Which two statements are true regarding Oracle Data Pump? (Choose two.)

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

• Question 137:

  Which three RMAN persistent settings can be set explicitly? (Choose three.)

  A. archivelog deletion policy
  B. SPFILE backup duplexing
  C. image copy duplexing
  D. archivelog backup duplexing
  E. redo log backup duplexing
  F. controlfile autobackup formats
  A. archivelog deletion policy
  C. image copy duplexing
  F. controlfile autobackup formats

• Question 138:

  You created a tablespace with this statement:

  CREATE BIGFILE TABLESPACE adtbs

  DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

  The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

  Which two alter statements will achieve this? (Choose two.)

  A. ALTER TABLESPACE adtbs RESI2E 20G;
  B. ALTER TABLESPACE adtbs ADD DATAFILE;
  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
  D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
  E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
  A. ALTER TABLESPACE adtbs RESI2E 20G;
  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

• Question 139:

  What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

  A. It generates a log file containing the fixes that can be made to the source database.
  B. It recompiles all invalid PLSQL and Java code.
  C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
  D. It provides a summary of the upgrade results.
  E. It generates fixup scripts to be run on the source database before upgrade.
  C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

• Question 140:

  Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

  

  Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

  A. The command fails and gives an error because object privileges cannot be granted to a common user.
  B. The command fails because container is not set to current.
  C. The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.
  D. The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.
  E. The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.
  C. The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.