Create Next App

Exam contains 175 questions

Page 7 of 30

Question 37 🔥

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):Which three are prerequisites for successful execution of the command? (Choose three.)

Which database solution meets these requirements?

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

Highly voted

B. All the user-defined tablespaces must be in read-only mode on the source database.

Highly voted

C. The export dump file must be created before starting the import on the target database.

Highly voted

D. The source and target database must be running on the same platform with the same endianness.

Highly voted

E. The path of data files on the target database must be the same as that on the source database.

Highly voted

F. The impdp operation must be performed by the same user that performed the expdp operation.

Highly voted

Discussion of the question

Question 38 🔥

Which two are true concerning a multitenant container database with three pluggable database?

Which database solution meets these requirements?

A. All administration tasks must be done to a specific pluggable database.

Highly voted

B. The pluggable databases increase patching time.

Highly voted

C. The pluggable databases reduce administration effort.

Highly voted

D. The pluggable databases are patched together.

Highly voted

E. Pluggable databases are only used for database consolidation.

Highly voted

Discussion of the question

Question 39 🔥

In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

Which database solution meets these requirements?

A. when a registered database is opened with the RESETLOGS option

Highly voted

B. when a redo log is archived

Highly voted

C. when backup metadata records are aged out of the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter value

Highly voted

D. when the backup retention policy configuration is changed for a registered database

Highly voted

E. when a manual redo log switch is performed

Highly voted

Discussion of the question

Question 40 🔥

Examine the current values for the following parameters in your database instance:SGA_MAX_SIZE = 1024M -SGA_TARGET = 700M -DB_8K_CACHE_SIZE = 124M -LOG_BUFFER = 200M -You issue the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;Which statement is true?

Which database solution meets these requirements?

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

Highly voted

B. It succeeds only if memory is available from the autotuned components if SGA.

Highly voted

C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

Highly voted

D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Highly voted

Discussion of the question

Question 41 🔥

Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACENORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact.You issue a SHUTDOWN ABORT.How should you recover the control file to its default location?

Which database solution meets these requirements?

C. Issue the STARTUP MOUNT command, restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP CONTROLFILE.

Highly voted

D. Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

Highly voted

A. Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with the RESETLOGS option.

Highly voted

B. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location, issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL, and open the database with the RESETLOGS option.

Highly voted

Discussion of the question

Question 42 🔥

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

Which database solution meets these requirements?

A. OMF cannot be used in a database that already has data files created with user-specified directions.

Highly voted

B. The file system directions that are specified by OMF parameters are created automatically.

Highly voted

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

Highly voted

D. OMF automatically creates unique file names for table spaces and control files.

Highly voted

E. OMF may affect the location of the redo log files and archived log files.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_060

Exam contains 175 questions

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

Company

Product

Resources

Follow us