Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Data And Database Administration(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Data And Database Administration
Question 1.
Poor data administration can lead to which of the following?
Missing data elements
A single definition of the same data entity
Familiarity with existing data
All of these
Explanation:-
Answer: Option A. ->
Missing data elements
Question 2.
A traditional data administrator performs which of the following roles?
Tune database performance
Resolve data ownership issues
Establish backup and recovery procedures
Protect the security of the database
Explanation:-
Answer: Option B. ->
Resolve data ownership issues
Question 3.
Backward recovery is which of the following?
Where the before-images are applied to the database
Where the after-images and before-images are applied to the database
Where the after-images are applied to the database
Switching to an existing copy of the database
Explanation:-
Answer: Option A. ->
Where the before-images are applied to the database
Question 4.
Which of the following is part of an administrative policy to secure a database?
Authentication policies
All of these
Limiting particular areas within a building to only authorized people
Ensure appropriate responses rates are in external maintenance agreements
Explanation:-
Answer: Option B. ->
All of these
Question 5.
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
All of these
Database design
Data modeling
Metadata
Explanation:-
Answer: Option B. ->
Database design
Question 6.
The transaction log includes which of the following?
The before-image of a record
The essential data of the record
The before and after-image of a record
The after-image of a record
Explanation:-
Answer: Option B. ->
The essential data of the record
Question 7.
Which of the following could cause data to be unavailable?
All of these
Planned database maintenance activities
Data becoming lost or inaccurate
The database server
Explanation:-
Answer: Option A. ->
All of these
Question 8.
Locking may cause which of the following problems?
Versioning
Erroneous updates
All of these
Deadlock
Explanation:-
Answer: Option D. ->
Deadlock
Question 9.
A shared lock allows which of the following types of transactions to occur?
Read
Insert
Update
Delete
Explanation:-
Answer: Option A. ->
Read
Question 10.
Performance analysis and tuning is which of the following?
Undertaken one time at the time of the implementation of a new application
Undertaken as an ongoing part of the backup of a database
Undertaken one time at the time of a DBMS installation
Undertaken as an ongoing part of managing a database
Explanation:-
Answer: Option D. ->
Undertaken as an ongoing part of managing a database
1
2
3
Next →
One click Login
Login With Google
Old way of Login
Login With Email