Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

#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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Categorical Data Analysis

Authors: Alan Agresti

2nd Edition

470463635, 978-0-471-4587, 978-0471360933

More Books

Students also viewed these Databases questions

Question

3. On the playground, raise a hand or whistle to indicate Line up.

Answered: 1 week ago