Database - Data and Database Administration

Why Database Data and Database Administration?

In this section you can learn and practice Database Questions based on "Data and Database Administration" and improve your skills in order to face the interview, competitive examination and various entrance test (CAT, GATE, GRE, MAT, Bank Exam, Railway Exam etc.) with full confidence.

Where can I get Database Data and Database Administration questions and answers with explanation?

IndiaBIX provides you lots of fully solved Database (Data and Database Administration) questions and answers with Explanation. Solved examples with detailed answer description, explanation are given and it would be easy to understand. All students, freshers can download Database Data and Database Administration quiz questions with answers as PDF files and eBooks.

Where can I get Database Data and Database Administration Interview Questions and Answers (objective type, multiple choice)?

Here you can find objective type Database Data and Database Administration questions and answers for interview and entrance examination. Multiple choice and true or false type questions are also provided.

How to solve Database Data and Database Administration problems?

You can easily solve all kind of Database questions based on Data and Database Administration by practicing the objective type exercises given below, also get shortcut methods to solve Database Data and Database Administration problems.

Exercise :: Data and Database Administration - General Questions

1. 

Poor data administration can lead to which of the following?

A. A single definition of the same data entity
B. Familiarity with existing data
C. Missing data elements
D. All of the above.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

2. 

A traditional data administrator performs which of the following roles?

A. Tune database performance
B. Establish backup and recovery procedures
C. Resolve data ownership issues
D. Protect the security of the database.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

3. 

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

A. Data modeling
B. Database design
C. Metadata
D. All of the above.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

4. 

Which of the following is part of an administrative policy to secure a database?

A. Authentication policies
B. Limiting particular areas within a building to only authorized people
C. Ensure appropriate responses rates are in external maintenance agreements
D. All of the above.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

5. 

Backward recovery is which of the following?

A. Where the before-images are applied to the database
B. Where the after-images are applied to the database
C. Where the after-images and before-images are applied to the database
D. Switching to an existing copy of the database

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.