Oracle 1Z0-063 Free Practice Questions 2021

NEW QUESTION 1
Your production database is running in ARCHIVELOG mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

• A. by using the RMAN SWITCH command to set the new location for the data files
• B. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host
• C. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host
• D. by creating a new database in the new host, and then using the RMAN RECOVER command

Answer: B

NEW QUESTION 2
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.

Answer: AB

NEW QUESTION 3
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v(v_emp_idNUMBER,v_enameVARCHAR2, v_SALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

• A. Create the create_test procedure with definer's rights.
• B. Grant the execute privilege to users with grant option on the create_test procedure.
• C. Create the create_test procedure with invoker's rights.
• D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Answer: C

NEW QUESTION 4
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

Answer: C

NEW QUESTION 5
Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

• A. Local roles can be granted to local and common users.
• B. A common role can be granted only to a common user.
• C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
• D. A common role can be granted only system privileges.
• E. The root container can have both local and common roles.
• F. A local role can be assigned to a common role in a PDB.

Answer: AF

NEW QUESTION 6
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

NEW QUESTION 7
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. 1, 4, 6, 5, 8, 3, 9
• B. 1, 6, 4, 5, 8, 3, 9
• C. 2, 4, 6, 5, 8, 3, 7
• D. 2, 4, 5, 8, 3, 7, 9

Answer: C

NEW QUESTION 8
Which three statements are true about common roles? (Choose three.)

• A. A common role can be granted only to a common user.
• B. Only system privileges can be granted to a common role in a container database (CDB).
• C. Object privileges can be granted to a common role in a pluggable database (PDB).
• D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
• E. A common role cannot be created by a local user.

Answer: CDE

Explanation: C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on.
D: Common users can both create and grant common roles to other common and local users. E: Local users cannot create common roles.
Note: A common role is a role that is created in the root; a local role is created in a PDB.

NEW QUESTION 9
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE

NEW QUESTION 10
You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

• A. Execute catproc.sql to recompile invalid PL/SQL modules.
• B. Open the database with the RESETLOGS option.
• C. Set a new database identifier (DBID) for the newly restored database.
• D. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

Answer: B

NEW QUESTION 11
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PDB1 are cloned in PDB2.
• E. pdb2 is created with its own private undo and temp tablespaces.

Answer: AC

NEW QUESTION 12
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSI0N=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters. Identify the required steps in the correct order.

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

Answer: A

NEW QUESTION 13
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

• A. A PDB opened in restricted mode allows only local users to connect.
• B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
• C. When a CDB is in MOUNT state, PDBs are automatically placed in MOUNT state.
• D. All PDBs must be shut down before shutting down a CDB instance.
• E. When a CDB instance is started, PDBs can be placed in OPEN state by using database triggers or by executing the ALTER PLUGGABLE DATABASE command.

Answer: BCE

NEW QUESTION 14
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

• A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
• B. It creates a file that contains the SQL statement, which is required to re-create the control file.
• C. It updates the alert log file with the location and contents of the control file.
• D. It creates a binary backup of the control file.

Answer: B

NEW QUESTION 15
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

• A. Use PDB$SEED for creating a PDB.
• B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
• C. Clone the existing PDB.
• D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
• E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Answer: BCD

NEW QUESTION 16
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:

What is the outcome of the import?

• A. It fails because the target database and recovery catalog database are of different versions.
• B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
• C. It succeeds but the database is not automatically registered in the RC12c catalog.
• D. It fails because RMAN is not connected to the target database with DBID=1423241.

Answer: A

NEW QUESTION 17
In which situation can you use Flashback Database?

• A. when undoing a shrink data file operation
• B. when retrieving a dropped tablespace
• C. when returning to a point in time before the restoration or re-creation of a control file
• D. when returning to a point in time before the most recent OPEN RESETLOGS operation

Answer: B

NEW QUESTION 18
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
------------------------- 0
SQL> EXECDBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you do to activate the new default value for numeric full redaction?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.