What is multiplexing? Why is it needed? Write the steps of multiplexing the redo log files and control files with oracle commands.

Explain the term backup, restore and recovery in oracle database. As a DBA of an organization, explain your backup policy (guideline) of your database and also explain the different backups and recovery process with example.

What do you mean by database management system? Mention the clear architecture of oracle database management system including different files.

Explain the term Database administrator (DBA) and describe the different roles of DBA.

What is the importance of privileges in database security? Explain the different system and object privileges used in ORACLE database with example.

Write the commands to create a role having any two privileges and create a user and assign above role to the specified user.

What is indexing? Why is it important? Explain it with example.

What is database auditing? Explain about standard auditing and Fine-grained auditing.

What is AWR report? Write all component of AWR report.

Mention and explain the different startup modes of ORACLE database and types of shutdowns.

What is flashback database? Explain the steps of keeping your database in flashback mode.

What is CDB and PDB in oracle multitenant architecture? Explain how they are related.