Free Oracle 1z0-063 Practice Test & Real Exam Questions, Page 1

Question #1

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 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.

B. It fails because RMAN is not connected to the target database with DBID=1423241.

C. It fails because the target database and recovery catalog database are of different versions.

D. It succeeds but the database is not automatically registered in the RC12c catalog.

Discussion 0

Correct Answer: C Vote an answer

Question #2

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true? (Choose two.)

A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

C. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

D. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #3

Which two parameters must be set to configure the fast recovery area? (Choose two.)

A. DB_CREATE_FILE_DEST

B. DB_RECOVERY_FILE_DEST

C. DB_FLASHBACK_RETENTION_TARGET

D. LOG_ARCHIVE_DEST

E. DB_RECOVERY_FILE_DEST_SIZE

F. at least two locations using DB_CREATE _ONLINE_LOG_DEST_n

Discussion 0

Correct Answer: B,E Vote an answer

Question #4

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods for recovering the truncated table data? (Choose two.)

A. Flashback Transaction Backout

B. Tablespace Point-in-Time Recovery

C. Table Point-in-Time Recovery

D. Database Point-in-Time Recovery

E. Flashback Database

Discussion 0

Correct Answer: D,E Vote an answer

Question #5

Examine the RMAN command:

Which statement is true about the command?

A. It creates compressed backup sets.

B. It uses multisection backup.

C. It uses asynchronous I/O for the backup.

D. It uses parallelization for the backup set.

Discussion 0

Correct Answer: D Vote an answer

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

Question #6

Which two statements are true about making RMAN image copies of a database? (Choose two.)

A. They can be made only when the database is running in ARCHIVELOG mode.

B. They can only be written to disk.

C. They can be made only when the database is running in NOARCHIVELOG mode.

D. They can be made only when the database is in MOUNT state.

E. They consist of all used and unused blocks in the data files.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #7

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

A. They can be used only for nonpartitioned tables.

B. Fragmentation is minimized by using variable-sized chunks.

C. The amount of undo retained is user controlled.

D. They support random reads and writes of encrypted LOB data.

Discussion 0

Correct Answer: B,D Vote an answer

Question #8

Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?

A. when recovering a table that has been logically corrupted

B. when recovering data that was lost after a DDL operation modified the structure of a table

C. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo

D. when recovering a table to a point in time

E. when recovering dropped tables that are present in the recyclebin

Discussion 0

Correct Answer: D Vote an answer

Question #9

In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

A. No other table with the same name should exist in the HR schema.

B. SCOTT should have the SELECT privilege on the HR schema and its recycle bin.

C. Undo retention guarantee must be enabled.

D. No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema.

E. The recycle bin should be enabled.

F. SCOTT should have the FLASHBACK ANY TABLE privilege.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question #10

Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)

A. The owner of VPC cannot own recovery catalog.

B. The register database privilege should be granted to the virtual catalog owner.

C. The recovery_catalog_owner role should be granted to the virtual catalog owner.

D. A base recovery catalog should exist.

E. At least one target database should be registered in the recovery catalog.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #11

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace? (Choose two.)

A. Create a new temporary tablespace and assign it as the default to the user.

B. Drop the tenp01.dbf file, and then re-create the temp file.

C. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

D. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

E. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

Discussion 0

Correct Answer: A,E Vote an answer

Question #12

Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command? (Choose two.)

A. The root and the seed database in the container database (CDB) are also duplicated.

B. The SPFILE is copied along with the data files of the pluggable databases (PDBs).

C. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

D. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.

E. A backup of pdb1 and pdb5 must exist before executing the command.

Discussion 0

Correct Answer: A,E Vote an answer

Question #13

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

A. All the read-only tablespaces should be made online with logging disabled.

B. All the read-only tablespaces should be restored separately.

C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

D. All the read-only tablespaces should be taken offline.

Discussion 0

Correct Answer: D Vote an answer

Question #14

You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOGS option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option.
Identify the required steps in the correct order.

A. 1, 2, 6, 3, 7, 10, 9

B. 1, 2, 6, 3, 8, 11, 9

C. 1, 3, 8, 11, 9

D. 1, 3, 7, 10, 9

E. 4, 8, 11, 5

Discussion 0

Correct Answer: A Vote an answer

Free Oracle 1z0-063 Practice Test & Real Exam Questions

Download Free Oracle 1z0-063 Demo