Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z1-067 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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 granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB. 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 created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

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 all data files from the specified time, and then applies the redo logs C. 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 archieve logs that are needed to complete the task D. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".

Discussion 0

Correct Answer: C Vote an answer

Question 3

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when there are multiple undotablespaces available in a database B. when the undo tablespace is of a fixed size and retention guarantee is not enabled C. when Flashback Database is enabled D. when the data file of the undo tablespace is autoextensible

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

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> EXEC DBMS_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-connect the sessions that access objects with redaction policies defined on them. B. Re-create redaction policies that use FULL data redaction. C. Re-enable redaction policies that use FULL data redaction. D. Flush the shared pool. E. Restart the database instance.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.

A. 1, 2 B. 1, 2, 4 C. 1, 4, 3, 2 D. 1, 4, 3

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

Which three statements are true about Consolidated Database Replay?

A. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules. B. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB. C. A subset of the captured workload can be replayed. D. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB). E. The workload capture and replay systems must have the same operating system (OS).

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

A. The execution of the script fails because multiple channels cannot exist simultaneously. B. The script is executed and both DC1 and CH1 channels are used for script execution. C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block. D. The new channel, CH1, is ignored because a channel has been configured already.

Discussion 0

Correct Answer: C Vote an answer

Question 8

Examine the command used to perform an incremental level-0 backup:
RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?

A. The block change tracking data is used for the next incremental level 1 backup only after the next level
0 backup. B. The incremental level 1 backup does not use change tracking data for accomplishing the backup. C. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup. D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level
0 backup. E. The block change tracking data is used only from the next incremental backup.

Discussion 0

Correct Answer: A,B Vote an answer

Question 9

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A. SQL Tuning Advisor B. Automatic Database Diagnostic Monitor (ADDM) C. SQL Access Advisor D. Automatic Workload Repository (AWR) report E. SQL Performance Analyzer

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).