Create Next App

Exam contains 149 questions

Page 14 of 25

Question 79 🔥

Which two statements about switchover and failover are true?

Which database solution meets these requirements?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.

Highly voted

B. Neither a switchover nor a failover is possible to a far sync instance.

Highly voted

C. For fast-start failover, you must preselect the target standby database that will be used.

Highly voted

D. You can activate a standby database to test whether it is being updated correctly.

Highly voted

Discussion of the question

Question 80 🔥

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

Which database solution meets these requirements?

E. all server-generated alerts

Highly voted

A. Oracle Database alert.log file

Highly voted

B. object-level statistics

Highly voted

C. Automatic SGA Memory Management

Highly voted

D. Oracle Database Trace files

Highly voted

Discussion of the question

Question 81 🔥

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

Which database solution meets these requirements?

A. You can perform complete recovery by using the command:RESTORE DATABASEFROM TAG"consistent_whole_backup";RECOVER DATABASE;

Highly voted

B. You can perform incomplete recovery by using the command:RESTORE DATABASE;FROM TAG "consistent_whole_backup";RECOVER DATABASE NOREDO;

Highly voted

C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

Highly voted

D. Media recovery is possible in most cases.

Highly voted

Discussion of the question

Question 82 🔥

Which statement about a server parameter file (SPFILE) is false?

Which database solution meets these requirements?

A. An SPFILE is a binary file that cannot be edited by using a text editor.

Highly voted

B. You can create an SPFILE from an existing text initialization parameter file or from memory.

Highly voted

C. You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.

Highly voted

D. The instance first searches for an SPFILE named spfileoRACLE_SIora and, if this is not found. It searches for spfile.ora.

Highly voted

Discussion of the question

Question 83 🔥

Which statement about the Queryable Patch inventory feature is false?

Which database solution meets these requirements?

A. It is used to retrieve installed patch information from a SQL prompt.

Highly voted

B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

Highly voted

C. DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

Highly voted

D. It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

Highly voted

Discussion of the question

Question 84 🔥

Which database solution meets these requirements?

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_497

Exam contains 149 questions

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

Company

Product

Resources

Follow us