MC9213 –DATABASE MANAGEMENT SYSTEMS
Question Bank:
2 Mark Questions
1. Define Database?
2. What is a DBMS?
3. What is the need for database systems?
4. Define tupule?
5. What are the responsibilities of DBA?
6. Define schema?
7. Define entity and give example?
8. What is meant by foreign key?
9. What are the difference between unique
key and Primary
Key?
10.
Define meta data?
11.
What are the
disadvantages of database systems?
12.
What is meant by
weak entities? Give example
13.
What is domain
relational calculus?
14.
Define Query
Language?
15.
Define Data
model?
16.
What are the 3
levels of data abstraction?
17.
What are the
advantages of relational model?
18.
Define relation
and relationship set?
19.
Define attribute.
List its types?
20.
What is meant by
entity set?
21.
What are the
different types of data models?
22.
What is the
difference between candidate key and super key?
23.
What is meant by
relational model?
24.
What are the
components of storage manager?
25.
What is the
difference between composite and simple attributes?
26.
Compare database
systems and file systems.
27.
Give the
distinction between primary key, candidate key and Super key.
28.
What is derived
attribute? Give an example?
29.
What is the
difference between Weak and strong entity set?
30.
What is the
difference between a procedural and non-
procedural languages?
16 Mark Questions:
1.
What are the
disadvantages of DBMS compare to file processing systems? Explain in detail?
2.
Draw a system
architecture of DBMS. Explain each component in detail.
3.
Explain various
types of data models in detail.
4.
Compare network
and hierarchical model. Explain with example?
5.
What is meant by
E-R model? Explain with e.g.
6.
What are the
various types of attributes? Explain each with example?
7.
Write detail
notes on relational algebra.
8.
Explain domain
and tuple relational calculus in detail.
9.
What is the need
of relational model? Explain with example?
10.
List the
different types of database users with their roles.
11.
What is the role
of DBA in the DBMS?
QUESTION BANK
Very Short Type Questions
1.
What is data ?
2.
Describe database
?
3.
What is database
management system ?
4.
What is RDBMS ?
5.
Write full form
of SQL ?
6.
Describe Relational model ?
7.
Write three views of three level architecture
?
8.
Explain Data models ?
9.
SQL is the combination of _ and _ .
10.
Define data dictionary ?
11.
Define the following terms:
DDL & DML ?
12.
Define schema ?
13.
Define schema instance ?
14.
What are the basi units of ER diagrams ?
15.
Describe primary key ?
16.
Describe foreign key ?
17.
Describe candidate key ?
18.
Explain data integrity ?
19.
Briefly describe entity integrity ?
20.
Briefly describe referential integrity ?
21.
Define week entities ?
22.
Define relational database ?
23.
What is specialization ?
24.
What do you mean by identifier ?
25.
Define relational schema ?
26.
What do you mean by unary relation ?
27.
What are the function of selection and
projection operation ?
28.
What is data abstraction ?
29.
Briefly describe the concept of metadata ?
30.
What do you mean by cardinality ?
31.
Define the following terms :
a.
tuple
b.
Domain
32.
Define the following terms :
a.
Field
b.
Record
33.
What do you mean by information ?
34.
What is data redundancy ?
35.
Describe DCL ?
36.
Describe DDL ?
37.
Describe DML ?
38.
Various operations use in relational algebra.
39.
Various operations use in relational calculas.
40.
What are the various features of join operations
?
41.
What are various data types use in SQL ?
42.
Is SQL non procedural language ?
43.
Why tuples are used in relational model ?
44.
What is the other two name of attribute ?
45.
What is the function of update and delete
command ?
46.
What do you mean by composite key ?
47.
What do you mean by dependent and independent
entities ?
48.
What is an entity set ?
49.
Describe regular entities ?
50.
What do you mean by Hierarchical model ?
51.
What do you mean by key ?
52.
Write types of keys ?
53.
What do you mean by integrity constraints ?
54.
What do you mean by procedural DML ?
55.
What is query processing ?
56.
What is the function of parser in query
processing ?
57.
What is file organization ?
58.
What are direct files ?
59.
What do you mean by hashing ?
60.
What do you men by transaction processing ?
61.
What do you mean by B-tree ?
62.
Briefly describe file processing ?
63.
Briefly describe Data base processing ?
64.
Name all the models available for database
system ?
65.
Write down the two difference between DBMS & RDBMS ?
66.
What is Normalization ?
67.
What do you mean by data dictionary ?
68.
Write down the four components of DBMS ?
69.
Write down the four components of DBMS environment ?
70.
Write down the full forms of CASE tools ?
71.
What is DOMAIN ?
72.
What is domain value ?
73.
Write different types of constraints ?
74.
What is the difference between numeric and
float data type in SQL?
75.
What is Query optimization ?
76.
What are the two function of DB manager ?
77.
Different types of users .
78.
Where we store data structure in DBMS ?
79.
Where we have to change in data when changes
occur in data ?
80.
Briefly describe client server model ?
81.
What do you mean by null constraints ?
82.
What is metadata ?
83.
What are the basic units of E-R diagrams ?
84.
What do you mean by attribute ?
85.
What do you mean by SQL ?
86.
Describe distributed DBMS ?
87.
Briefly describe application programmers ?
88.
What do you mean by comparison operator ?
89.
Different types of select query ?
90.
Two comparison b/w Network and relational
model ?
91.
How does a view differ from a table ?
92.
Describe object oriented approach ?
93.
Why drop query is used ?
94.
Full form of BCNF ?
95.
What is the difference b/w 3NF and BCNF ?
96.
What is meant functional dependency ?
97.
What is the need of normalization ?
98.
What do you mean by mapping operation ?
99.
What is the difference b/w procedural and non
procedural query languages ?
100.
What do you mean by degree of relationship set ?
Short Type Questions
Q1. What do you mean by
cardinality? What are different kinds of cardinalities ?
Q2. Define DDL
(b)
DML
Q3. What is a primary key ?
Q4. What are various Data
types in SQL ?
Q5. What is relation ? Define
the relational data model.
Q6. What do you mean by SQL
?What are the characteristics of SQL ?
Q7. What is the role of
Database Administrator ?
Q8. What do you mean by
Database and Database Management System ?
Q9. What are problems with
traditional file processing system ?
Q10. What do you mean by Data
processing ?
Q11. What is meant by an
entity, attributes, entity set and relationship ?
Q12. How is E-R data model
useful ?
Q13. Define an attribute.
What is a key attribute ?
Q14. Define subtype and super
type entities ?
Q15. Give example of
following relationships :
(i) Many-to-One
(ii) One-to-One
(iii)
One-to-Many
(iv)
Many-to-Many
Q16. Define foreign key ? How
does it play a role in the join operation ?
Q17. What do you mean by
Mapping Operation ?
Q18. What do you mean by
redundancy ?How this can be avoided ?
Q19. What do you mean by
Normalisation ? Why this is useful ?
Q20. What is the difference
between Procedural DML and Non-Procedural DML ?
Q21. What do you mean by
instance & schema ? Explain the difference between these.
Q22. What are the various
components of a database system ?
Q23. What is the role of
three levels of Data Abstraction ?
Q24. How is a many-to-many
relationship mapped onto a table ?
Q25. What do you mean by a
key ? Explain the difference between primary key and Candidate key.
Q26. What is the difference
between the strong entity set and weak entity set ?
Q27. Give SQL statement which
creates a STUDENT table consisting of following fields.
Name CHAR(40)
Class CHAR(6)
Marks NUMBER(4)
Rank CHAR(8)
Q28. What is a relation ?
What is the difference between a table and an attribute.
Q29. If R1 is a relation with
5 rows and R2 is a relation with 3 rows, how many rows will the Cartesian
product of R1 and R2 have ?
Q30. Which subdivision of SQL
is used to put values in tables and which one to create tables ?
Q31. Why Data Control
Language (DCL) is used ? Explain.
Q32. Explain the type of
relationship the following have :
Student
and ID card
Customer
and Bank
Student
and Roll No
Customer
and Car
Q33. Differentiate between
SQL commands DROP TABLE and DROP VIEW.
Q34. Is Data Dictionary an
essential part of DBMS. Why ?
Q35. What is meant by the
term Query Processing ? What are the various steps involved in this process ?
Q36. What is the difference
between WHERE and Having Clause ?
Q37. What is file organization
? Explain Sequential-files and direct-Files ?
Q38. Differentiate between
First Normal form and Second Normal form.
Q39. What is a multivalued
dependency ? What kind of constraint does it specify ?
Q40. Discuss the various type
of join operations ? Why are these join required.
Q41. List the operations of
relational algebra and purpose of each.
Q42. What is the difference
between tuple relational calculus and domain relational calculus?
Q43. SQL is called as
non-procedural language. Explain ?
Q44. What you mean by
attribute ? Explain various type of attributes.
Q45. Define the following
terms :
(a) Tuple (b) Domain
(c) Relation (d) Entity
(e) Regular entities
Q46. What is the difference
between select and project operation ? Give example.
Q47. Explain the concept of
metadata.
Q48. What is the need for
Normalisation ? Define Third Normal form.
Q49. Explain the term
Distributed DBMS and Client-Server DBMS.
Q50. What do you mean by
Hashing ?
Q51. What is integrity ?
1)
What is ER
Diagram? What are the symbols used is it?Explain with an example.
2)
What is the need
of the normalization? Explain the first three steps involed in the
normalization.
3)
List out all the
Codd’s rules.
4)
What do u mean by
the database abstraction?how many types are there?
5)
Difference
between file oriented approach and database management.
6)
Difference
between Database systems and Knowledge base systems.
7)
Explain the
client server architechure in detail.
8)
What is the
architecture of the database.Explain with diagram.
9)
What is DBA,wht
are DBA’s functions?
10)
Draw the ER diagram for the banking system.
11)
What is query
processing .explain the various steps involved
in it.
12)
What is database
management system, what are its characteristics? What is the need of database
management .
13)
What is
structured query language? How the DDL and DML are different?explain.
14)
What is the file system.Explain the sequential
files and direct files.
15)
What are the drawbacks of the file
systems.Explain in detail.
16)
What is the data
reduncdancy?how to remove the data redundancy?explain any
Long Type Questions
Q1. What are various components of Database
System ? Explain in detail.
Q2. What do you mean by data models ? Explain
network, hierarchical and relational model in detail.
Q3. Explain various levels of Data abstraction in
database system ?
Q4. What do you mean by database ? What is the
purpose of a database system ? Explain.
Q5. What do you mean by DBMS ? Explain its
functioning.
Q6. Explain architecture of DBMS and its advantages
? state two main disadvantages of DBMS ?
Q7. What is DBA ? What are major responsibilities
of DBA and database designers ?
Q8. What are problems with traditional file
processing system ? How they are removed in database system ? Explain
Q9. What do you mean by Entity-Relationship
Diagram ? Explain
Q10.Explain the various terms
of an E-R model and how are they represented in an E-R model ?
Q11.What is meant by term
relationship between entities ? Explain the different types of relationships
that can exist with examples ?
Q12.Explain the concept of
dependent entities ? give example.
Q13.What do you mean by
mapping cardinalities ? Explain various type of cardinalities.
Q14.What is difference
between total and partial participation ? Explain.
Q15.What is the difference
b/w single and multivalued attributes ? Explain.
Q16.Explain the concept of
participation constraints ?
Q17.Discuss the various
update operation on relation and types of integrity constraints that must be
checked for each update operation ?
Q18.Discuss the various types
of join operations ? Why are these join required ?
Q19.What do tyou mean by
normalization ? Explain.
Q20.What do you mean by BCNF
? Why it is used and how it differ from 3 NF ?
Q21.Describe the three-level
architecture of DBMS ? Also explain its importance in a database environment.
Q21. Discuss concept of database language and
interfaces.
Q22. Give the various
advantages and disadvantages of the network model.how it differ from relational
model ?
Q23. What is relationship ?
What are various types of relationship ? Explain with example.
Q24. Explain the Codd’s Rule
in detail.
Q25. What do you mean by
RDBMS ? What are its characteristics ?
Q26. Explain Entity integrity
and Referential integrity in detail.
Q27. What is the difference
between DBMS and RDBMS ? Which of them is more suitable?
Q28. What is relational
algebra ? Discuss the various operations of relational algebra.
Q29. Describe the different
types of relational calculus in detail.
Q30.What dis relational
calculus ? Differentiate relational algebra and relational calculus.
Q31. What do you mean by Null
values? Explain with suitable examples.
Q32. Why normalization needed
? What are its disadvantages ?
Q33..Discuss the various
normal form in normalization with suitable examples.
Q34. Define term
anomalies.Explain BCNF in detail.
Q35. Why is concurrency
control needed? Explain lost update, Inconsistent retrievals and uncommitted
dependency anomalies.
Q36. What is a deadlock ? How
can a deadlock occur ? explain.
Q37. Briefly explain one
deadlock prevention algorithm.
Q38. What if time stamping is
used ? Explain briefly
Q39. What is two-phase
locking and how does it guarantee serializability ?
Q40. Discuss the concurrency
control mechanism in detail using suitable example.
Q41. Differentiate between
Two phase locking and Rigorous two-phase locking.
Q42. How can deadlocks be
avoided when using 2PL?
Q43. How Share and exclusive
locks differ ?Explain.
Q44. How precedence graph can
be used to detect deadlock ?
Q45. What is a system log ?
What is the purpose of the system log in system recovery ?
Q46. What do you understand
by distributed databases? Give the various advantages and disadvantages of
distributed database management system.
Q47. Explain the architecture
of Client-Server databases in detail.
Q48. What are the main
differences between a parallel and a distributed system ? Explain.
Q49.Discuss the concept of
Query Processing .What is a parser ? Why it is used ?
Q50.What is Query
optimization ?What are different techniques used in it.
DBMS QUESTION BANK
1.
Write the
difference between Database systems Vs File system
2.
Explain View of
Data.
3.
Define the
following terms
(a). Instances
(b) schemas (c)
logical schema (d) physical schema
4.
Explain Briefly
about Data Models
(a) E-R model
(b) Relational Model (c)
Object-Oriented Model
5.
Explain Database
languages
(a) DDL
(b) DML (c)
Database access from Application programs
6.
Explain Database
Users and Administrators
7.
Explain
Transaction Management.
8.
Briefly explain
Database system Structure
9.
Explain Entity
sets and Relationship Sets.
10.
Explain
Attributes and its types with examples.
11.
Explain
Constraints and its types with examples.
12.
Explain Mapping
Cardinalities with example.
13.
Define keys and
its types with examples.
14.
Explain Overall
logical structure of E-R Diagram.
15.
Explain Symbols
used in the E-R notation.
16.
Define UML and
symbols used in UML notations.
17.
Explain
Relational Algebra and explain all its Fundamental operations with examples.
18.
Explain
Composition Operations in Relational Algebra.
19.
Explain Formal
Definition of the Relational Algebra.
20.
Explain Views
with examples.
21.
Explain Tuple
Relational Calculus with all operations. Explain Difference between Tuple
Relational Calculus with Relational Algebra.
22.
Explain Domain
Relational Calculus with example. And
state the difference between this and Tuple relational calculus.
23.
What is Join and
its types with example queries.
24.
What is
embedded-sql with example.
25.
Explain Assertion
with examples.
26.
Explain Cursor
and its types with examples.
27.
Explain Security
and its Violations with examples.
28.
Explain
Authorization with examples.
28.
Define 3NF with
examples.
29.
Define Domain
constraints ?
30.
Explain
Referential Integrity constraints with example ?
31.
Is Database
Modification Violates Referential integrity ?
32.
Define Assertions
with example ?
33.
Explain Triggers
with examples ?
34.
Explain Triggers
in SQL ? and its types with examples. ?
35.
Explain when not
to use Triggers ?
36.
Explain Security
Violations with examples.
37.
Explain
Authorization ?
38.
Explain Granting
of Privileges ?
39.
Define Audit trail with example ?
40.
Explain Authorization in SQL ?
41.
Explain First Normal Form with example ? (*)
42.
Explain Functional dependency and
full-functional
dependency ? (*)
43.
Explain Decomposition and its properties ? (*)
44.
Explain
Boyce-codd normal form with example ? (*)
45.
Explain Third
normal form with example ? (*)
46.
Explain Fourth
normal form with example ? (*)
47.
State the
difference between Boyce-codd normal form and
third normal form ?
48.
Explain
Extraneous attributes ?
49.
Explain referential integrity, DB modification
with on delete
cascade and on update
50.
Explain
Triggers and its types with examples.
51.
Explain
Authorization in SQL with examples.
52.
Explain
Functional dependency and Trivial functional
dependency with examples.
53.
Explain Fourth
normal forms with examples.
54.
Explain Closure
of Set of Functional dependency and Closure of Attribute sets
55.
Explain Canonical
cover and Extraneous Attributes with examples.
56.
Explain BCNF with
examples and also state the difference between this from 3NF.
No comments:
Post a Comment