III Semester B.C.A. Degree Examination, May/June 2013 (Old Scheme) 3BCA – 1 : DATABASE MANAGEMENT SYSTEMS Time : 3 Hours
Max. Marks : 80
Instruction : Answer all the Sections. SECTION – A Answer any eight questions.
(8×3=24)
1. What are the responsibilities of the DBA ?
3
2. Explain program – data Independence.
3
3. What do you mean by domain of an attribute ? Give one example.
3
4. Differentiate between spanned and unspanned records.
3
5. Define super key, candidate key, composite key.
3
6. Define first normal form.
3
7. Explain Cartesian product in relation algebra.
3
8. Mention different recovery techniques.
3
9. Explain Insert, delete, update commands in SQL.
3
10. Explain domain constraints.
3 SECTION – B
Answer any four questions.
(14×4=56)
11. a) With a neat diagram, explain three schema architecture of DBMS. b) Explain any three characteristics of DBMS. 12. a) Explain different types of attributes. b) What is relationship ? Give one example for one-to-one and one-to-many relationship.
8 6 7 7 P.T.O.
*MS540*
MS – 540 13. a) Explain 2NF, 3NF, BCNF with examples. b) Explain natural JOIN operation in relation algebra. 14. a) What are the operations performed on files ? b) Explain relational model.
9 5 8 6
15. a) Explain views in SQL.
6
b) With a neat diagram explain centralized DBMS architecture. 16. Write short notes on i) Aggregate functions ii) Difference (–) operation in SQL iii) Commit and Rollback.
1. What are the responsibilities of the DBA ? 3. 2. Explain program â data Independence. 3. 3. What do you mean by domain of an attribute ? Give one example.
issue no. and name. Any member can only. read the journal/magazine in library itself. i.e Journal/Magazine cannot be issued. CS-06 1 P.T.O.. Page 1 of 4 ...
2. a) Give an ER diagram for student database, with all essential ER concepts. 12. b) Write the ... b) Explain the ORACLE languages and interfaces briefly. 10. 8.
We might choose to identify a dependent by name alone in this situation, since it is ..... Each song is performed by one or more musicians, and a musician may ...
c) Discuss the classification of DBMS. 5. 2. a) What are the different types of attributes ? Explain with examples. 10. b) Explain the ER-to-relational mapping ...
5.9 Distributed Serializability. 5.10 Classification of Concurrency Control Techniques ... 7.5 Global Query Optimization Algorithms. 7.6 Distributed Database Security. 7.7 View Management ... Laboratory Work with oracle latest version: Page 3 of 6. I
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.
database objects. A DBMS allows different user application programs to concurrently access the same ... Page 3 of 9. 1.8.1 Database Management Systems.pdf.
site has the following database management systems 3rd edition available for free PDF download. You may find database management systems 3rd edition ...
The management of data in telecommunications system has many aspects whereof some, but .... initialize a database schema, start Mnesia, and create tables.
