WorksheetsDBMS mcq -2
Total questions: 20
Worksheet time: 10mins
1) Which of the following refers to the number of attributes in a relation?
a) Degree
b) Row
c) Column
d) All of the above
2) Which of the following is used in the application programs to request data from the database management system?
a) Data Manipulation language
b) Data Definition Language
c) Data Control Language
d) All of the above
3) Which one of the following command is used to delete the existing row in a table?
a) Delete
b) Update
c) Insert
d) None of the above
4) Which of the following commands is used to save any transaction permanently into the database?
a) Commit
b) Rollback
c) Save point
d) None of the above
5) Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
a) Delete
b) Drop
c) Remove
d) All of the above
6) Which one of the following commands is used to restore the database to the last committed state?
a) Save point
b) Rollback
c) Commit
d) Both A & B
7) The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
a) Translators
b) Programs
c) Keys
d) Language activity
8) The term "DFD" stands for?
a) Data file diagram
b) Data flow document
c) Data flow diagram
d) None of the above
9) Which of the following refers collection of the information stored in a database at a specific time?
a) Independence
b) Instance of the database
c) Schema
d) Data domain
10) The term "SQL" stands for
a) Standard query language
b) Sequential query language
c) Structured query language
d) Server-side query language
11) The term "Data independence" refers to____
a) Data is defined separately and not included in the programs
b) Programs are not dependent on the logical attributes of the data
c) Programs are not dependent on the physical attributes of the data
d) Both B & C
12) What is the relation calculus?
a) It is a kind of procedural language
b) It is a non-procedural language
c) It is a high-level language
d) It is Data Definition language
13) Which one of the following refers to the total view of the database content?
a) Conceptual view
b) Physical view
c) Internal view
d) External view
14) For what purpose the DML is provided?
a) Addition of new structure in the database
b) Manipulation & processing of the database
c) Definition of the physical structure of the database system
d) All of the above
15) The term "ODBC" stands for_____
a) Oral database connectivity
b) Oracle database connectivity
c) Open database connectivity
d) Object database connectivity
16) The architecture of a database can be viewed as the ________
a) One level
b) Two-level
c) Three-level
d) Four level
17) In the relation model, the relation are generally termed as ________
a) Tuples
b) Attributes
c) Rows
d) Tables
8) The Database Management Query language is generally designed for the _____
a) Support end-users who use English like commands
b) Specifying the structure of the database
c) Support in the development of the complex applications software
d) All of the above
19) Which of the following keys is generally used to represents the relationships between the tables?
a) Primary key
b) Foreign key
c) Secondary key
d) None of the above
20) Which of the following levels is considered as the level closed to the end-users?
a) Internal Level
b) External Level
c) Conceptual Level
d) Physical Level
