Solapur University Question Paper
(SeM.C.A. – I(Semester – II) Examination, 2014
(Commerce and Management Faculty)
DATABASE MANAGEMENT SYSTEM (Old)
Day and Date : Wednesday, 7-5-2014 Total Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) Q. No. 1 and 7 are compulsory.
2) Attempt any two questions from Q. 2 to Q. 4.
3) Attempt any one questions from Q. 5 to Q. 6.
4) All questions carry equal marks.
1. A) Choose the correct alternatives from the following : 7
1) In an ER diagram ellipse represent
a) entity sets b) relationship among entity set
c) attribute d) link between attribute and entity set
2) ER modelling technique is
a) top-down approach b) bottom-up approach
c) left-right approach d) none of these
3) Check constraint is used with
a) insert b) delete c) create d) update
4) The employee salary should not greater than 2000 this is
a) integrity constraints b) referential constraints
c) over defined d) feasible constraints
5) Redundancy is dangerous as it is a potential threats to data
a) integrity b) consistency
c) both (a) and (b) d) none of these
P.T.O.
Seat
No.
SLR-GL – 12 -2-
6) The dual table has
a) one row with many columns b) one column with many rows
c) one row one column d) many rows many column
7) ________ is memory buffer containing the data and control information for
the server process.
a) SGA b) PGA c) Buffer d) Cache
B) State whether true or false : 7
1) Files and records are data element of hierarchical model.
2) In network model relationship among data are represented by links.
3) The term cardinality is used to describe the relationship classifications.
4) 3NF is based on the concept of full functional dependency.
5) DES provides standard based encryption for data privacy.
6) For giving all rights to user grant used “all” keyword.
7) Logging facilities that enables updates to database that are in progress to
be made permanent.
2. Define the term : 14
1) Transaction Recovery
2) Achieve log file
3) W-timestamp and R-timestamp
4) Dirty Bit
5) Serializability
6) DML
7) 3NF.
3. Answer the following : 14
1) Explain the advantages and disadvantages of DBMS.
2) Explain Granting of Privileges.
4. Answer the following : 14
1) Explain functional and multivalved dependency.
2) What is concurrency control ? Explain 2Phase Locking Protocol.
-3- SLR-GL – 12
5. Consider following table and write SQL statement for following : 14
1) warehouse (wh–id, location, no–of–branch, phone).
2) cities (city, city–id, state).
3) stored (wh–id, item-no, qty).
4) items (item–no, description, weight).
5) orders (ord–no, ord–date, cust–name).
6) item–orders (item–no, ord–no, qty–orderd).
7) customer (cust–name, first–ord–date, live–in–city).
a) Display the warehouse located in Pune.
b) The list of item whose weight less than 10.
c) Dates of all orders made by Mr. Shah.
d) The warehouse which holds all items in ord–no 9.
e) The total quantity held by each warehouse.
f) The location of warehouse holding electrode item.
g) Displays rows having cust–name begins with letter M.
Solve any 5 queries.
6. What is need of normalization ? Explain its different normal forms. 14
7. Draw system architecture of DBMS. Explain each component in details. 14
_______________
(SeM.C.A. – I(Semester – II) Examination, 2014
(Commerce and Management Faculty)
DATABASE MANAGEMENT SYSTEM (Old)
Day and Date : Wednesday, 7-5-2014 Total Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) Q. No. 1 and 7 are compulsory.
2) Attempt any two questions from Q. 2 to Q. 4.
3) Attempt any one questions from Q. 5 to Q. 6.
4) All questions carry equal marks.
1. A) Choose the correct alternatives from the following : 7
1) In an ER diagram ellipse represent
a) entity sets b) relationship among entity set
c) attribute d) link between attribute and entity set
2) ER modelling technique is
a) top-down approach b) bottom-up approach
c) left-right approach d) none of these
3) Check constraint is used with
a) insert b) delete c) create d) update
4) The employee salary should not greater than 2000 this is
a) integrity constraints b) referential constraints
c) over defined d) feasible constraints
5) Redundancy is dangerous as it is a potential threats to data
a) integrity b) consistency
c) both (a) and (b) d) none of these
P.T.O.
Seat
No.
SLR-GL – 12 -2-
6) The dual table has
a) one row with many columns b) one column with many rows
c) one row one column d) many rows many column
7) ________ is memory buffer containing the data and control information for
the server process.
a) SGA b) PGA c) Buffer d) Cache
B) State whether true or false : 7
1) Files and records are data element of hierarchical model.
2) In network model relationship among data are represented by links.
3) The term cardinality is used to describe the relationship classifications.
4) 3NF is based on the concept of full functional dependency.
5) DES provides standard based encryption for data privacy.
6) For giving all rights to user grant used “all” keyword.
7) Logging facilities that enables updates to database that are in progress to
be made permanent.
2. Define the term : 14
1) Transaction Recovery
2) Achieve log file
3) W-timestamp and R-timestamp
4) Dirty Bit
5) Serializability
6) DML
7) 3NF.
3. Answer the following : 14
1) Explain the advantages and disadvantages of DBMS.
2) Explain Granting of Privileges.
4. Answer the following : 14
1) Explain functional and multivalved dependency.
2) What is concurrency control ? Explain 2Phase Locking Protocol.
-3- SLR-GL – 12
5. Consider following table and write SQL statement for following : 14
1) warehouse (wh–id, location, no–of–branch, phone).
2) cities (city, city–id, state).
3) stored (wh–id, item-no, qty).
4) items (item–no, description, weight).
5) orders (ord–no, ord–date, cust–name).
6) item–orders (item–no, ord–no, qty–orderd).
7) customer (cust–name, first–ord–date, live–in–city).
a) Display the warehouse located in Pune.
b) The list of item whose weight less than 10.
c) Dates of all orders made by Mr. Shah.
d) The warehouse which holds all items in ord–no 9.
e) The total quantity held by each warehouse.
f) The location of warehouse holding electrode item.
g) Displays rows having cust–name begins with letter M.
Solve any 5 queries.
6. What is need of normalization ? Explain its different normal forms. 14
7. Draw system architecture of DBMS. Explain each component in details. 14
_______________
0 comments:
Pen down your valuable important comments below