Free Oracle 1z1-063 Exam Dumps Questions & Answers

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
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 statement is true about the c##connect role?

• A.  It is granted to the c##admin user only in the CDB.
• B.  It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
• C.  It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
• D.  It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

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

You execute the command to recover your database:

Which statement is true?

• A.  It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
• B.  It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".
• C.  It restores all data files from the specified time, and then applies the redo logs.
• D.  It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.

Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

• A.  drop and re-create the index
• B.  coalesce the indexes tablespace
• C.  perform an on line table rebuild using dbms_redefinition
• D.  coalesce the order.ind index
• E.  rebuild the index online moving it to another tablespace that has enough free space for the index

You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)

• A.  as a common user with the SET CONTAINER privilege
• B.  by using the CONNECT statement as a local user having only the SET CONTAINER privilege
• C.  by using easy connect
• D.  by executing the ALTER SESSION SET CONTAINER command as a local user
• E.  by using external authentication