DBMS MCQ Questions and Answers for Practice

1. _____________ function divides one numeric expression by another and returns theremainder.

1. POWER
2. MOD
3. ROUND
4. REMAINDER

2. Which of the operations constitute a basic set of operations for manipulating relational data?

1. Predicate calculus
2. Relational calculus
3. Relational algebra
4. None of the above

3. Key to represent relationship between tables is called

1. Primary key
2. Secondary Key
3. Foreign Key
4. None of these

4. Relational calculus is a

1. Procedural language.
2. Non- Procedural language.
3. Data definition language.
4. High level language.

5. Transaction processing is associated with everything below except

1. producing detail, summary, or exception reports.
2. recording a business activity.
3. confirming an action or triggering a response.
4. maintaining data.

6. Which of the following operation is used if we are interested in only certain columns of atable?

1. PROJECTION
2. SELECTION
3. UNION
4. JOIN

7. _________ data type can store unstructured data

1. RAW
2. CHAR
3. NUMERIC
4. VARCHAR

8. In an E-R diagram attributes are represented by

1. rectangle.
2. square.
3. ellipse.
4. triangle.

9. In an E-R diagram an entity set is represent by a

1. rectangle.
2. ellipse.
3. diamond box.
4. circle.

10. A file manipulation command that extracts some of the records from a file is called

1. SELECT
2. PROJECT
3. JOIN
4. PRODUCT

11. A data manipulation command the combines the records from one or more tables is called

1. SELECT
2. PROJECT
3. JOIN
4. PRODUCT

12. Which of the following is a legal expression in SQL?

1. SELECT NULL FROM EMPLOYEE;
2. SELECT NAME FROM EMPLOYEE;
3. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
4. None of the above

13. AS clause is used in SQL for

1. Selection operation.
2. Rename operation.
3. Join operation.
4. Projection operation.

14. The users who use easy-to-use menu are called

1. Sophisticated end users.
2. Naïve users.
3. Stand-alone users.
4. Casual end users.

15. It is better to use files than a DBMS when there are

1. Stringent real-time requirements.
2. Multiple users wish to access the data.
3. Complex relationships among data.
4. All of the above.