1Z0_063 questions • Exam prepare

Exam contains 263 questions

Page 20 of 44

Question 115 🔥

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 116 🔥

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.

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

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 117 🔥

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.

Highly voted

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 118 🔥

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.

Highly voted

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

Highly voted

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.

Highly voted

Discussion of the question

Question 119 🔥

Examine the parameters for your database instance:NAMETYPEVALUE -------------------------------------------------optimizer_adaptive_reporting_onlybooleanFALSEoptimizer_capture_sql_plan_baselinesbooleanFALSEoptimizer_dynamic_samplinginteger2optimizer_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.

Highly voted

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.

Highly voted

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

Highly voted

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

Question 120 🔥

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Which database solution meets these requirements?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

B. A job defined in a PDB runs only if that PDB is open.

Highly voted

C. Scheduler attribute setting is performed only at the CDB level.

D. Scheduler objects created by users can be exported or imported using Data Pump.

Highly voted

E. Scheduler jobs for a PDB can be created only by common users.

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