2018 question paper
Database Management System
19 questions
Q1a. Data model is collection of conceptual tools for describing (i) data (ii) data schema (iii) consistency constraints (iv) All of the above20182m
Module 1: Database System Architecture
View this question on its own page →Data model is collection of conceptual tools for describing
(i) data
(ii) data schema
(iii) consistency constraints
(iv) All of the aboveQ1b. Data models in DBMS are classified into _____ categories. (i) 3 (ii) 4 (iii) 5 (iv) 220182m
Module 1: Database System Architecture
View this question on its own page →Data models in DBMS are classified into _____ categories.
(i) 3
(ii) 4
(iii) 5
(iv) 2Q1c. Object-based logical models are used to describe data at (i) logical level (ii) view level (iii) physical level (iv) None of the above20182m
Module 1: Database System Architecture
View this question on its own page →Object-based logical models are used to describe data at
(i) logical level
(ii) view level
(iii) physical level
(iv) None of the aboveQ1d. The term _____ is used to refer to a row. (i) attribute (ii) tuple (iii) field (iv) instance20182m
Module 2: Relational Query Languages & Design
View this question on its own page →The term _____ is used to refer to a row.
(i) attribute
(ii) tuple
(iii) field
(iv) instanceQ1e. What is an instance of a database? (i) The logical design of the database system (ii) The entire set of attributes of the database put together in a single relation (iii) The state of the database system at any given point of time (iv) The initial values inserted into the database immediately after its creation20182m
Module 1: Database System Architecture
View this question on its own page →What is an instance of a database?
(i) The logical design of the database system
(ii) The entire set of attributes of the database put together in a single relation
(iii) The state of the database system at any given point of time
(iv) The initial values inserted into the database immediately after its creationQ1f. What is a foreign key? (i) A foreign key is a primary key of a relation which is an attribute in another relation (ii) A foreign key is a superkey of a relation which is an attribute in more than one other relations (iii) A foreign key is an attribute of a relation that is a primary key of another relation (iv) A foreign key is the primary key of a relation that does not occur anywhere else in the schema20182m
Module 1: Database System Architecture
View this question on its own page →What is a foreign key?
(i) A foreign key is a primary key of a relation which is an attribute in another relation
(ii) A foreign key is a superkey of a relation which is an attribute in more than one other relations
(iii) A foreign key is an attribute of a relation that is a primary key of another relation
(iv) A foreign key is the primary key of a relation that does not occur anywhere else in the schemaQ1g. To include integrity constraint in an existing relation use (i) create table (ii) modify table (iii) alter table (iv) drop table20182m
Module 2: Relational Query Languages & Design
View this question on its own page →To include integrity constraint in an existing relation use
(i) create table
(ii) modify table
(iii) alter table
(iv) drop tableQ1h. Which of the following is not an integrity constraint? (i) Not null (ii) Positive (iii) Unique (iv) Check 'predicate'20182m
Module 1: Database System Architecture
View this question on its own page →Which of the following is not an integrity constraint?
(i) Not null
(ii) Positive
(iii) Unique
(iv) Check 'predicate'Q5. Consider the universal relation R = \{A, B, C, D, E, F, G, H, I\} and the set of functional dependencies F = \{\{A, B\} \rightarrow \{C\}, \{A\} \rightarrow \{D, E\}, \{B\} \rightarrow \{F\}, \{F\} \rightarrow \{G, H\}, \{D\} \rightarrow \{I, J\}\} What is the key for R? Decompose R into 2NF, then 3NF relations.201814m
Module 2: Relational Query Languages & Design
View this question on its own page →Consider the universal relation and the set of functional dependencies
What is the key for ? Decompose into 2NF, then 3NF relations.Q6a. Explain the different integrity constraints in database system with the help of example.20187m
Module 1: Database System Architecture
View this question on its own page →Explain the different integrity constraints in database system with the help of example.
Q6b. Briefly explain the ACID property of database system.20187m
Module 4: Transaction Processing
View this question on its own page →Briefly explain the ACID property of database system.
Q7a. Explain the select, project, join and division with the help of example.20187m
Module 2: Relational Query Languages & Design
View this question on its own page →Explain the select, project, join and division with the help of example.
Q7b. Explain the immediate update and deferred update of recovery techniques.20187m
Module 4: Transaction Processing
View this question on its own page →Explain the immediate update and deferred update of recovery techniques.
Q8a. What are multivalued and join dependencies in the database system? Explain with the help of example.20187m
Module 2: Relational Query Languages & Design
View this question on its own page →What are multivalued and join dependencies in the database system? Explain with the help of example.
Q8b. What do you mean by concurrent execution and serializability in database system?20187m
Module 4: Transaction Processing
View this question on its own page →What do you mean by concurrent execution and serializability in database system?
Q9a. Write short notes on: ER models20187m
Module 1: Database System Architecture
View this question on its own page →Write short notes on: ER models
Q9b. Write short notes on: SQL and embedded SQL20187m
Module 2: Relational Query Languages & Design
View this question on its own page →Write short notes on: SQL and embedded SQL
Q9c. Write short notes on: Referential integrity in database20187m
Module 1: Database System Architecture
View this question on its own page →Write short notes on: Referential integrity in database
Q9d. Write short notes on: Query optimization20187m
Module 2: Relational Query Languages & Design
View this question on its own page →Write short notes on: Query optimization