WorksheetsDatabase management systems
Total questions: 58
Worksheet time: 29mins
The following are the functions of a DBMS except
Creating database
Processing data
Creating and processing forms
Administrating database
The term _____ is used to refer a row
Record
Primary key
Foreign key
Field
Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key?
NAME
ID
CITY
ID, NAME
Which one of the following is NOT an advantage of DBMS
Increased data consistency
Reduced data redundancy
Improved data security
Increase data isolation
Which of the following gives a logical structure of the database graphically?
Entity - relationship diagram
Entity diagram
Database diagram
Architectural representation
If you were collecting and storing information about your music collection, an album would be considered a/an _______
Relation
Instance
Entity
Attribute
Disadvantages of File systems to store data is:
Data redundancy and inconsistency
Difficulty in accessing data
Data isolation
All of the above
Data Manipulation Language enables users to
Retrieval of information stored in database
Insertion of new information into the database
Deletion of information from the database
All of the above
Which of the following is not an Schema?
Database Schema
Physical Schema
Critical Schema
Logical Schema
Which of the following is Database Language?
Data Definition Language
Data Manipulation Language
Query Language
All of the above
Which of the following is not involved in DBMS?
End Users
Data
Application Request
HTML
DBMS means (a)
Write your name, class and roll number.
Database management system is _________ software
System
Relational
Application
Game
A Database Management System (DBMS) is
Collection of interrelated data
Collection of programs to access data
Collection of data describing one particular enterprise
All of the above
Which of the following is not a level of data abstraction?
Physical Level
Critical Level
Logical Level
View Level
Disadvantages of File systems to store data is:
Data redundancy and inconsistency
Difficulty in accessing data
Data isolation
All of the above
Which of the following is not a Storage Manager Component?
Transaction Manager
Logical Manager
Buffer Manager
File Manager
Data Manipulation Language enables users to
Retrieval of information stored in database
Insertion of new information into the database
Deletion of information from the database
All of the above
Which of the following is a Data Model?
Entity-Relationship model
Relational data model
Object-Based data model
All of the above
The attribute refers to a _____ of a table
Record
Foreign key
Primary key
Field
Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key?
NAME
ID
CITY
ID, NAME
Which one of these cannot be taken as a primary key?
ID
registration no
Department ID
Street
This is an example of ________________
Data inconsistency
Data redundancy
Data security
Data consistency
A field of one table which is also a the primary key of another table
Primary Key
Relational database
Data normalisation
Foreign Key
Select the DBMS software
Which of the following query would display all the students whose first name starts with the character ‘A’?
select first_name from students where first_name like ‘A%’;
select first_name from students where first_name like ‘%A’;
select first_name from students where first_name like ‘%A%’;
select first_name from students where first_name like ‘A’;
Which of the following is not true about the ALTER TABLE statement?
It can add a new row.
It can add a new column
It can modify existing columns
It can define a default value for the new column
In the __________ normal form, a composite attribute is converted to individual attributes
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
Drop table statement
deletes the table structure only
deletes the table structure along with the table data
works whether or not referential integrity constraints would be violated
is not an SQL statement
In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?
Triggers
Pointers
Locks
Cursors
A lock that allows concurrent transactions to access different rows of the same table is known as a
Database-level lock
Table-level lock
Page-level lock
Row-level lock
A lock that allows concurrent transactions to access different rows of the same table is known as a
Database-level lock
Table-level lock
Page-level lock
Row-level lock
Which of the following are introduced to reduce the overheads caused by the log-based recovery?
Checkpoints
Indices
Deadlocks
Locks
Which of the following protocols ensures conflict serializability and safety from deadlocks?
Two-phase locking protocol
Time-stamp ordering protocol
Graph based protocol
None of the mentioned
Which of the following is the block that is not permitted to be written back to the disk?
Dead code
Read only
Pinned
Zapped
If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an __________ on all the records belonging to that file.
Explicit lock in exclusive mode
Implicit lock in shared mode
Explicit lock in shared mode
Implicit lock in exclusive mode
All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.
Scheduler
DBMS
Lock manager
Locking agent
Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
Record controller
Exclusive lock
Authorization rule
Two phase lock
In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
Clustered index
Structured index
Unstructured index
Nonclustered index
Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
Nonclustered
Secondary
All of the mentioned
None of the mentioned
An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
Index entry
Index hash
Index cluster
Index map
In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
Dense
Sparse
Straight
Continuous
In a __________ index, an index entry appears for only some of the search-key values.
Dense
Sparse
Straight
Continuous
A search key containing more than one attribute is referred to as a _________ search key.
Simple
Composite
Compound
Secondary
In B+ tree the node which points to another node is called
Leaf node
External node
Final node
Internal node
Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
Loading
Bulk insertion
Bulk loading
Increase insertion
While inserting the record into the index, if the search-key value does not appear in the index.
The system adds a pointer to the new record in the index entry
The system places the record being inserted after the other records with the same search-key values
The system inserts an index entry with the search-key value in the index at the appropriate position
None of the mentioned
