2024 question paper
DATABASE MANAGEMENT SYSTEM
26 questions
Q1a. Which of the following is generally used for performing tasks like creating the structure of the relations or deleting relations? - (i) DML - (ii) Query - (iii) Relational schema - (iv) DDL20242m
Unit 1: Database System Architecture
View this question on its own page →Which of the following is generally used for performing tasks like creating the structure of the relations or deleting relations?
- (i) DML
- (ii) Query
- (iii) Relational schema
- (iv) DDL
Q1b. __________ operations do not preserve non-matched tuples. - (i) Inner join - (ii) Left outer join - (iii) Query - (iv) Relational schema20242m
Unit 2: Relational Query Languages
View this question on its own page →__________ operations do not preserve non-matched tuples.
- (i) Inner join
- (ii) Left outer join
- (iii) Query
- (iv) Relational schema
Q1c. What do you mean by one-to-many relationships? - (i) One class may have many teachers - (ii) One teacher can have many classes - (iii) Many classes may have many teachers - (iv) Many teachers may have many classes20242m
Unit 1: Database System Architecture
View this question on its own page →What do you mean by one-to-many relationships?
- (i) One class may have many teachers
- (ii) One teacher can have many classes
- (iii) Many classes may have many teachers
- (iv) Many teachers may have many classes
Q1d. A Database Management System is a type of __________ software. - (i) It is a type of system software - (ii) It is a kind of application software - (iii) It is a kind of general software - (iv) Both (i) and (ii)20242m
Unit 1: Database System Architecture
View this question on its own page →A Database Management System is a type of __________ software.
- (i) It is a type of system software
- (ii) It is a kind of application software
- (iii) It is a kind of general software
- (iv) Both (i) and (ii)
Q1e. Which of the following refers to the “data about data”? - (i) Directory - (ii) Warehouse - (iii) Sub Data - (iv) Meta Data20242m
Unit 1: Database System Architecture
View this question on its own page →Which of the following refers to the “data about data”?
- (i) Directory
- (ii) Warehouse
- (iii) Sub Data
- (iv) Meta Data
Q1f. f) To which of the following term “DBA” referred? - (i) Data Bank Administrator - (ii) Data Administrator - (iii) Database Administrator - (iv) None of the above20242m
Unit 3: Storage and Transaction Processing
View this question on its own page →f) To which of the following term “DBA” referred?
- (i) Data Bank Administrator
- (ii) Data Administrator
- (iii) Database Administrator
- (iv) None of the above
Q1g. Which of the following is not an example of DBMS? - (i) MySQL - (ii) Microsoft Access - (iii) IBM DB2 - (iv) Google20242m
Unit 1: Database System Architecture
View this question on its own page →Which of the following is not an example of DBMS?
- (i) MySQL
- (ii) Microsoft Access
- (iii) IBM DB2
- (iv) Google
Q1h. Which of the following is known as a set of entities of the same type that share same properties or attributes? - (i) Relation set - (ii) Tuples - (iii) Entity set - (iv) Entity relation model20242m
Unit 1: Database System Architecture
View this question on its own page →Which of the following is known as a set of entities of the same type that share same properties or attributes?
- (i) Relation set
- (ii) Tuples
- (iii) Entity set
- (iv) Entity relation model
Q1i. The ability to query data, as well as insert, delete, and alter tuples, is offered by: - (i) TCL (Transaction Control Language) - (ii) DCL (Data Control Language) - (iii) DDL (Data Definition Language) - (iv) DML (Data Manipulation Language)20242m
Unit 2: Relational Query Languages
View this question on its own page →The ability to query data, as well as insert, delete, and alter tuples, is offered by:
- (i) TCL (Transaction Control Language)
- (ii) DCL (Data Control Language)
- (iii) DDL (Data Definition Language)
- (iv) DML (Data Manipulation Language)
Q1j. Which command is used to remove a relation from SQL? - (i) Drop table - (ii) Delete - (iii) Purge - (iv) Remove20242m
Unit 2: Relational Query Languages
View this question on its own page →Which command is used to remove a relation from SQL?
- (i) Drop table
- (ii) Delete
- (iii) Purge
- (iv) Remove
Q2a. Illustrate the database characteristics, How they are different from File systems.20247m
Unit 1: Database System Architecture
View this question on its own page →Illustrate the database characteristics, How they are different from File systems.
Q2b. Draw and explain three level architecture of database system.20247m
Unit 1: Database System Architecture
View this question on its own page →Draw and explain three level architecture of database system.
Q3a. Discuss about different keys used in database design with examples20247m
Unit 2: Relational Query Languages
View this question on its own page →Discuss about different keys used in database design with examples
Q3b. Define a database and explain its importance in modern software systems.20247m
Unit 1: Database System Architecture
View this question on its own page →Define a database and explain its importance in modern software systems.
Q4a. Distinguish strong entity set with weak entity set. Draw an E-R diagram to illustrate weak entity set.20247m
Unit 1: Database System Architecture
View this question on its own page →Distinguish strong entity set with weak entity set. Draw an E-R diagram to illustrate weak entity set.
Q4b. Write an SQL query to retrieve all employees from an "Employees" table with specific criteria (e.g., department, salary range).20247m
Unit 2: Relational Query Languages
View this question on its own page →Write an SQL query to retrieve all employees from an "Employees" table with specific criteria (e.g., department, salary range).
Q5a. Define the process of database normalization and its importance in maintaining d integrity20247m
Unit 2: Relational Query Languages
View this question on its own page →Define the process of database normalization and its importance in maintaining d integrity
Q5b. Explain two-phase locking protocol & conflict serializability. | Unit 3 – Transaction Management | Concurrency control.20247m
Unit 3: Storage and Transaction Processing
View this question on its own page →Explain two-phase locking protocol & conflict serializability. | Unit 3 – Transaction Management | Concurrency control.
Q6a. Difference between Relational Algebra & Calculus.20247m
Unit 2: Relational Query Languages
View this question on its own page →Difference between Relational Algebra & Calculus.
Q6b. Explain ACID properties.20247m
Unit 3: Storage and Transaction Processing
View this question on its own page →Explain ACID properties.
Q7a. Illustrate disadvantages of file processing systems.20247m
Unit 1: Database System Architecture
View this question on its own page →Illustrate disadvantages of file processing systems.
Q7b. Explain three levels of data abstraction.20247m
Unit 1: Database System Architecture
View this question on its own page →Explain three levels of data abstraction.
Q8a. Find the highest normal form of a relation R(ABCD) with FD set (B→A, A→C, BC→D, AC→BE).20247m
Unit 2: Relational Query Languages
View this question on its own page →Find the highest normal form of a relation R(ABCD) with FD set
(B→A, A→C, BC→D, AC→BE).Q8b. A relation R(A,C,D,E,H) is having two functional dependencies sets F={A→C, AC→D, E→AD, E→H} and set G {AC→D, E→AH}, then check F and Gare equivalent or not.20247m
Unit 2: Relational Query Languages
View this question on its own page →A relation R(A,C,D,E,H) is having two functional dependencies sets F={A→C, AC→D, E→AD, E→H} and set G {AC→D, E→AH}, then check F and Gare equivalent or not.
Q9a. What do you mean by concurrency control techniques?20247m
Unit 3: Storage and Transaction Processing
View this question on its own page →What do you mean by concurrency control techniques?
Q9b. Describe the importance of data integrity in a database. How can constraints (such as primary keys and foreign keys) help enforce integrity?20247m
Unit 2: Relational Query Languages
View this question on its own page →Describe the importance of data integrity in a database. How can constraints (such as primary keys and foreign keys) help enforce integrity?