Online Access Free 1z1-063 Practice Test

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

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A.Oracle Recovery Manager (RMAN)
• B.Oracle Real Application Security
• C.Oracle Label Security
• D.Oracle Data Pump
• E.Oracle Database Vault

Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)

• A.when the DUPLICATE ... from ACTIVE DATABASE command contains the SECTION SIZE clause
• B.when you specify SET ENCRYPTION before the DUPLICATE ... FROM ACTIVE DATABASE command
• C.when the number of auxiliary channels allocated is equal to or greater than the number of target channels
• D.when you perform active database duplication on a database that has read-only tablespaces
• E.when you perform active database duplication on a database with flashback disabled

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 as part of a package and grant users the execute privilege on the package.
• B.Grant the execute privilege to users with grant option on the create_test procedure.
• C.Create the create_test procedure with definer's rights.
• D.Create the create_test procedure with invoker's rights.

Which parameter must be set to which value to implement automatic PGA memory management?

• A.Set STATISTICS_LEVEL to BASIC.
• B.Set sgajtarget to zero.
• C.Set memory_target to zero.
• D.Set pga_aggregate_target to a nonzero value.
• E.Set pga_aggregate_target and sga_target to the same value.