1z0-063 by Oracle Actual Free Exam Q&As

Question 1

Which three statements are true about a job chain? (Choose three.)

A. It cannot invoke the same program or nested chain in multiple steps in the chain. B. It can be executed using event-based or time-based schedules. C. It can contain a nested chain of jobs. D. It can be used to implement dependency-based scheduling. E. It cannot have more than one dependency.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 2

Examine these actions:
1. Log in to CDB$ROOT as a user with the SYSDBA privilege.
2. Log in to the PDB as a user with the SYSKM privilege.
3. Ensure that the CD keystore is open.
4. Ensure that the CDB keystore is closed.
5. Export the PDB key information.
6. Export the CDB key information.
7. Shut down the CDB.
8. Shut down the PDB.
9. Unplug the PDB.
Which of these are required to unplug an encrypted PDB?

A. l, 3, 5, 7, 9 B. 1, 3, 5, 8, 9 C. 1, 3, 5, 9 D. 2, 3, 6, 8 E. 1, 4, 5, 7, 9 F. 2, 4, 5, 7

Discussion 0

Correct Answer: A Vote an answer

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

Question 3

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

A. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query. B. 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. C. 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. D. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter. E. The row archival visibility session parameter defaults to all rows.

Discussion 0

Correct Answer: A,B Vote an answer

Question 4

Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

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

Discussion 0

Correct Answer: D Vote an answer

Question 5

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

A. Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered. B. Tables or table partitions can be recovered only when the database is in MOUNT state. C. Tables or table partitions with a foreign key cannot be recovered. D. Tables with NOT NULL constraints cannot be recovered. E. Tables or table partitions can be recovered by using an auxiliary instance only.

Discussion 0

Correct Answer: A,E Vote an answer

Question 6

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A. A PDB must be in closed state before it can be unplugged. B. A PDB must have been opened at least once after creation. C. PDB data files are automatically removed from disk. D. An unplugged PDB can be plugged into the same or another container database (CDB). E. A PDB must be in MOUNT state before it can be unplugged.

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question 7

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 Performance Analyzer B. Automatic Database Diagnostic Monitor (ADDM) C. SQL Access Advisor D. Automatic Workload Repository (AWR) report E. SQL Tuning Advisor

Discussion 0

Correct Answer: C Vote an answer

Question 8

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

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

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 9

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

A. ALTER TABLESPACE adtbs ADD DATAFILE; B. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON; C. ALTER TABLESPACE adtbs AUTOEXTEND ON; D. ALTER TABLESPACE adtbs RESI2E 20G; E. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 10

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

What is the outcome?

A. RMAN uses the push method to transfer backup sets. B. RMAN uses the push method to transfer image copies. C. RMAN uses the pull method to restore files using image copies. D. RMAN uses the pull method to restore files using backup sets.

Discussion 0

Correct Answer: D Vote an answer

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

Question 11

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

A. A custom database template B. Automatic Storage Management (ASM) for storage of data files C. A file system for storage of data files D. A Data Warehouse database template

Discussion 0

Correct Answer: A Vote an answer

Question 12

Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?

A. Data from the third year is purged from the flashback archive FDA1. B. Flashback archive FDA1 retains all data and the retention period is increased by 2 years. C. Data from the first and third years is purged from the flashback archive FDA1. D. An error is returned because the retention period cannot be reduced. E. Data older than two years, if any, is purged from the flashback archive FDA1.

Discussion 0

Correct Answer: B Vote an answer

Question 13

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

A. All the PDBs are in closed state. B. All the PDBs are opened in read-write mode. C. The root, the seed, and all the PDBs are opened in read-write mode. D. All redo log files are opened. E. Only the root database is opened in read-write mode.

Discussion 0

Correct Answer: D,E Vote an answer

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