Font size
WorksheetsDatabase Management System
Total questions: 18
Worksheet time: 11mins
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 in not a function of DBA?
Network Maintenance
Routine Maintenance
Schema Definition
Authorization for data access
Which of the following is not involved in DBMS?
End Users
Data
Application Request
HTML
DBMS means (a)
Database management system is _________ software
System
Relational
Application
Game
Write your name, class and roll number.
