Question bank

Database Management System – Sem. V –

Computer Engineering– 2019-2020 – Odd. Semester

Module I:

Short Questions (for 2 Marks)

1. Drawbacks of file systems.
2. Advantages of DBMS.
3. List the users of Database Systems.
4. Roles of Database Administrator.
5. List when not to use database.
6. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
7. A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
8. The term _______ is used to refer to a row.
a) Attribute
b) Tuple
c) Field
d) Instance
9. Database __________ , which is the logical design of the database, and the database
_______,which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance

10. The tuples of the relations can be of ________ order.

a) Any
b) Same
c) Sorted
d) Constant
11. 6. For each attribute of a relation, there is a set of permitted values, called the
________ of that attribute.
a) Domain
b) Relation
c) Set
d) Schema
12. The term attribute refers to a ___________ of a table.
a) Record
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

b) Column
c) Tuple
d) Key
13. A domain is atomic if elements of the domain are considered to be ____________
units.
a) Different
b) Indivisbile
c) Constant
d) Divisible

Long Question (for 5 Marks)

1. List 4 significant Differences between File Processing System & DBMS?
2. Explain different types of users.
3. Explain data independence.

Long Question (10 Marks)

1. Draw and explain architecture of database management system.

Module II:

Short Questions (for 2 Marks)

1. What is Entity and list its types?
2. What is attribute and list its types?
3. What is weak entity and give its example?
4. Phases of database modeling.
5. Give benefits of data modeling.
6. An ________ is a set of entities of the same type that share the same properties, or
attributes .
a) Entity set
b) Attribute set
c) Relation set
d) Entity model
7. Entity is a
a) Object of relation
b) Present working model
c) Thing in real world
d) Model of relation
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

8. The descriptive property possessed by each entity set is _________ .

a) Entity
b) Attribute
c) Relation
d) Model
9. The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is
a) Single valued
b) Multi valued
c) Composite
d) Derived
10. Not applicable condition can be represented in relation entry as
a) NA
b) 0
c) NULL
d) Blank Space
11. Which of the following can be a multivalued attribute ?
a) Phone_number
b) Name
c) Date_of_birth
d) All of the mentioned
12. In a relation between the entities the type and condition of the relation should be
specified . That is called as______attribute
a) Desciptive
b) Derived
c) Recursive
d) Relative
13. Which of the following gives a logical structure of the database graphically ?
a) Entity-relationship diagram
b) Entity diagram
c) Database diagram
d) Architectural representation
14. The entity relationship set is represented in E-R diagram as
a) Double diamonds
b) Undivided rectangles
c) Dashed lines
d) Diamond
15. An entity set that does not have sufficient attributes to form a primary key is termed a
__________ .
a) Strong entity set
b) Variant set
c) Weak entity set
d) Variable set
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

Long Question (for 5 Marks)

1. ER Diagram on college management system.
2. Explain Super key with example.
3. Explain Primary key with example.
4. Explain Candidate key with example.
5. Explain Foreign key with example.
6. Explain generalization and specialization with example.
7. Explain Aggregation with example.

Long Question (10 Marks)

1. ER Diagram on college management system and map it into relational model.
2. What is attribute? Explain different types of attributes with example?

Module III:

Short Questions (for 2 Marks)

1. List the steps to map ER into Relational Model.
2. Give advantages of relational model.
3. Give SET Operations.
4. Explain IN, NOT IN.
5. Explain EXISTS, NOT EXISTS.
6. Explain Wildcards in database.

Long Question (for 5 Marks)

1. Explain following relational algebra operations with examples:-
a) Set intersection b) Natural Join c) Generalized Projection d) Division Operator
2. Explain different SET operations with example.

Long Question (10 Marks)

1. Explain different types of relational algebra operations with example.
2. Relational algebra queries.

Module IV:
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

Short Questions (for 2 Marks)

1. What is DDL and give its commands.
2. What is DML and give its commands.
3. List different types of aggregate functions.
4. What is DCL and give its commands.
5. List different forms of WHERE Clause.
6. SQL data definition for part of the university database.

create table department

(dept_name varchar (20),
building varchar (15),
budget number,
primary key (dept_name));

Create table course

(course_id varchar (7),
title varchar (50),
dept_name varchar (20),
credits numeric (2,0),
primary key (course_id),
foreign key (dept_name) __________ department);

Create table instructor

(ID varchar (5),
name varchar (20) not null,
dept_name varchar (20),
salary numeric (8,2),
foreign key (dept_name) _______ department);

Create table section

(course_id varchar (8),
sec_id varchar (8),
semester varchar (6),
year numeric (4,0),
building varchar (15),
room_number varchar (7),
time_slot id varchar (4),
primary key (course_id, sec_id, semester, year),
foreign key (_______) ______ course);
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

Create table teaches

(ID varchar (5),
course_id varchar (8),
sec_id varchar (8),
semester varchar (6),
year numeric (4,0),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id, sec_id, semester, year) references section,
foreign key (ID) _______ instructor);

1. Which is the main relation which is used in the university database which is
referenced by all other relation of the university .
a) Teaches
b) Course
c) Department
d) Section

2. The department relation has the an entry budget whose type has to be replaced by
a) Varchar (20)
b) Varchar2 (20)
c) Numeric (12,2)
d) Numeric

3. In the course relation the title field should throw an error in case of any missing
title . The command to be added in title is
a) Unique
b) Not null
c) 0
d) Null

4. In the above DDL command the foreign key entries are got by using the keyword
a) References
b) Key reference
c) Relating
d) None of the above

5. Identify the error in the section relation

a) No error
b) Year numeric (4,0)
c) Building varchar (15)
d) Sec_id varchar (8)
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

6. Which of the following can be used as a primary key entry of the instructor
relation.
a) DEPT_NAME
b) NAME
c) ID
d) All of the above

7. In the section relation which of the following is used as a foreign key ?

a) Course_id
b) Course_id,sec_id
c) Room_number
d) Course_id,sec_id,room_number

8. List domain constraints that can be imposed on database.

9. List referential integrity constraints that can be imposed on database.

Long Question (for 5 Marks)

1. Explain data definition language and its commands with examples.
2. Explain data manipulation language and its commands with examples.
3. Explain data control language and its commands with examples.
4. What is view with example.
5. What is trigger.
6. Domain Constraints with example.
7. Referential Constraints with example

Long Question (10 Marks)

1. Nested Queries.
2. What is trigger and give its types with example.
3. Explain Domain Constraints and Referential Constraints with example.

Module V:

Short Questions (for 2 Marks)

1. Explain 1NF.
2. Explain 2NF.
3. Explain 3NF.
4. Explain BCNF.
5. Explain functional dependency.
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

6. In the __________ normal form, a composite attribute is converted to individual

attributes.
A) First
B) Second
C) Third
D) Fourth
7. A table on the many side of a one to many or many to many relationship must:
a) Be in Second Normal Form (2NF)
b) Be in Third Normal Form (3NF)
c) Have a single attribute key
d) Have a composite key
8. Tables in second normal form (2NF):
a) Eliminate all hidden dependencies
b) Eliminate the possibility of a insertion anomalies
c) Have a composite key
d) Have all non-key fields depend on the whole primary key
9. Which-one of the following statements about normal forms is FALSE?
a) BCNF is stricter than 3 NF
b) Lossless, dependency -preserving decomposition into 3 NF is always possible
c) Loss less, dependency – preserving decomposition into BCNF is always possible
d) Any relation with two attributes is BCNF
10. Functional Dependencies are the types of constraints that are based on______
a) Key
b) Key revisited
c) Superset key
d) None of these
11.
12.
13. 6. Which forms simplifies and ensures that there is minimal data aggregates and
repetitive groups:
a) 1NF
b) 2NF
c) 3NF
d) All of the mentioned
14.
15. 7. Which forms are based on the concept of functional dependency:
a) 1NF
b) 2NF
c) 3NF
d) 4NF

Long Question (for 5 Marks)

1. Explain 1NF, 2NF with examples.
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

2. Explain 3NF, BCNF with examples.

Long Question (10 Marks)

1. What is normalization? Explain 1NF, 2NF, 3NF and BCNF with suitable example?

Module VI:

Short Questions (for 2 Marks)

1. What do you mean by a transaction.
2. List down the deadlock avoidance mechanisms.
3. Consider money is transferred from (1)account-A to account-B and (2) account-B to
account-A. Which of the following form a transaction ?
a) Only 1
b) Only 2
c) Both 1 and 2 individually
d) Either 1 or 2
4. A transaction is delimited by statements (or function calls) of the form __________.
a) Begin transaction and end transaction
b) Start transaction and stop transaction
c) Get transaction and post transaction
d) Read transaction and write transaction
5. Identify the characteristics of transactions
a) Atomicity
b) Durability
c) Isolation
d) All of the mentioned
6. Which of the following has “all-or-none” property ?
a) Atomicity
b) Durability
c) Isolation
d) All of the mentioned
7. The database system must take special actions to ensure that transactions operate
properly without interference from concurrently executing database statements. This
property is referred to as
a) Atomicity
b) Durability
c) Isolation
d) All of the mentioned
8. The property of transaction that persists all the crashes is
a) Atomicity
Question bank
Database Management System – Sem. V –
Computer Engineering– 2019-2020 – Odd. Semester

b) Durability
c) Isolation
d) All of the mentioned
9. __________ states that only valid data will be written to the database.
a) Consistency
b) Atomicity
c) Durability
d) Isolation
10. Transaction processing is associated with everything below except
a) Producing detail summary or exception reports
b) Recording a business activity
c) Confirming a action or triggering a response
d) Maintaining a data
11. The Oracle RDBMS uses the ____ statement to declare a new transaction start and its
properties.
a) BEGIN
b) SET TRANSACTION
c) BEGIN TRANSACTION
d) COMMIT
12. ____ means that the data used during the execution of a transaction cannot be used by
a second transaction until the first one is completed.
a) Consistency
b) Atomicity
c) Durability
d) Isolation

Long Question (for 5 Marks)

1. Explain ACID Properties of a transaction.
2. Explain Serializability and Recoverability.
3. Explain classification of failures.
4. Short note on shadow paging.

Long Question (10 Marks)

1. Explain deadlock avoidance, prevention and detection.
2. Explain lock based concurrency control.
3. Explain timestamp based concurrency control.
4. Explain log based recovery technique.
5. Explain ARIES algorithm.
6. Explain checkpoint.
7. Explain conflict and view Serializability.