1z0-063 by Oracle Valid Free Exam Practice Test

Question 1

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Correct Answer: B

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

Question 2

Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?

A. It fails because there is no connection to a recovery catalog. B. It succeeds and creates multisection backup sets that are used for active database duplication. C. It fails because no parallel channels are allocated for the auxiliary database. D. It succeeds only if the target database is in MOUNT state.

Correct Answer: B

Question 3

Examine this parameter in a database's PFILE:
DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/'
You execute this command:

Which three are true after successful database creation? (Choose three.)

A. The files created for both the root and seed databases use Oracle Managed Files (OMF). B. USERS will be the default tablespace for PDB$SEED. C. Local Undo is enabled. D. PDB$SEED is open read-only. E. CDB$ROOT is open read/write. F. PDB$SEED is mounted.

Correct Answer: A,C,F

Question 4

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:
i. 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?

A. ROW STORE COMPRESS BASIC B. SHRINK SPACE COMPACT C. DEALLOCATE UNUSED D. SHRINK SPACE CASCADE

Correct Answer: B

Question 5

Which three RMAN persistent settings can be set explicitly? (Choose three.)

A. redo log backup duplexing B. archivelog backup duplexing C. SPFILE backup duplexing D. controlfile autobackup formats E. archivelog deletion policy F. image copy duplexing

Correct Answer: D,E,F

Question 6

Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')),
PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')),
PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')),
PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items
(po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)

A. Partitions of purchase_order_items are assigned unique names based on a sequence. B. The purchase_orders and purchase_order_items tables are created with four partition each. C. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint. D. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions. E. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

Correct Answer: B,D

Question 7

Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
Which statement is true about the backup of the tools tablespace?

A. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window. B. RMAN skips the backup of the tools tablespace because backup optimization is enabled. C. The RMAN backup fails because the tools tablespace is read-only. D. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

Correct Answer: A

Question 8

Which two statements are true about unified auditing? (Choose two.)

A. Audit records are created only for the DML and DDL operations performed on database objects. B. Unified auditing is enabled by setting the audit_trail parameter to db, extended. C. A unified audit trail captures audit information from unified audit policies and audit settings. D. Audit records are created for all users except sys. E. Unified auditing is enabled by executing make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME. F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Correct Answer: C,E

Question 9

You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)

A. The database must be opened. B. The database must be mounted. C. The Fast Recovery Area must be configured. D. Undo retention guarantee must be enabled. E. The database must be in ARCHIVELOG mode. F. Flashback Database must be enabled.

Correct Answer: C,E

Question 10

Which two statements are true when row-archival management is enabled? (Choose two.)

A. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active. B. The row archival visibility session parameter defaults to all rows. C. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query. D. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter. E. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

Correct Answer: C,E

Question 11

Which two statements are true regarding Oracle Data Pump? (Choose two.)

A. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility. B. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands. C. EXPDP and IMPDP are the client components of Oracle Data Pump. D. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients. E. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

Correct Answer: C,D

Question 12

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A. The backup must be performed in MOUNT state. B. The database must be backed up as an image copy. C. All files must be backed up as backup sets. D. The tablespace must be taken offline.

Correct Answer: C

Question 13

Which two statements are true regarding SecureFile lobs? (Choose two.)

A. Fragmentation is minimized by using variable-sized chunks. B. The amount of undo retained is user controlled. C. They can be used only for nonpartitioned tables. D. They support random reads and writes of encrypted LOB data.

Correct Answer: A,D

Oracle Database 12c: Advanced Administration - 1z0-063 Exam Practice Test