Question 1
(a)
Explain the different types of database users.
3 Marks
(b)
What are the responsibilities of a DBA?
4 Marks
(c)
Explain database system 3 tier architecture with clear diagram in detail.
7 Marks
Gujarat Technological UniversitySummer 2023 Examination
GTU 3130703 Database Management Systems (DBMS) Summer 2023 Paper Solution & PDF
B.E. · Computer Engineering · Semester 3 · Subject Code: 3130703
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours2:30 PM – 5:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Explain candidate key, primary key and foreign key.
3 Marks
(b)
Explain Mapping Cardinalities.
4 Marks
(c)
Explain Entity Relationship model with example.
7 Marks
OR OPTION
(c)
What is join? Explain various type of joins with example.
7 Marks
Question 3
(a)
Explain query optimization process.
3 Marks
(b)
Explain 3NF with example
4 Marks
(c)
What is functional dependency? Explain its types in detail.
7 Marks
OR OPTION
(a)
What are anomalies in database design? How can we solve it?
3 Marks
(b)
Explain BCNF with example.
4 Marks
(c)
Enlist and explain the basic steps in Query Processing.
7 Marks
Question 4
(a)
Explain log based recovery and mention all its types.
3 Marks
(b)
Explain Two phase commit protocol?
4 Marks
(c)
What is a transaction? Explain the ACID properties.
7 Marks
OR OPTION
(a)
Write short note on data encryption.
3 Marks
(b)
Explain deadlock detection.
4 Marks
(c)
Explain conflict serializability and view serializability.
7 Marks
Question 5
(a)
Describe GRANT and REVOKE commands
3 Marks
(b)
Explain Transaction Control Commands
4 Marks
(c)
Consider the following employee database, primary keys are underlined : employee (employee-name, street, city) works (employee-name, company-name, salary) company (company-name, city) manages (employee-name, manager_name) Give an expression in SQL for each of the following queries: 1. Find the names of all employees who work for First Bank Corporation.
2Give all employees of First Bank Corporation a 10 percent raise.
3Find the names and cities of residence of all employees who work for First Bank Corporation.
4Find the names, street addresses, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000.
5Find all employees in the database who live in the same cities as the companies for which they work.
6Find all employees in the database who do not work for First Bank Corporation.
7 Marks
OR OPTION
(a)
Explain DDL,DML,DCL with example
3 Marks
(b)
Discuss aggregate functions with example(s).
4 Marks
(c)
Explain stored procedures and stored functions.
7 Marks
College Exam Groups
Studying for Database Management Systems?
Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.
About this Examination Paper & Attribution
Official Gujarat Technological University (GTU) examination paper and step-by-step solutions for Database Management Systems (DBMS) (Summer 2023, B.E. · Computer Engineering, Sem 3). Features complete 70-mark regular & remedial examination pattern, official marking distribution across all 5 questions, and direct 1-click official PDF download.
Transcribed for student exam preparation from Gujarat Technological University official examination archives. Questions, syllabus guidelines, and curriculum marking schemes remain the intellectual property of Gujarat Technological University.