Component of a database is responsible for ensuring atomicity and durability.
recovery management
Well Done. Your Answer is Correct Keep it Up!
concurrency control
storage management
query evaluation engine
Tag: Databases MCQs
Which protocol permits release of exclusive locks only at the end of transaction?
Which protocol permits release of exclusive locks only at the end of transaction?
Two phase locking protocol
Well Done. Your Answer is Correct Keep it Up!
Graph based protocol
Strict two phase locking protocol
Rigorous Two phase locking protocol
Who developed Python Programming Language?
Who developed Python Programming Language?
Guido van Rossum
Well Done. Your Answer is Correct Keep it Up!
Rasmus Lerdorf
Wick van Rossum
Niene Stom
The database environment has all of the following components except.
The database environment has all of the following components except.
Users
Well Done. Your Answer is Correct Keep it Up!
Database
Database Administration
Separate files
Which of the following is/are the DDL statements?
Which of the following is/are the DDL statements?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Create
Drop
Alter
A ……… is used to define overall design of the database
A ……… is used to define overall design of the database
Schema
Well Done. Your Answer is Correct Keep it Up!
Application program
Data definition language
None of the options are correct
…………… database is used as template for all databases created.
…………… database is used as template for all databases created.
Master
Well Done. Your Answer is Correct Keep it Up!
Model
Temp DB
None of the options are correct
DCL stands for
DCL stands for
Data Control Language
Well Done. Your Answer is Correct Keep it Up!
Data Console Language
Data Control Level
Data Console Level
Which two files are used during operation of the DBMS
Which two files are used during operation of the DBMS
Data dictionary and transaction log
Well Done. Your Answer is Correct Keep it Up!
DML and query language
Query languages and utilities
None of the options are correct
An advantage of the database management approach is
An advantage of the database management approach is
Data is integrated and can be accessed by multiple programs
Well Done. Your Answer is Correct Keep it Up!
Data redundancy increases
Data is dependent on programs
None of the options are correct