Create Next App

Exam contains 175 questions

Page 1 of 30

Question 1 🔥

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.A user issues a query on a table on one of the PDBs and receives the following error:ERROR at line 1:ORA-01565: error in identifying file /u01/app/oracle/oradata/CDB1/temp01.tmpORA-27037: unable to obtain file statusIdentify two ways to rectify the error. (Choose two.)

Which database solution meets these requirements?

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

Highly voted

D. Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.

Highly voted

E. Shut down the database instance and then restart the CDB and PDBs.

Highly voted

A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.

Highly voted

B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

Highly voted

Discussion of the question

Question 2 🔥

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table? (Choose two.)

Which database solution meets these requirements?

A. All the triggers for the table are disabled without changing any of the column names or column types in the table.

Highly voted

B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

Highly voted

C. VPD policies are copied from the original table to the new table during online redefinition.

Highly voted

D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Highly voted

Discussion of the question

Question 3 🔥

To complete the online redefinition procedure, you execute the following command;EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE("˜SH', "˜SALES', "˜INT_SALES', 600);What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

Which database solution meets these requirements?

A. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.

Highly voted

B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

Highly voted

C. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.

Highly voted

D. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

Highly voted

Discussion of the question

Question 4 🔥

Which statement is true about Oracle Net Listener?

Which database solution meets these requirements?

E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directory.

Highly voted

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

Highly voted

B. A single listener can service only one database instance and multiple remote client connections.

Highly voted

C. Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.

Highly voted

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

Highly voted

Discussion of the question

Question 5 🔥

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.In which three ways can you re-create the lost disk group and restore the data?

Which database solution meets these requirements?

A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

Highly voted

B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

Highly voted

C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

Highly voted

D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

Highly voted

F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore

Highly voted

E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

Highly voted

Discussion of the question

Question 6 🔥

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