FACULTY OF INFORMATICS B.E. 3/4 (IT) I – Semester (New) (Suppl) Examination, May 2013 Subject : Database Management Systems Time : 3 hours
Max. Marks : 75
Note: Answer all questions from Part-A and answer any FIVE questions from Part-B. PART – A (25 Marks) 1. What are the responsibilities of a database administrator?
3
2. Write about any four different mapping cardinalities.
2
3. How to represent aggregate functions in relational algebra? Give an example.
2
4. What is a join operation and list different types of joins?
3
5. Define an assertion and write how they are created.
3
6. What is the difference betwen 3NF and BCNF?
3
7. State the purpose of indexing.
2
8. Define write-time stamp and read-time stamp of a data item.
2
9. Write Thomas write rule.
2
10. What are the steps followed in dead lock recovery?
3
PART – B (50 Marks) 11.a) Draw and explain each and every component of database architecture. b) What are the functions of a database administrator? 12.a) Discuss in detail E.R. diagram design issues. b) Write the basic structure of an SQL query with an example. 13.a) Explain any five integrity constraints with examples. b) Write about decomposition using functional dependencies. 14.a) Compare static Hashing and dynamic hashing. b) Discuss about view-serializability.
5 5 7 3 5 5 5 5
15. Discuss in detail lock-based protocols with examples.
10
16. Discuss the differed and immediate modification versions of log based recovery schemes.
10
17. Write short notes on : a) Views in SQL b) Generalization and specialization c) Embedded SQL
Describe compilation phases in parallel code generation. 15. Describe ... Vasavai CE B.E IT 3rd Year May 2013 Advanced Computer Architecture.pdf. Vasavai ...
Write LR(0) items for the following grammar (3). E E + n / n. 5. Define shift â reduce conflict and Reduce â reduce conflict. (3). 6. Writ the Attribute grammar from ...
Compare the features of MOTOROLA & ZILOG CPU's. 3. Give the meaning of each of the following 8086 instructions. a) Test BL, AL. b) Out DX, AL ... b) Debugging tools. c) Numeric data processor. ******. Page 2 of 2. Main menu. Displaying Vasavai CE B.E
b) Conflicts in shift-reduce parsing. (3). c) Rules for type checking. (3) ****. Page 1 of 1. Vasavai CE B.E IT 3rd Year Apr 2013 Compiler Construction.pdf. Vasavai ...
What is a resource allocation graph? What is its use? Give an example. 2. 5. What is access matrix? Give an example. 2. 6. What is RAID? Give its structure. 3. 7.
(c) Properties of Laplace transform (3) *****. Page 1 of 1. Vasavai CE B.E IT 3rd Year May 2013 Signals and Systems.pdf. Vasavai CE B.E IT 3rd Year May 2013 ...
a) Spatial data mining b) Text mining. ******. Page 1 of 1. Vasavai CE B.E IT 3rd Year May 2013 Data Warehousing and Data Mining (Elective â I).pdf. Vasavai ...
Distinguish between 'Pessimistic Concurrency Control' and. 'Optimistic Concurrency Control'. (3). 8. List factors that make it difficult to predict the response times ...
... of load runner, win runner 5+5. b) State based or graph based testing strategy. ******. Page 1 of 1. Vasavai CE B.E IT 3rd Year May 2013 Software Testing.pdf.
Vasavai CE B.E IT 3rd Year May 2013 Digital Instrumentation and Control.pdf. Vasavai CE B.E IT 3rd Year May 2013 Digital Instrumentation and Control.pdf.
Page 1 of 1. Vasavai CE B.E CSE 4th Year May 2013 Soft Computing.pdf. Vasavai CE B.E CSE 4th Year May 2013 Soft Computing.pdf. Open. Extract. Open with.
(b) Explain any two collision free LAN protocols. 17. Write short notes on: a) X.25. b) Error control in data link layer. c) Bluetooth architecture. ****. Page 1 of 1. Vasavai CE B.E CSE 2nd Year May 2013 Data Communications.pdf. Vasavai CE B.E CSE 2
Page 1 of 1. Vasavai CE B.E CSE 4th Year May 2013 Distributed Systems.pdf. Vasavai CE B.E CSE 4th Year May 2013 Distributed Systems.pdf. Open. Extract.
Vasavai CE B.E Civil 4th Year May 2013 Structural Engineering Design and Detailing â II.pdf. Vasavai CE B.E Civil 4th Year May 2013 Structural Engineering ...
Vasavai CE B.E Inst 4th Year May 2013 Optoelectronic Instrumentation.pdf. Vasavai CE B.E Inst 4th Year May 2013 Optoelectronic Instrumentation.pdf. Open.
(ii) Butyl rubber (6). 15.(a) What are chemical fuels? Give their classification with examples. (4). (b) Describe the analysis of coal by proximate analysis method. What is its significance? (6). 16.(a) Describe the construction and working of lead-a
Page 1 of 2. Code No. 2342 / N. FACULTY OF ENGINEERING. B.E. 3/4 (Mechanical) I â Semester (New) (Main) Examination, Nov. / Dec. 2012. Subject : Applied Thermodynamics. Time : 3 hours Max. Marks : 75. Note: Answer all questions from PartâA and an
Page 2 of 2. Vasavai CE B.E CSE 3rd Year Apr 2013 Process Control.pdf. Vasavai CE B.E CSE 3rd Year Apr 2013 Process Control.pdf. Open. Extract. Open with.
Define (i) bsfc and (ii) isfc as applied to an Internal Combustion Engine. ... Explain the basic principle of evaporative cooling that is used in cooling towers in.
Page 1 of 1. Code No. 2023. FACULTY OF ENGINEERING & INFORMATICS. B.E. 2/4 (EE/Inst./MP/IT) I â Semester (Suppl) Examination, May 2013. Subject : Environmental Studies. Time : 3 hours Max. Marks : 75. Note: Answer all questions from Part-A. Answer