1Z0_062 questions • Exam prepare

Exam contains 381 questions

Page 24 of 64

Question 139 🔥

Which three statements are true about Flashback Database? (Choose three.)

Which database solution meets these requirements?

A. Flashback logs are written sequentially, and are archived.

B. Flashback Database uses a restored control file to recover a database.

C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

Highly voted

D. Flashback Database can recover a database to the state that it was in before a reset logs operation.

Highly voted

E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Highly voted

Discussion of the question

Question 140 🔥

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Which database solution meets these requirements?

A. By default, EM express is available for a database after database creation.

B. You can use EM express to manage multiple databases running on the same server.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You cannot start up or shut down a database Instance by using EM express.

Highly voted

E. You can create and configure pluggable databases by using EM express.

Discussion of the question

Question 141 🔥

Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?

Which database solution meets these requirements?

A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

B. All DDL commands are logged in the alert log file.

C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

D. Only DDL commands that resulted in the creation of new segments are logged.

E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Highly voted

Discussion of the question

Question 142 🔥

In which two scenarios do you use SQL* Loader to load data? (Choose two.)

Which database solution meets these requirements?

A. Transform the data while it is being loaded into the database.

B. Use transparent parallel processing without having to split the external data first.

C. Load data into multiple tables during the same load statement.

Highly voted

D. Generate unique sequential key values in specified columns.

Highly voted

Discussion of the question

Question 143 🔥

You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = * SCOPE = SPFILE;Which is true about the result of this command?

Which database solution meets these requirements?

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Discussion of the question

Question 144 🔥

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