Oracle Database 19C:Administration Workshop Quiz Questions and Answers

To use FRA in RAC,FRA must be placed in ASM diskgroup.

Answer :
  • True

SHUTDOWN TRANSACTIONAL LOCAL in onceinstance does not wait for other instances’ transactions to finish.

Answer :
  • True

Automatically run root.sh configuration file with root user authentication can be done in which version of oracle database?

Answer :
  • 19c

SMON stands for System Monitor, and is responsible for what?

Answer :
  • Instance Recovery

Binding variables and run time buffer information Which area of PGA stores binding variables and run-time buffers information?

Answer :
  • Private SQL area

Libarary Cache is component of ?

Answer :
  • Shared Pool Size

Which is the smallest unit of storage in an Oracle database?

Answer :
  • Oracle Data Block

Which one of the following is not an Oracle Database Tools?

Answer :
  • sysdate

What is the default type of index is in oracle?

Answer :
  • B-Tree

Which parameter is useful in the case of configuring OMF?

Answer :
  • db_create_file_dest