DBMS MCQ SET-3

1. The internal schema defines _____ data are organized in physical data storage.

(A) How and where
(B) View
(C) Domain
(D) Important

2. The term _____ is used to refer a row.

(A) Attribute
(B) Tuple
(C) Field
(D) Instance

3. What is the cardinality of a table with 100 rows and 10 columns?

(A) 10
(B) 100
(C) 1000
(D) None of these

4. Which of the following is an integrity constraint?

(A) Domain Constraint
(B) Entity Integrity
(C) Referential Integrity
(D) All of above

5. _____ is a many-to-one relationship between two sets of attributes of a given relation.

(A) Multi-valued dependency
(B) Functional dependency
(C) Temporal dependency
(D) None of these

6. Which of the following is an attribute that holds multiple values for a single entity?

(A) Simple
(B) Composite
(C) Derived
(D) Multi-valued

7. Which of the following is a top-down process?

(A) Specialization
(B) Generalization
(C) Categorization
(D) None of these

8. A relation is in BCNF if and only if every determinant is :

(A) Primary key
(B) Super key
(C) Candidate key
(D) All of above

9. DML is provided for

(A) Description of logical structure of database
(B) Addition of new structure in the database system
(C) Manipulation & processing of database
(D) Definition of physical structure of database system

10. Which of the following is DML command?

(A) INSERT
(B) UPDATE
(C) DELETE
(D) All of the above

11. The key word DISTINCT is not allowed for _____ function.

(A) COUNT()
(B) COUNT(*)
(C) SUM()
(D) AVG()

12. _____ is a technique where transction logs are not required.

(A) Defered Update
(B) Immediate Update
(C) Shadow paging
(D) None of the above

13. ODBC stands for

(A) Object Database Connectivity
(B) Oral Database Connectivity
(C) Oracle Database Connectivity
(D) Open Database Connectivity

14. The Association between Department and Employee is :

(A) One-to-One
(B) One-to-Many
(C) Many-to-Many
(D) None of these

15. Repeatation of data is called :

(A) Inconsistency
(B) Redundency
(C) Atomicity
(D) None of these

16. In 2NF we remove :

(A) Repeating groups
(B) Transitive dependency
(C) Partial functional dependency
(D) None of these

17. Which of the following is a valid SQL data type ?

(A) CHARACTER
(B) NUMERIC
(C) FLOAT
(D) All of the above

18. Which keyword in the GRANT command gives priviledges to all valid users of the DBMS?

(A) ALL
(B) FULL
(C) PUBLIC
(D) None of these

19. Which of the following is the process by which a user’s identity is checked?

(A) Authentication
(B) Authorization
(C) Access control
(D) None of these

20. Which is not Aggregate function?

(A) COUNT()
(B) AVG()
(C) SUM()
(D) SELECT()