Database Administration - Unit Wise Questions

1. Explain the database management system and also describe the database management system architecture.

1. Explain the database management system architecture and also explain the DBA roles and responsibilities.

1. Explain any detail about the DBMS architecture.

1. What do you mean by Database and database management system? Explain the SQL Plus overview.

2. Explain the managing, maintaining and monitoring redo log files with appropriate example.

1. How do you manage user privileges and roles ? Explain using suitable examples.

2. What do you mean by database performance Tuning? Explain the role of ADDM and SQL Access Advisors in performance testing of oracle database.

1.Explain the database management system architecture and also explain the DBA roles and responsibilities.

1. Explain the DBMS architecture and its applications.

2. How can you design the plan of backup, recovery and security of an organization? Explain.

2. What do you mean by Redo log files? Explain the maintaining and monitoring redo log files.

1. What is profile? How is it different from user? How do you create, assign, alter, and drop profile? Explain with suitable examples. 

3. What is tuning methodology? Explain the Automatic database diagnostic monitor with its applications.

2. Explain the process to design the backup, recovery and security plan for the government organization.

2. What do you mean by Redo log files? Explain the maintaining and monitoring redo log files.

3. As a DBA explain how you can manage user privileges, roles and profiles? Consider you got a call from your backup DBA while you are on leave. He has corrupted all of the data files while playing with the ALTER DATABASE CONTROLFILE command. What do yo do? Explain.

3. Explain the backup and recovery plan and strategy with practical example.

3. Explain the control and Redo log files with applications.

2. Why do we need recovery in databases? How do you define backup and recovery procedure?

2. Why do we need recovery? Discuss undo and redo log files used in recovery?

2. You are working as DBA in Nepal Clearing House Limited which handle 24/7 online system. You have to design security and backup procedure for the organization.

3. What are the various kinds of performance report available in the oracle database management system mention the name and describe them one by one.

3. How can you manage, maintain and monitoring the redo log files? Explain with example.

3. Explain Backup and recovery plan. How do you test the backup and recovery plan?

3. Explain database performance tuning. What is tuning methodology? Explain.

3. Discuss automatic database diagnostic monitor in detail. What is SQL tuning advisor?

4. What do you mean by  SQL and PLUS? Explain.

4. Explain the database security and auditing.

4. How can you manage the control files? Explain.

4. Differentiate between logical and physical data independence.

5. What are the authentication method for DBA? Explain.

5. Explain the database security and auditing.

5. How can you test the backup and recovery plan?

5. Explain the advanced stored procedures.

6. Explain the testing the backup and recovery plan.

4. Define role. How do you query role information?

6. Explain the testing the backup and recovery plan.

6. How can you manage the automatic storage?

4. Explain DBA roles and responsibilities.

4. What is DBMS architecture? Explain.

4. Compare SQL* plus with iSQL* plus.

4.What is DML? Explain all the SML command with suitable example.

6. What is redo log buffer and how do you monitor a waiting session in the redo log buffer?

5. What is a view? Write an importance of view.

7. Differentiate between database administrator and data administrator.

5. Define index ? Why do we need index in databases?

5. How do you manage control files? Explain.

7. Differentiate between hot and cold backup. What is involved with executing a hot backup?

5. Explain the database security and auditing.

7. What do you mean by backup and recovery strategy?

7. What do you mean by database corruption? How can you maintain the database corruption?

5. Explain the Database security and auditing.

6. Explain the role of database administrator?

8. Explain the ASM and its capabilities.

8. Explain the RMAN with example.

8. Describe the SQL Tuning Advisor with example.

6. Explain the process of backup and recovery plan.

6. What is trigger? Explain with example.

6. What is backup and recovery plan? How do you test this plan?

6. Manage user in dB.

8. Consider a situation that an alteration is made to the sp file which results in the instance being unable to start. As DBA how can you fix this problem?

7. What is ASM? Mention the capabilities of ASM.

9. What do you mean by virtual private database?

7. Why do we manage concurrency of transactions? Explain.

9. What do you mean by a view? Explain its importance.

7. Automatic DBM.

9. What do you mean by tuning methodology?

9. Define the AWR. What are the components of AWR report?

7. Explain parallel instance recovery.

7. Discuss different policy types of virtual private database.

8. What is parallel instance recovery? Explain.

10. What do you mean by parallel instance recovery?

8. Explain DBMS architecture. What is data independence?

10. Explain the virtual private database with example.

10. What do you mean by parallel instance recovery?

8. Write the command to add new redo group and drop group in the database.

8. Automatic DB diagnostic monitor.

10. Explain the parallel instance recovery with example.

11. What do you mean by automatic storage management? Explain.

11. What is oracle virtual private database? Explain the benefit associated with it.

8. Difference between automatic dBM and ASM.

9. What are different solutions used in database corruption?

9. UPDB with example.

11. Explain the parallel instance recovery with practical example.

9. How do you produce more readable output to the result returned from SQL*Plus?Explain.

11. What do you mean by database corruption? How can you recover in this case?

9. Write DDL command for following.

a. Change table product to product_org

b. Add new check constraints in the status field of product_org table value of status field should always (00, 01 and 09)

c. Create backup table of sales

d. Disable check constraint in the table.

12. Explain the tuning methodology with example.

12. Explain the SQL tuning advisor.

12. Write the DBA queries for the following actions:

    a. To display the size of your database

    b. Lock or unlock a user

    c. Show all connected users with their status

    d. Show the current SQLs

    e. Show what roles are granted to a user.

10. Explain the process of parallel instance recovery with example.

10. Define redo log file? Why do we need this file in databases?

9. Discuss Automatic DB diagnostic monitor.

10. How does recovery manager manages automatic storage?

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

12. What are the major difference between automatic database management and automatic storage management?

13. Write short note on:

      a. ADDM (Automatic Database Diagnostic Monitor)

      b. RMAN

10. Performance tuning with example.

11. Explain different roles of automatic diagnostic monitor.

11. How do you create different control files? Discuss.

13. Write short note on:

    a) DBA roles

    b) Column masking

11. What do you mean by parallel instance recovery?

11. Application of automatic storage management.

13. Write short note on:

    a. Using ISQL Plus

    b. RMAN

12. What is SQL tuning advisor? Explain.

11. Explain UPDB with example.

12. Explain the tuning methodology with example.

12. Write a trigger to create log of every update and delete statement of product table.

12. What are different solutions of database corruption?

13. Write short notes on:

1. Triggers

2. SQL Tuning advisor

12. Process to maintain the dB corruption.

13. Write short notes on:

a. User privilage

b. SQL tuning advisor

13. Write short notes on:

a) RMAN

b) Database auditing

13. Write short notes on:

a) stored procedure

b) AWR report

13. Write short note of followings:

a. Step to create backup device

b. Internet database connector