IV B.Tech I Semester Supplementary Examinations, April/May 2005 DATA BASE MANAGEMENT SYSTEMS (Electrical & Electronic Engineering) Time: 3 hours Max Marks: 80 Answer any FIVE Questions All Questions carry equal marks ????? 1. (a) Define the following with suitable examples: i. ii. iii. iv.
Relation Cardinality of a relation Super-key Candidate key.
(b) Explain the structure of relational model. 2. (a) What is the role of SQL in a database architecture. (b) What are the notations used in SQL commands. 3. (a) Describe three popular file organization techniques on disks and compare them. (b) Discuss the process of disk initialization. 4. (a) Consider the following SQL query for a bank database Select T.branch-name From branch T, branch S where T.Assets > S.assets and S.branch-city=”HYDERABAD” Write an efficient relational algebra expression that is equivalent to the query. (b) Define query optimization and at what point during query processing does optimization occur? 5. (a) Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done. (b) What is meant by query execution plan? Explain its significance. 6. (a) What is Normalization? Discuss the first, second and third normal forms with examples. (b) Explain with an example why 4NF is more desirable normal form than BCNF. 7. (a) Discuss the different types of transaction failures. (b) Which component of DBMS is responsible for concurrency control? How is this feature used to resolve conflicts? 8. Answer the following briefly: (a) How is check pointing done in ARIES? 1 of 2
NR
Code No: NR410210
(b) Can a second end check point record be encountered during analysis phase? (c) Why is the use of CLRS important for the use of UNDO actions that are not the physical inverse of the original update? ?????
NR410210 IV B.Tech I Semester Supplementary Examinations, April ...
(b) Can a second end check point record be encountered during analysis phase? (c) Why is the use of CLRS important for the use of UNDO actions that are not.
(a) What is Redundancy? Explain the different types of Redundancy operation with LCU. (b) explain the operation of: i. Operator interface. ii. Engineer interface.
(b) Briefly explain the shift instructions also give the examples. 4. Write a procedure SOLUTION that will use the arithmetic operators procedures to evaluate the ...
let us make a rough estimate of its role. For this assume isothermal operations in a 2.5-cm ID tubular reactor, using a Reynolds number of 10 000 for flowing fluid. The cracking reaction is approximately first order. If calculations show that 99% dec
With an example explain the distributed transparency for read-only application. 2. ... Discuss the catalog management in distributed databases. 6. What is the ...
(b) Sketch the bevel protractor and explain the various elements of it. 3. (a) Explain the following terms with respect to surface measurements. i. Lay ii. CLA iii.
(a) List and explain the metrics for the analysis model. (b) Describe the metrics for ... (a) Describe the object oriented design landscape. (b) What are design ...
What is a hot blast cupola? With a neat sketch describe the construction and operation of hot blast cupola. Explain the reactions those take place in the above.
iv. Minimum sampling rate v. aperture time required for the AD converter vi. Dynamic range of conversion in dB. 8. (a) Explain in detail abut analog multiplexing.
What are the modes of operation of a Hopfield network? Explain the algorithm for storage of information in a Hopfield network. Similarly explain the recall algo-.
alternator affects the performance of the differential protection of the three phase · stator. b) Describe how protection is provided in large turbo alternators against ...
(a) Explain tree testing of prosthetic heart valve using a pulse duplicator. (b) Discuss the ... Explain with diagram, the types of exchangers used in artificial kidney.
(b) What is pretreatment required for sea water to be treated by electro dialysis? (c) Explain the conventional methods that could be employed for the treatment.
7.a) Explain the working principle of a simple accelerometer and vibrometer. b) Define the term gauge factor of strain gauge and strain gauge Rosetle. How are.
Find the loss of stress due to creep of concrete. (b) A concrete beam is prestressed by a cable carrying an initial prestressing force of 335kN. The cross sectional ...
NR. IV B.Tech I Semester Supplementary Examinations, November 2005 ... NR size is smaller than the fiber core, and the small gap between the source and.
RELIABILITY & SAFETY ENGINEERING · (Electronics & Control Engineering) ... (a) Explain the following terms in connection with reliability evaluation. [2+3].
NR. IV B.Tech I Semester Supplementary Examinations, November 2005 ... 3. Analyse the following frame using stiffness method. EI constant. (figure 3) [16].
What do you understand by Non-destructive testing techniques? List various tech- · nique of NDT and explain any three of them · [16]. 8. Write short notes on the ...
