Database administration
Previous year question paper with solutions for Database administration
Our website provides solved previous year question paper for Database administration . Doing preparation from the previous year question paper helps you to get good marks in exams. From our DBA question paper bank, students can download solved previous year question paper. The solutions to these previous year question paper are very easy to understand.
These Questions are downloaded from www.brpaper.com You can also download previous years question papers of 10th and 12th (PSEB & CBSE), B-Tech, Diploma, BBA, BCA, MBA, MCA, M-Tech, PGDCA, B-Com, BSc-IT, MSC-IT.
Print this page
- What is Database Administration? Describe the role and responsibilities of a Data Base Administrator (DBA).
- Explain the client-server model and its components. Also, discuss the communication protocols in detail.
- Compare various database packages based upon their functionality.
- What is database instance management? How do we create and manage the views and indexes in a database?
- How can we implement the migration and consolidation policy? Give example.
- Define task automation. Outline the working of client tools for administrative tasks.
- Data integrity and its importance
- Database replication and its importance
- What is database administrator (DBA)? Explain the roles and responsibilities of DBA
- Compare MySql server and ORACLE server (give at least 4 comparisons). Give procedure to Install and configure ORACLE database server.
- Describe the three tier client server architecture with the help of suitable example.
- Monitoring and Troubleshooting SQL Server
- Implementing migration, consolidation and upgrade strategy in a database.
- What is a Client-Server Model? Describe any five database servers.
- What are communication protocols? Explain any two.
- What is a database package? Introduce any five packages.
- Compare various database packages based upon their functionality.
- Managing data integrity
- Exporting and importing data
- Discuss the Database replication and its importance following in the context of managingdatabase servers.