#1) What do you understand by ‘Database’?

#2) Define DBMS.

#3) Define RDBMS.

#4) Enlist the advantages of DBMS.

#5) What do you understand by Data Redundancy?

#6) What are the various types of relationships in database? Define them.

#7) Explain Normalization and De-Normalization.

#8) What are the different types of Normalization?

#9) What is BCNF?
#10) What is SQL?

#11) How many SQL statements are used? Define them.
#12) Enlist some commands of DDL, DML, and DCL.

#13) Define DML Compiler.
#14) What is DDL interpreter?
#15) Enlist the advantages of SQL.

#16) Explain the terms ‘Record’, ‘Field’ and ‘Table’ in terms of database.

#17) What do you understand by Data Independence? What are its two types?

#18) Define the relationship between ‘View’ and ‘Data Independence’.
#19) What are the advantages and disadvantages of views in the database?
#20) What do you understand by Functional dependency?
#21) When is functional dependency said to be the fully functional dependent?
#22) What do you understand by the E-R model?
#23) Define Entity, Entity type, and Entity set.

#24) Define a Weak Entity set.

#25) Explain the terms ‘Attribute’ and ‘Relations’
#26) What are VDL and SDL?
#27) Define Cursor and its types.

#28) What is the Database transaction?
#29) Define Database Lock and its types.
#30) What is Data Warehousing?
#31) What do you understand by Join?
#32) What do you understand by Index hunting?

#33) How to improve query performance using Index hunting?
#34) Differentiate between ‘Cluster’ and ‘Non-cluster’ index.
#35) What are the disadvantages of a Query?
#36) What do you understand by Fragmentation?

Answer rating: 100% (QA)

The detailed answer for the above question is provided below 1 Database is an organized collection of related data where the data is stored and organized to serve some specific purpose 2 DBMS stands f... View the full answer