Explain the term backup, restore and recovery in oracle database. Also explain the different backups and recovery process with example.[10]
2.
What is oracle data guard? Explain its importance in oracle database.[5]
Introduction Administration Basics
1.
What do you mean by database management system? Mention the clear architecture of oracle database.[10]
2.
What is SQL*PLUS? Also explain the functionalities of SQL*PLUS that the ORACLE DBA can use.[5]
3.
Explain the term Database administrator (DBA) and describe the different roles of DBA.[5]
Managing Resources And Scheduling Tasks
1.
What is Job Scheduling in oracle database? How DBMS_ SCHEDULER Works? Explain the different component of scheduler.[5]
Network Environment and Storage Structures
1.
Explain the term oracle RAC and oracle ASM.[5]
2.
Explain the different oracle net service components.[5]
Profiles, Resources, and Auditing
1.
What is database auditing? Explain the standard auditing in oracle database.[5]
Space Management And Oracle Support
1.
What are data files? How it is related with tablespace. Write a command to add a datafile in existing tablespace named "users".[5]
Tuning And Moving
1.
Explain how SQL tuning advisor can be used to tune your database.[5]
Users and Privileges
1.
What is the importance of privileges in database security? Explain about role in oracle datanse and write command to do following: a. Create role b. Grant system and object privileges to role c. Create user d. Assign role to user e. Drop role[10]