1Z0_063 questions • Exam prepare

Exam contains 263 questions

Page 32 of 44

Question 187 🔥

You are connected to a recovery catalog and target database. You execute the command:RMAN> CATALOG START WITH /disk1/backups;Which statement is true?

Which database solution meets these requirements?

A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

B. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

C. It lists all data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.

D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their

Discussion of the question

Question 188 🔥

A database instance uses an SPFILE. Examine the parameter:You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.Examine the possible steps that are in random order:1. Shut down the database instance.2. Issue ALTER SYSTEM SET CONTROL_FILES= /u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/ disk2/control02, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl SCOPE=SPFILE;.3. Issue ALTER SYSTEM SET CONTROL_FILES=/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/app/oracle/ oradata/cdb1/disk3/control03.ctl;.4. Copy the control file from the existing location to /u01/app/oracle/oradata/cdb1/disk3/control03.ctl.5. Mount the database.6. Open the database.Identify the required steps in the correct order to accomplish the task.

Which database solution meets these requirements?

Discussion of the question

Question 189 🔥

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.Which two statements are true about the dependent objects of the CUSTOMERS table?

Which database solution meets these requirements?

A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.

Highly voted

C. All the triggers associated with the table are flashed back but are disabled.

D. Materialized views that use the CUSTOMERS table are flashed back.

E. LOB segments associated with the CUSTOMERS table are flashed back.

Highly voted

Discussion of the question

Question 190 🔥

Which three statements are true about the database instance startup after an instance failure?

Which database solution meets these requirements?

A. The RECO process recovers the uncommitted transactions at the next instance startup.

Highly voted

B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

C. Uncommitted changes are rolled back to ensure transactional consistency.

Highly voted

D. The SMON process coordinates the database recovery.

Highly voted

E. Media recovery is required to complete the database recovery.

F. Changes committed before the failure, which were not written to the data files, are re-applied.

Discussion of the question

Question 191 🔥

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).Examine the steps required to perform the migration:1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.2. Place all tablespaces in read-only mode on the source database.3. Upgrade the source database to Oracle Database 12c.4. Copy the dump file and data files to the desired location in the target database.5. Create a new PDB in the target CDB.6. Synchronize the PDB on the target CDB.7. Use Data Pump import on the new PDB by using the full transportable import options.Identify the required steps in the correct order.

Which database solution meets these requirements?

A. 1, 5, 4, 7, and 6

B. 3, 2, 5, 1, 4, and 7

C. 2, 5, 1, 4, 7, and 6

D. 2, 1, 3, 5, 7, and 6

Discussion of the question

Question 192 🔥

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

Which database solution meets these requirements?

A. RMAN uses the push method to transfer image copies.

B. RMAN uses the push method to transfer backup sets.

C. RMAN uses the pull method to restore files using backup sets.

D. RMAN uses the pull method to restore files using image copies.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_063

Exam contains 263 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us