Unit-wise questions - Database Administration

Syllabus Notes Old Questions & solutions Yearly Questions Text & reference books
116 questions

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

asked in 2069

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

asked in 2073

1. Explain any detail about the DBMS architecture.

asked in 2072

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

asked in 2070

1. Explain the DBMS architecture and its applications.

asked in 2074

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

asked in 2077

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

asked in Model

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

asked in 2069

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

asked in 2073

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

asked in 2072

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

asked in 2076

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

asked in 2070

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

asked in 2075

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

asked in 2074

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

asked in 2077

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.

asked in Model

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

asked in 2069

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

asked in 2073

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.

asked in 2072

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

asked in 2076

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

asked in 2070

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

asked in 2075

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

asked in 2074

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

asked in 2077

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.

asked in Model

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

asked in 2076

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

asked in 2075

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

asked in 2069

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

asked in 2073

4. Differentiate between logical and physical data independence.

asked in 2072

4. Explain the database security and auditing.

asked in 2070

5. Explain the advanced stored procedures.

asked in 2069

5. Explain the database security and auditing.

asked in 2073

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

asked in 2072

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

asked in 2070

6. How can you manage the automatic storage?

asked in 2070

4. Explain DBA roles and responsibilities.

asked in 2074

4. What is DBMS architecture? Explain.

asked in 2077

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

asked in Model

6. Explain the testing the backup and recovery plan.

asked in 2069

6. Explain the testing the backup and recovery plan.

asked in 2073

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

asked in 2072

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

asked in 2076

4. Compare SQL* plus with iSQL* plus.

asked in 2075

7. Differentiate between database administrator and data administrator.

asked in 2070

5. Explain the Database security and auditing.

asked in 2074

5. How do you manage control files? Explain.

asked in 2077

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

asked in Model

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

asked in 2069

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

asked in 2073

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

asked in 2072

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

asked in 2076

5. Explain the database security and auditing.

asked in 2075

8. Explain the ASM and its capabilities.

asked in 2070

6. Explain the process of backup and recovery plan.

asked in 2074

6. What is trigger? Explain with example.

asked in 2077

6. Explain the role of database administrator?

asked in Model

8. Describe the SQL Tuning Advisor with example.

asked in 2069

8. Explain the RMAN with example.

asked in 2073

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?

asked in 2072

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

asked in 2076

6. Manage user in dB.

asked in 2075

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

asked in 2070

7. Automatic DBM.

asked in 2074

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

asked in 2077

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

asked in Model

9. What do you mean by virtual private database?

asked in 2069

9. What do you mean by tuning methodology?

asked in 2073

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

asked in 2072

7. Discuss different policy types of virtual private database.

asked in 2076

7. Explain parallel instance recovery.

asked in 2075

10. What do you mean by parallel instance recovery?

asked in 2070

8. Automatic DB diagnostic monitor.

asked in 2074

8. What is parallel instance recovery? Explain.

asked in 2077

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

asked in Model

10. Explain the parallel instance recovery with example.

asked in 2069

10. Explain the virtual private database with example.

asked in 2073

10. What do you mean by parallel instance recovery?

asked in 2072

8. Explain DBMS architecture. What is data independence?

asked in 2076

8. Difference between automatic dBM and ASM.

asked in 2075

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

asked in 2070

9. UPDB with example.

asked in 2074

9. What are different solutions used in database corruption?

asked in 2077

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.

asked in Model

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

asked in 2069

11. Explain the parallel instance recovery with practical example.

asked in 2073

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

asked in 2072

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

asked in 2076

9. Discuss Automatic DB diagnostic monitor.

asked in 2075

12. Explain the SQL tuning advisor.

asked in 2070

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

asked in 2074

10. How does recovery manager manages automatic storage?

asked in 2077

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

asked in Model

12. Explain the tuning methodology with example.

asked in 2069

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

asked in 2073

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.

asked in 2072

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

asked in 2076

10. Performance tuning with example.

asked in 2075

13. Write short note on:

    a. Using ISQL Plus

    b. RMAN

asked in 2070

11. Application of automatic storage management.

asked in 2074

11. Explain different roles of automatic diagnostic monitor.

asked in 2077

11. What do you mean by parallel instance recovery?

asked in Model

13. Write short note on:

      a. ADDM (Automatic Database Diagnostic Monitor)

      b. RMAN

asked in 2069

13. Write short note on:

    a) DBA roles

    b) Column masking

asked in 2073

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

asked in 2076

11. Explain UPDB with example.

asked in 2075

12. Explain the tuning methodology with example.

asked in 2074

12. What is SQL tuning advisor? Explain.

asked in 2077

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

asked in Model

12. What are different solutions of database corruption?

asked in 2076

12. Process to maintain the dB corruption.

asked in 2075

13. Write short notes on:

a. User privilage

b. SQL tuning advisor

asked in 2075

13. Write short notes on:

1. Triggers

2. SQL Tuning advisor

asked in 2074

13. Write short notes on:

a) stored procedure

b) AWR report

asked in 2077

13. Write short note of followings:

a. Step to create backup device

b. Internet database connector

asked in Model

13. Write short notes on:

a) RMAN

b) Database auditing

asked in 2076

questions
questions
questions
questions
questions
questions