DBMS interview questions – page 5

What are conflict serializable schedules?

What is the use of SAVEPOINT command?

What is the use of COMMIT command?

What is the difference between DROP and TRUNCATE query?

What is the difference between DELETE and TRUNCATE query?

What is TCL in RDBMS?

What is 4NF?

What is 3NF?

What is 2NF?

What is BCNF (Boyce-Codd Normal Form)?

What is 1 NF (Normal Form)?

What is Union, minus and Interact commands?

Difference between delete and truncate?

What are the types of constraint?

Why is a database considered to be “self-describing”?

What are data and information, and how are they related in a database?

Can you explain insert ,update and delete query ?

State difference between simple file and database ?

Explain in brief the different normalization forms?

How is ACID property related to Database ?

What is weak entity ?

What Is Lossless Join Property?

How Does Tuple-oriented Relational Calculus Differ From Domain-oriented Relational Calculus?

What Is Sdl (storage Definition Language)?

What Is Vdl (view Definition Language)?

What is Data Warehousing.

What restrictions can you apply when you are creating views?

Compare Non-clustered and clustered index

Define cursor.

Who proposed the relational model?