DBMS MCQ SET-6

1. Which is not the relational Algebra operators

(A) Set Difference
(B) Cartesian Product
(C) Rename
(D) Join

2. How is specialization denoted in ER diagram ?

(A) Triangle labeled IS A
(B) Rectangle labeled IS A
(C) Rectangle labeled HAS A
(D) Triangle labeled HAS A

3. Which of the following is open source DBMS ?

(A) MySQL
(B) SQL Server
(C) Microsoft Access
(D) Oracle

4. Which SQL keyword is used to remove the duplication of rows from the result set?

(A) DELETE
(B) SELECT
(C) DISTINCT
(D) UNIQUE

5. What is the highest level in a hierarchy of data organisation

(A) Data Record
(B) Data File
(C) Data Base
(D) None of these

6. Which of the following is known as minimal super key

(A) Primary Key
(B) Foreign Key
(C) Unique Key
(D) Candidate Key

7. Which command allow the users to change multiple data fields ?

(A) Modify
(B) Look Up
(C) Update
(D) Change

8. Which of the following language is used to define the integrity constraint

(A) DCL
(B) DML
(C) DDL
(D) All of these

9. In an ER diagram Attributes are represented as :

(A) Rectangle
(B) Square
(C) Ellipse
(D) Triangle

10. Architecture of database can be Viewed as

(A) Two levels
(B) Four levels
(C) Three levels
(D) One level

11. In relational model, relations are termed as

(A) Tuples
(B) Attributes
(C) Table
(D) Rows

12. A cartesian product in relational algebra is

(A) Unary Operator
(B) Binary Operator
(C) Ternary Operator
(D) None of these

13. SQL stands for –

(A) Structured Query language
(B) Sequential Query language
(C) Structured Question language
(D) None of these

14. The following are component of a database except

(A) User Data
(B) Meta Data
(C) Reports
(D) Indexes

15. A set of possible data values is ?

(A) Attributes
(B) Degree
(C) Tuple
(D) Domain

16. Which of the following data base object does not physically exist?

(A) Base table
(B) Index
(C) View
(D) None of these

17. Cross product is a

(A) Unary operator
(B) Ternary operator
(C) Binary operator
(D) None of these

18. In ER diagram relationship is represented by

(A) Ellipse
(B) Dashed line
(C) Rectangle
(D) Diamond

19. To delete a particular column in a relation the command used is ?

(A) UPDATE
(B) DROP
(C) ALTER
(D) DELETE

20. A table joined with itself is called

(A) Join
(B) Self join
(C) Quter join
(D) Equi join