dbase mgt - Question Paper Database Management Systems...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Question Paper Database Management Systems (MC141) : January 2009 Section A : Basic Concepts (30 Marks) This section consists of questions with serial number 1 - 30. Answer all questions. Each question carries one mark. Maximum time for answering Section A is 30 Minutes. 1. Which of the following SQL statements will not display the duplicates of branch_name in the loan table? (a) select distinct branch_name from loan; (b) select branch_name from loan; (c) select distinct branch_name; (d) select branch_name; select branch_name from distinct loan;. 2. In ER diagram, which of the following represents the derived attributes? (a) Double rectangles (b) Double ellipses (c) Lines (d) Dashed lines Double lines. 3. Which of the following is/are the part(s) of a trigger? I. Event (activates the trigger). II. Condition (tests whether the trigger should run). III. Action (what happens if the trigger runs). (a) Only (I) above (b) Only (II) above (c) Both (I) and (II) above (d) Both (II) and (III) above All (I), (II) and (III) above. 4. Which of the following is a program module that provides interface between the low level data stored in the data base and the application programs and queries submitted to the system? (a) File Manager (b) Device Manager (c) Storage Manager (d) Transaction Manager Query Manager. 5. Which of the following statements is/are true about the levels of abstraction? I. Physical level describes how a record is stored. II. Logical level hides the information for security purposes. III. View level describes data stored in a database and the relationships among the data. (a) Only (I) above (b) Only (II) above (c) Both (I) and (II) above (d) Both (I) and (III) above Both (II) and (III) above.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6. Which of the following statements is/are true? I. Primary key is an attribute that uniquely identifies each row in a relation. II. Foreign key is an attribute in a relation of a database that serves as the primary key of another relation in the same database. III. Composite key is a primary key that consists of more than one attribute. (a) Only (I) above (b) Only (II) above (c) Both (I) and (II) above (d) Both (II) and (III) above All (I), (II) and (III) above. 7. Relational algebra is an expression based on relational operators and relational operands. Which of the following are the operations in relational algebra? (a) Select, Project, Rename, Cartesian product, Union, Set-difference (b) Select, Cartesian product, Project, Union, Where, Division (c) Cartesian product, Project, Select, From, Set-difference, Natural join (d) Union, Project, Select, Where, Set-difference, Assignment Set-difference, Project, Select, From, Cartesian product, Intersect. 8.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/23/2010 for the course IT 1 taught by Professor Amir during the Spring '10 term at Baton Rouge CC.

Page1 / 14

dbase mgt - Question Paper Database Management Systems...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online