Monday, August 19, 2019

DBMS important questions

Today I am sharing a important Database management questions which are useful for your upcoming college semester exam .

So here I am providing a DBMS important questions which are listed below -

1. What do you mean by DBMS ? How it is better than file processing system .

2. What are the function of a database administrators with regard to database security .

3. Explain tupple , Attribute and domain .

4. Define Logical and Physical Database system .

5. Write short notes on :

A. Data Definition Language ( DDL )

B. Data Manipulation Language ( DML ) 


6. Explain Mapping Constraints .

7. Write short notes on -

• Hierarchical model with example 

• Database Task Group ( DBTG )

• Flash Memory 

• Magnetic Tape 

• Relational Query Language 

8. Explain Structured Query Language ( SQL )

9. Explain Recovery Procedure that need to take place after disk crash .


10. Explain Access Control Mechanisms .

11. Discuss advantages and disadvantages produced by distributed database system .

12. Explain the various schemes for data fragmentation .


13. Define Crash Recovery .


14. Difference between DDL , VDL and SDL .

15. Write short notes on -

• DML Compiler

• Transparent dbms

• Rdms kernel


Some other important questions for exam -

Q. What do you mean by Data independence ?

Ans. In Data Independence Application does not depend on storage structure , basically two types of data independence which are listed below -

Physical Data independence - Any changes in Physical Level Should not affect the logical level .

Logical Data Independence - Any changes in Logical level should not affect the view level .

Q. What is an Attribute ?

Ans. Its is a particular property which describes the entity .


Q. What is join dependency ?

Ans.  Join dependency - join dependency is generalization of multivalued dependency , A join dependency ( R1 , R2 , ......... Rn ) is said to hold over a relation R if R1 , R2 ,.... , Rn is a lossless join decomposition of R . There is no set of sound and complete inference rules for join dependency .

Q. Write disadvantage of file processing -

Ans.  -

• Security problem 

• Data integrity

• facing problem in accessing data 



No comments:

Post a Comment