1Z0_497 questions • Exam prepare

Exam contains 149 questions

Page 25 of 25

Question 145 🔥

In which situation would you use static database registration for a listener?

Which database solution meets these requirements?

A. when multiple databases are to be registered with the listener

B. when DBAs need to connect remotely to start up the database instance

C. when users need to connect the database instance by using the host naming method

D. when the database instance to be registered with the listener is configured in shared server mode

Discussion of the question

Question 146 🔥

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

Which database solution meets these requirements?

A. S sqlplus / as sysdbaSQL> restart;

B. S sqlplus / as sysdbaSQL> startup immediate;

C. S rman target /RMAN> Startup

D. S sqlplus / as sysdbaSQL> startup open recover;

E. S srvctl start database -db SORACLE_SID

Discussion of the question

Question 147 🔥

Which two statements are true about a buffer cache?

Which database solution meets these requirements?

A. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

B. A buffer cache stores copies of data blocks from all files of the database.

C. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

D. A buffer cache always resides completely in System Global Area (SGA).

E. A buffer cache contains exactly three pools: default, keep, and recycle pool.

Discussion of the question

Question 148 🔥

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

Which database solution meets these requirements?

A. You can drop the PDB only if it is closed.

B. You can drop the seed PDB, but you cannot create any other PDB within the CD

C. You can drop the PDB and keep the data files to be reused by another PDB.

D. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.

Discussion of the question

Question 149 🔥

Which process is responsible for writing the contents of database buffers to data files?

Which database solution meets these requirements?

A. Process Monitor process (PMON)

B. Listener Registration process (LREG)

C. System Monitor process (SMON)

D. Database Writer process (DBW)

E. Log Writer process (LGWR)

F. Checkpoint process (CKPT)

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