Oracle Database 19C:Administration Workshop Quiz Questions and Answers

Which of cluster type is not available in oracle clusterware 12.2 and above versions?

Answer :
  • Leaf cluster

Oracle RAC database can have max __instances.

Answer :
  • 100

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

Answer :
  • True

Local temp tablespaces can be managed using alter tablespace or alter database commands.

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 what is it responsible for?

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