1Z0_067 questions • Exam prepare

Exam contains 176 questions

Page 20 of 30

Question 115 🔥

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Which database solution meets these requirements?

A. The ADR base is shared across multiple instances.

B. The ADR base keeps all diagnostic information in binary format.

C. The ADR can be used to store statspack snapshots to diagnose database performance issues.

Highly voted

D. The ADR can be used for problem diagnosis even when the database instance is down.

Highly voted

E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Discussion of the question

Question 116 🔥

user_data is a nonencryptedtablespace containing tables with data.You must encrypt ail data in this tablespace.Which three methods can do this?

Which database solution meets these requirements?

A. Use Data Pump.

B. Use ALTERTABLE. . .MOVE

C. Use CREATE TABLE AS SELECT

D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its

E. Use altertablespace to encrypt the tablespace.

Discussion of the question

Question 117 🔥

Which two statements are true about a common user?

Which database solution meets these requirements?

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

B. A common user with the create user privilege can create other common users, as well as local users.

C. A common user can be granted only a common role.

Highly voted

D. A common user can have a local schema in a PDB.

Highly voted

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Discussion of the question

Question 118 🔥

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup onSundays 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.Which action must you take for recovery?

Which database solution meets these requirements?

A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

C. Restore all the data files, recover them by using the recover database command, and open the database.

D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Discussion of the question

Question 119 🔥

Which three statements are true about Oracle Restart?

Which database solution meets these requirements?

A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

D. It can be used to only start Oracle components.

E. It runs periodic check operations to monitor the health of Oracle components.

Discussion of the question

Question 120 🔥

Examine the parameters for your database instance:NAMETYPEVALUE ------------------------------------------------------------------------------------------------------ optimizer_adaptive_reporting_onlybooleanFALSE optimizer_capture_sql_plan_baselinesbooleanFALSE optimizer_dynamic_samplinginteger2 optimizer_features_enablestring12.1.0.1Which three statements are true about the process of automatic optimization by using statistics feedback?

Which database solution meets these requirements?

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

B. The optimizer can re optimize a query only once using cardinality feedback.

C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_067

Exam contains 176 questions

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

Company

Product

Resources

Follow us