Question
#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
#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?
Step by Step Solution
3.43 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started