DBMS Mcq With Answer With Subjective Question set (Kolhan University)

DBMS MCQ WITH ANSWER WITH SUBJECTIVE

MCQ Important Question Of DBMS

1. ......... attribute consisting more than one value. ?

1. Key
2. Multivalued
3. Derived
4. None of these

2. In ACID properties of transaction 'A' stands for: ?

1. Ample
2. Atomicity
3. Auto
4. Accuracy

3. A .......... key is a field in a relational table that matches the primary key column of another table.

1. Candidate
2. Alternate
3. Foreign
4. Super

4. The projection operation denoted by..........

1. π
2. δ
3. ∞
4. U

5. The level of data abstraction which describes how the data is actually stored is ............

1. External
2. Conceptual
3. Physical
4. None of these

6. .........are the properties of entity.

1. Table
2. Attributes
3. Groups
4. Value

7. The set of all possible values of data item is called ...........

1. Domain
2. Attribute
3. Set
4. None of these

8. Which forms are based on the concept of Functional Dependency ?

1. 1NF
2. 2NF
3. 3NF
4. 4NF

9. Which of the following making the transaction permanent in the database?

1. Rollback
2. Commit
3. View
4. Flashback

10. Select * from employee, what type of the statement is this?

1. DML
2. DDL
3. DCL
4. None of these

11. Which of the following is the full form of DDL?

1. Data definition language
2. Data derivation language
3. Dynamic data language
4. Detailed data language

12. Which of the following is the property of transaction that protects data from system failure?

1. Atomicity
2. Isolation
3. Durability
4. Consistency

13. Which of the following is preserved in execution of transaction in isolation?

1. Consistency
2. Isolation
3. Durability
4. Atomicity

14. Which normalization form is based on the transitive dependency?

1. 1NF
2. 2NF
3. 3NF
4. 4NF

15. For performing tasks like creating the structure of the relations, deleting relation, which of the following is used?

1. Data definition language
2. Data derivation language
3. Dynamic data language
4. Detailed data language

16. What is rows of a relation known as?

1. Degree
2. Entity
3. Tuple
4. None

17. Which of the following is a command of DDL?

1. Alter
2. Delete
3. Create
4. All of the above

18. During transaction before commit which of the following statement is done automatically in case of shutdown?

1. Rollback
2. Commit
3. View
4. Flashback

19. Which of the following is the full form of TCL?

1. Ternary control language
2. Transaction control language
3. Transaction central language
4. Transmission control language

20. Which of the following SQL command is used for removing (or deleting) a relation form the database?

1. Drop
2. Delete
3. Rollback
4. Remove

Important Question Of DBMS

1. Explain Generalization example with suitable

2. What is two phase locking protocol?

3. Explain DBMS Architecture.

4. Draw E-R diagram of Library Management System.

5. Explain 1NF and 2NF with suitable example.

6. What are the states of Transaction?

7. Write a PL/SQL block to input deptno. If it exists then display name, salary and job from emp table otherwise display a message 'Deptno does not exist'.

8. Create a table Employee using field Name: EMPNO, ENAME, JOB, HIREDATE and SAL. Use these group by, order by and delete commands for manupulation with example.

9. Write short notes on the following:

(a) Database Administrator (DBA)
(b) DML 
(c) Primary of Foreign Key

10. 

(a) What is Relational Algebra ?

(b) Explain any five Relational Algebra Operations.

11. 

(a) What is Transaction?

(b) Write properties of Transaction with suitable example.

12. 

(a) What is PL/SQL?

(b) Write DBMS advantages over typied file