1Z0_062 questions • Exam prepare

Exam contains 381 questions

Page 22 of 64

Question 127 🔥

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).The characteristics of the non-CDB are as follows:Version: Oracle Database 12c Releases 1 64-bitCharacter set: WE8ISO8859P15National character set: AL16UTF16O/S: Oracle Linux6 64-bitThe characteristics of the CDB are as follows:Version: Oracle Database 12c Release 1 64-bitCharacter set: AL32UTF8O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB?

Which database solution meets these requirements?

Discussion of the question

Question 128 🔥

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (SRV1);The possible outcome and actions to aggregate the trace files are as follows:1. The command fails because a module name is not specified.2. A trace file is created for each session that is running the SRV1 service.3. An aggregated trace file is created for all the sessions that are running the SRV1 service.4. The trace files may be aggregated by using the trcess utility.5. The trace files be aggregated by using the tkprof utility.Identify the correct outcome and the step to aggregate by using tkprof utility?

Which database solution meets these requirements?

Discussion of the question

Question 129 🔥

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:SQL > CREATE UNDO TABLESPACE undotb01DATAFILE u01/oracle/rddb1/undotbs01.dbf SIZE 60M AUTOEXTEND ON;What is the result?

Which database solution meets these requirements?

A. It executes successfully and creates an UNDO tablespace in HR_PDB.

B. It falls and reports an error because there can be only one undo tablespace in a CD

C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E. It executes successfully but neither tablespace nor the data file is created.

Highly voted

Discussion of the question

Question 130 🔥

Which three statements are true about SQL plan directives? (Choose three.)

Which database solution meets these requirements?

A. They are tied to a specific statement or SQL ID.

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

Highly voted

C. They are used to gather only missing statistics.

D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

Highly voted

E. They instruct the optimizer to create only column group statistics.

F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Highly voted

Discussion of the question

Question 131 🔥

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario? (Choose two.)

Which database solution meets these requirements?

A. The database must have multiplexed redo logs for the flashback to succeed.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must use block change tracking for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must be opened with the RESETLOGS option after the flashback is complete.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Discussion of the question

Question 132 🔥

Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?

Which database solution meets these requirements?

A. Undo data is written to flashback logs after 1200 seconds.

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

C. You can perform a Flashback Database operation only within the duration of 1200 seconds.

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

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

Company

Product

Resources

Follow us