1Z0_063 questions • Exam prepare

Exam contains 263 questions

Page 29 of 44

Question 169 🔥

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Which database solution meets these requirements?

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset

E. The DMU can report columns that are not represented in the converted characterset

Discussion of the question

Question 170 🔥

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Which database solution meets these requirements?

A. to store backup information of multiple databases in one place

Highly voted

B. to restrict the amount of space that is used by backups

C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

Highly voted

D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog

Highly voted

E. to automatically delete obsolete backups after a specified period of time

Discussion of the question

Question 171 🔥

Which two statements are true regarding Oracle Data Pump?

Which database solution meets these requirements?

A. EXPDP and IMPDP are the client components of Oracle Data Pump.

Highly voted

B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

Highly voted

C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Discussion of the question

Question 172 🔥

Which two statements are true about making RMAN image copies of a database?

Which database solution meets these requirements?

A. The can only be written to disk.

B. The can be made only when the database is running in NOARCHIVELOG mode.

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

D. They consist of all used an unused blocks in the data files.

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

Discussion of the question

Question 173 🔥

The CATDBI2c 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 RCII 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?

Which database solution meets these requirements?

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

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

Highly voted

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

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

Discussion of the question

Question 174 🔥

You issue the command:SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;Which statement is true about the command?

Which database solution meets these requirements?

A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

B. It creates a file that contains the SQL statement, which is required to re-create the control file.

C. It updates the alert log file with the location and contents of the control file.

D. It creates a binary backup of the control file.

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