Explain the purpose of the Automatic Diagnostic Repository (ADR) in Oracle. How does it help in database diagnostics and troubleshooting? [2+3]
Explain multiplexing of online redo logs and control files. How does it improve database reliability? [5]
Describe the steps to manage user passwords in Oracle Database, including password expiration, complexity, and locking/unlocking accounts. [5]
Create a Container Database named CDB_TEST. Provide the SQL commands you would use to create it and verify its creation. [5]
How can you start an Oracle Listener? Explain the commands with examples. [5]
Describe the steps involved in configuring RMAN for performing database backups. Include commands or procedures used to set up RMAN. [5]
List and briefly describe the main components of a Scheduler. Explain how these components interact in a typical scheduling workflow. [5]
Attempt any TWO questions
[2x10=20]Explain how privileges and roles are managed in Multitenant architecture. Distinguish between common and local privileges. [5+5]
Explain how to monitor and manage user accounts in Oracle Database, including account locks, unlocking, and password expiration. [10]
Write SQL commands for following:
i. Create the table named blank having fields (Acc-no, name, address, ph-no, Balance)
ii. Add primary key in above table
iii. Add check constraints in the balance field, value of balance > 300.
iv. Rename the table blank to Bank.
v. Insert some rows and delete one of the record from the table Bank.
vi. Create the logical backup of above table using expdp utility
vii. Give select, update privilege to another user Mohan.
viii. Add loan_id field as foreign key referencing to the loan.
ix. Modify the name field to increase the character length.
x. Rename the name field to cname. [10]