MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Data And Database Administration
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Rollback
Rollforward
Switch to duplicate database
Reprocess transactions
Q.2
The transaction log includes which of the following?
The before-image of a record
The after-image of a record
The before and after-image of a record
The essential data of the record
Q.3
Which of the following is true concerning open-source DBMS?
Is free or nearly free database software whose source code is publicly available
Is free or nearly free database software whose source code is not publicly available
Is not competitive against PC-oriented packages and is fully SQL compliant
Is competitive against PC-oriented packages and is not fully SQL compliant
Q.4
Concurrency control is important for which of the following reasons?
To ensure data integrity when updates occur to the database in a multiuser environment
To ensure data integrity when updates occur to the database in a single-user environment
To ensure data integrity while reading data occurs to the database in a multiuser environment
To ensure data integrity while reading data occurs to the database in a single-user environment
Q.5
Which of the following could cause data to be unavailable?
Data becoming lost or inaccurate
The database server
Planned database maintenance activities
All of the above
Q.6
A shared lock allows which of the following types of transactions to occur?
Delete
Insert
Read
Update
Q.7
Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
True
False
Q.8
A disaster recovery plan does not need to include the shipment of database backups to other sites.
True
False
Q.9
With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
True
False
Q.10
Data modeling and database design are key responsibilities of data and data base administration.
True
False
Q.11
Incorrect data is easy to detect.
True
False
Q.12
Information repositories are replacing data dictionaries in many organizations.
True
False
Q.13
Mirrored databases are almost always provided in high-availability systems.
True
False
Q.14
Databases are not the property of a single function or individual within the organization.
True
False
Q.15
Queries that do full table scans should be avoided.
True
False
Q.16
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.
True
False
Q.17
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
True
False
Q.18
Failure to control confidentiality may lead to loss of competitiveness.
True
False
Q.19
Authorization tables contain highly sensitive data and should be protected by stringent security rules.
True
False
Q.20
A transaction log shows before and after images of records that have been modified by transactions.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page