DBMS interview questions – page 6

What is Denormalization?

What is a degree of Relation?

What do you mean by transparent DBMS?

When does checkpoint occur in DBMS?

What is a checkpoint in DBMS?

What is a view? How it is related to data independence?

What is System R? What are its two major subsystems?

Define the "integrity rules"?

Describe the three levels of data abstraction?

What are the disadvantage in File Processing System?

What is Query evaluation engine?

What is DDL (Data Definition Language)?

What is an Entity?

What is E-R model?

What is Data Model?

What is the concept of sub-query in terms of SQL?

What are the different types of languages that are available in the DBMS?

What is the purpose of normalization in DBMS?

What is meant by a Database?

What is DBMS used for?

Why we cannot use WHERE clause with aggregate functions like HAVING ?

Name the student who has secured third highest marks using sub queries.

What is the difference between primary key and unique constraints?

What are super, primary, candidate and foreign keys?

What are advantages of DBMS over traditional file based systems?

What is DBMS?