Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 181:

  You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

  A. Long-running queries are not affected. ii. No extra space is used. iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process. iv. Unused space is reclaimed both above and below the high water mark. Which alter TABLE option would you recommend?
  B. DEALLOCATE UNUSED
  C. SHRINK SPACE CASCADE
  D. SHRINK SPACE COMPACT
  E. ROW STORE COMPRESS BASIC
  C. SHRINK SPACE CASCADE

• Question 182:

  You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:

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

  SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;

  SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

  Which two statements are true about the c##admin user that is created in all PDBs? (Choose two.)

  A. It can create only local users in all the PDBs.
  B. It has a common schema for all the PDBs.
  C. It can create common users only when it is logged in to the CDB.
  D. It can create only local users in the CDB.
  E. It can be granted only common roles in the PDBs.
  A. It can create only local users in all the PDBs.
  C. It can create common users only when it is logged in to the CDB.

• Question 183:

  Examine these actions:

  1.

  Log in to CDB$ROOT as a user with the SYSDBA privilege.

  2.

  Log in to the PDB as a user with the SYSKM privilege.

  3.

  Ensure that the CD keystore is open.

  4.

  Ensure that the CDB keystore is closed.

  5.

  Export the PDB key information.

  6.

  Export the CDB key information.

  7.

  Shut down the CDB.

  8.

  Shut down the PDB.

  9.

  Unplug the PDB.

  Which of these are required to unplug an encrypted PDB?

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

• Question 184:

  Examine this query:

  SELECT cust_name, amt_due

  FROM customers

  AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

  WHERE cust_no = 'AYR2011';

  Which two requirements guarantee that the query will execute successfully? (Choose two.)

  A. Row movement must be enabled for CUSTOMERS.
  B. Automatic Undo Management must be configured.
  C. FLASHBACK must be ON for the database.
  D. Undo retention guarantee must be enabled.
  E. The database must be in ARCHIVELOG mode.
  F. Supplemental logging must be enabled.
  B. Automatic Undo Management must be configured.
  C. FLASHBACK must be ON for the database.

• Question 185:

  Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

  A. Database Resident Connection Pooling
  B. Oracle Suggested Backup Strategy
  C. Database Vault in ORACLE_HOME
  D. Non default block size tablespaces
  E. Configure Label Security
  C. Database Vault in ORACLE_HOME
  E. Configure Label Security

• Question 186:

  In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:

  SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;

  What are three prerequisites for this command to succeed? (Choose three.)

  A. Undo retention guarantee must be enabled.
  B. No other table with the same name should exist in the HR schema.
  C. SCOTT should have the FLASHBACK ANY TABLE privilege.
  D. SCOTT should have the SELECT privilege on the HR schema and its recycle bin.
  E. No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema.
  F. The recycle bin should be enabled.
  B. No other table with the same name should exist in the HR schema.
  C. SCOTT should have the FLASHBACK ANY TABLE privilege.
  F. The recycle bin should be enabled.

• Question 187:

  Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

  A. It can be executed only from CDB$ROOT.
  B. It rolls back any pending transactions in the container from which it is executed.
  C. It will not fire login triggers for the specified container.
  D. It cannot be used to connect to PDB$SEED.
  E. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB).
  D. It cannot be used to connect to PDB$SEED.

• Question 188:

  Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

  SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA 100M ON users TEMPORARY TABLESPACE temp;

  Which statement is true about the execution of the command?

  A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
  B. The command succeeds only if all the PDBs have the USERS and TEMP tablespaces.
  C. The command gives an error because the CONTAINER=ALL clause is missing.
  D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the C##A_ADMIN user if the USERS tablespace does not exist in that PDB.
  B. The command succeeds only if all the PDBs have the USERS and TEMP tablespaces.

• Question 189:

  You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. Which two backup solutions can be used? (Choose two.)

  A. RMAN recovery catalog
  B. RMAN Media Management Library
  C. Enterprise Manager Cloud Control
  D. Enterprise Manager Database Express
  E. Oracle Secure Backup
  A. RMAN recovery catalog
  C. Enterprise Manager Cloud Control

• Question 190:

  You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

  A. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.
  B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.
  C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.
  D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.
  A. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.