Go Back   2020-2021 StudyChaCha > StudyChaCha Discussion Forum > General Topics





  #1  
Old May 3rd, 2014, 01:32 PM
Super Moderator
 
Join Date: Dec 2011
Default

Will you please share the previous year Gujarat Technological University Question Paper of Computer Engineering, 3rd Sem, Database Management System Exam???

As you want I am here providing you sample question paper of Computer Engineering 3rd Sem Database Management System of GTU.

Sample paper :

Q.1 (a) What is data independence ? Explain the difference between physical and logical
data independence with example.
05
(b) List the ACID properties. Explain the usefulness of each 05
(c) What are the responsibilities of a DBA ? 04
Q.2 (a) Explain following Term with suitable example
(1) Primary Key (2) Candidate Key (3) Super Key (4) On delete cascade
06
(b) Write down the query for the following table where primary keys are underlined.
Person(ss#, name, address)
Car(license, year, model)
Accident(date, driver, damage-amount)
Owns(ss#, license)
Log(license, date, driver)
(1) find the total number of people whose cars were involved in accidents in
2009.
(2) Find the number of accidents in which the cars belonging to “S.Sudarshan”
(3) Add a new customer to the database.
(4) Add a new accident recorded for the Santro belonging to “KORTH”
08
OR
(b) Consider the employee data. Give an expression in SQL for the following query :
Employee(employee-name, street,city)
Works(employee-name, company-name,salary)
Company(company-name, city)
Manages(employee-name, manager-name)
(1) find the name of all employees who work for State Bank.
(2) Find the names and cities of residence of all employees who work for State
Bank.
(3) Find all employee in the database who do not work for State Bank.
(4) Find all employee in the database who earn more than every employee of
UCO Bank.

GTU -Computer Engineering -3rd Sem -Database Management System- sample paper



Last edited by Aakashd; May 31st, 2019 at 01:32 PM.
Reply With Quote
Other Discussions related to this topic
Thread
Difference between file processing system and database Management system
Database Management System pdf
Advantages Of Database System
DOEACC B Level Course Object Oriented Database Management System Exam Papers
Pune University Question Papers for SE Computer Engineering
ISRO Computer Science Engineering Question papers
Cochin University B.Tech in CSE 6th Sem Database Management Systems Exam Papers
IETE ALCCS Database Management Systems past Papers
ICWAI Operation Management and Information System previous years question papers
DOEACC A Level Introduction to Database Management Systems Previous Years Question Pa
SAIL Management Trainee Exam Computer Science Question Papers
Gujarat Technological University MCA 2nd Sem-Database Management System-II previous y
JNTU B.Tech in Computer Science and Engineering-2nd Year Database Management Systems
Mumbai University, B.E in Computer Science, 4th Sem., Database Management previous ye
BPUT-B.Tech 2nd Year- Relational Database Management Systems Exam Papers
PTU MCA 4th Sem-Relational Database Management System –II Exam Papers
TNOU MCA 3rd Year Relational Database Management Systems Exam past Papers
M.Sc in IT 2nd sem Database Management Systems and Oracle previous year’s question pa
Question papers pattern of diploma in Computer Engineering
Pune University Question Papers For TE Computer Engineering






  #2  
Old May 5th, 2014, 02:55 PM
Sashwat's Avatar
Super Moderator
 
Join Date: Jun 2011
Default Re: GTU Computer Engineering 3rd Sem Database Management System Question Papers

Here I am sharing the previous year Gujarat Technological University Question Paper of Computer Engineering, 3rd Sem, Database Management System Exam

Subject Name: Database Management System
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q.1 (a) What is data independence ? Explain the difference between physical and logical
data independence with example.
05

(b) List the ACID properties. Explain the usefulness of each 05

(c) What are the responsibilities of a DBA ? 04

Q.2 (a) Explain following Term with suitable example
(1) Primary Key (2) Candidate Key (3) Super Key (4) On delete cascade
06

(b) Write down the query for the following table where primary keys are underlined.
Person(ss#, name, address)
Car(license, year, model)
Accident(date, driver, damage-amount)
Owns(ss#, license)
Log(license, date, driver)
(1) find the total number of people whose cars were involved in accidents in
2009.
(2) Find the number of accidents in which the cars belonging to “S.Sudarshan”
(3) Add a new customer to the database.
(4) Add a new accident recorded for the Santro belonging to “KORTH”
08

OR
(b) Consider the employee data. Give an expression in SQL for the following query :
Employee(employee-name, street,city)
Works(employee-name, company-name,salary)
Company(company-name, city)
Manages(employee-name, manager-name)
(1) find the name of all employees who work for State Bank.
(2) Find the names and cities of residence of all employees who work for State
Bank.
(3) Find all employee in the database who do not work for State Bank.
(4) Find all employee in the database who earn more than every employee of
UCO Bank.
08
Q.3 (a) Draw E – R Diagram for the School Management System. 07

(b) Explain 1NF, 2NF, 3NF and BCNF. 07

OR
Q.3 (a) Draw E – R Diagram for Library Management System. 07

(b) Consider a relation R with five attribute A,B,C,D,E having following dependencies
: A B, BCE and EDA
a)List all Keys for R
b) In which normal form table is, justify your answer.
07

Q.4 (a) What is join ? Explain various type of joins with example 07

(b) Write Note on Cursor and its types 07

OR
Q.4 (a) What is deadlock ? When it is occurs and how to avoid it ? 07

(b) Explain Trigger with example. 07

Q.5 (a) Explain Strict two phase locking with it’s advantage and disadvantages. 07

(b) Explain DDL,DML,DCL 05
(c) Define Discretionary access control 02
OR

Q.5 (a) Explain linear search and binary search algorithm for selection operation. 07

(b) Write with example various built in string functions. 05
(c) Describe Data Encryption. 02

Address:
Gujarat Technological University
Sabarmati, Koba Highway, Near VISAT Three Road, Nr. Vishwakarma Government Engineering College, Chandkheda, Ahmedabad, Gujarat 382424 ‎
079 2630 0499 ‎

Map:

__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Tags
Previous questions papers

Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6.5. The time now is 06:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8