DATABASE MANAGEMENT SYSTEMS - MCQ
1) Which of the following is generally used for performing tasks like creating the structure of the
relations, deleting relations?
1. DML(Data Manipulation Language)
2. Query
3. Relational Schema
4. DDL(Data Definition Language)
2) Which of the following provides the ability to query information from the database and insert
tuples into, delete tuples from, and modify tuples in the database?
1. DML(Data Manipulation Language)
2. DDL(Data Definition Language)
3. Query
4. Relational Schema
3) The given Query can also be replaced with_______:
SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;
1. Select name,course_id from teaches,instructor where instructor_id=course_id;
2. Select name, course_id from instructor natural join teaches;
3. Select name, course_id from instructor;
4. Select course_id from instructor join teaches;
4) Which one of the following given statements possibly contains the error?
1. select * from emp where empid = 10003;
2. select empid from emp where empid = 10006;
3. select empid from emp;
4. select empid where empid = 1009 and Lastname = 'GELLER';
5) Read the Query carefully:
SELECT emp_name
FROM department
WHERE dept_name LIKE ' _____ Computer Science';
In the above-given Query, which of the following can be placed in the Query's blank portion to
select the "dept_name" that also contains Computer Science as its ending string?
1. &
2. _
3. %
4. $
6) What do you mean by one to many relationships?
1. One class may have many teachers
2. One teacher can have many classes
3. Many classes may have many teachers
4. Many teachers may have many classes
7) In the following Query, which of the following can be placed in the Query's blank portion to
display the salary from highest to lowest amount, and sorting the employs name alphabetically?
SELECT *
FROM instructor
ORDER BY salary ____, name ___;
1. Ascending, Descending
2. Asc, Desc
3. Desc, Asc
4. All of the above
8) The given Query can be replaced with ____________:
SELECT name
FROM instructor1
WHERE salary <= 100000 AND salary >= 90000;
a.
1. SELECT name
2. FROM instructor1
3. WHERE salary BETWEEN 100000 AND 90000
b.
1. SELECT name
2. FROM instructor|
3. WHERE salary BETWEEN 90000 AND 100000;
c.
1. SELECT name
2. FROM instructor1
3. WHERE salary BETWEEN 90000 AND 100000;
d.
1. SELECT name
2. FROM instructor!
3. WHERE salary <= 90000 AND salary>=100000;
9) A Database Management System is a type of _________software.
1. It is a type of system software
2. It is a kind of application software
3. It is a kind of general software
4. Both A and C
10) The term "FAT" is stands for_____
1. File Allocation Tree
2. File Allocation Table
3. File Allocation Graph
4. All of the above
11) Which one of the following refers to the "data about data"?
1. Directory
2. Sub Data
3. Warehouse
4. Meta Data
12) Which of the following refers to the level of data abstraction that describes exactly how the
data is actually stored?
1. Conceptual Level
2. Physical Level
3. File Level
4. Logical Level
13) To which of the following the term "DBA" referred?
1. Data Bank Administrator
2. Database Administrator
3. Data Administrator
4. None of the above
14) In general, a file is basically a collection of all related______.
1. Rows & Columns
2. Fields
3. Database
4. Records
15) The term "Data" refers to:
1. The electronic representation of the information( or data)
2. Basic information
3. Row Facts and figures
4. Both A and C
16) Rows of a relation are known as the _______.
1. Degree
2. Tuples
3. Entity
4. All of the above
17) Which of the following refers to the number of tuples in a relation?
1. Entity
2. Column
3. Cardinality
4. None of the above
18) Which one of the following is a type of Data Manipulation Command?
1. Create
2. Alter
3. Delete
4. All of the above
19) Which of the following commands is a type of Data Definition language command?
1. Create
2. Update
3. Delete
4. Merge
20) Which of the following is a top-down approach in which the entity's higher level can be
divided into two lower sub-entities?
1. Aggregation
2. Generalization
3. Specialization
4. All of the above
21) In a relational database, every tuple divided into the fields are known as the______.
1. Queries
2. Domains
3. Relations
4. All of the above
22) The term "TCL" stands for_____.
1. Ternary Control Language
2. Transmission Control Language
3. Transaction Central Language
4. Transaction Control Language
23) Which of the following commands is used to save any transaction permanently into the
database?
1. Commit
2. Rollback
3. Savepoint
4. None of the above
24) The term "SQL" stands for
1. Standard query language
2. Sequential query language
3. Structured query language
4. Server-side query language
25) What is relation calculus?
1. It is a kind of procedural language
2. It is a non-procedural language
3. It is a high-level language
4. It is Data Definition language
26) Which one of the following refers to the total view of the database content?
1. Conceptual view
2. Physical view
3. Internal view
4. External view
27) The term "ODBC" stands for_____
1. Oral database connectivity
2. Oracle database connectivity
3. Open database connectivity
4. Object database connectivity
28) Which of the following keys is generally used to represent the relationships between the
tables?
1. Primary key
2. Foreign key
3. Secondary key
4. None of the above
29) Which one of the following keywords is used to find out the number of values in a column?
1. TOTAL
2. COUNT
3. SUM
4. ADD
30) Which one of the following commands is used to modify a column inside a table?
1. Drop
2. Update
3. Alter
4. Set