This document contains instructions and questions for an exam on relational database management systems (RDBMS). It has two sections - Section A contains 15 short answer questions, and Section B contains 9 longer answer questions. The document provides details on the exam such as the total number of questions, number of pages, course name, date, duration, and maximum marks. It also lists the instructions for candidates regarding which sections are compulsory and how many questions to attempt from each section.
This document contains instructions and questions for an exam on relational database management systems (RDBMS). It has two sections - Section A contains 15 short answer questions, and Section B contains 9 longer answer questions. The document provides details on the exam such as the total number of questions, number of pages, course name, date, duration, and maximum marks. It also lists the instructions for candidates regarding which sections are compulsory and how many questions to attempt from each section.
This document contains instructions and questions for an exam on relational database management systems (RDBMS). It has two sections - Section A contains 15 short answer questions, and Section B contains 9 longer answer questions. The document provides details on the exam such as the total number of questions, number of pages, course name, date, duration, and maximum marks. It also lists the instructions for candidates regarding which sections are compulsory and how many questions to attempt from each section.
This document contains instructions and questions for an exam on relational database management systems (RDBMS). It has two sections - Section A contains 15 short answer questions, and Section B contains 9 longer answer questions. The document provides details on the exam such as the total number of questions, number of pages, course name, date, duration, and maximum marks. It also lists the instructions for candidates regarding which sections are compulsory and how many questions to attempt from each section.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 2
Roll No. ......................
Total No. of Questions : 13] [Total No. of Pages : 02
Instruction to Candidates: 1) Section - A is compulsory. 2) Attempt any Nine questions from Section - B.
Section - A <
Q1) (15 x 2 = 30)
a) Explain 3-schema architecture. b) Explain the concept of data dependency. c) What is the major characteristic of distributed database? d) How network model is different from hierarchical model? e) Student entity has roll no, name & address attributes. Student can be hosteller or day scholar. Hosteller has to pay mess-bill. Draw an entity relationship model for the above statement. f) State functional dependency. g) Give an example of multivalued dependency. h) Give an example of relation which is in 2NF but not in 3NF. i) State BCNF with example. j) What do you mean by degree of a relation? k) What is distributed processing? Does oracle work in this environment. l) Explain group by clause. m) How you will find that whether a given command is of SQL or SQL * plus. n) Give the usage of any two Oracle Functions. o) Explain column command of Oracle.
P.T.O. Section - B (9 x 5 = 45) Q2) What is the benefit of DBMS? Explain the architecture of DBMS .
Q3) Compare relational database with object relational database.
Q4) Compare network model with relational data model.
Q5) What are the design issues of distributed databases? Explain.
Q6) How relations are organized logically & physically? Explain.
Q7) State & Explain with example 1NF and 2NF.
Q8) State & Explain with example 3NF and BCNF.
Q9) State & Explain with example 4NF.
Q10) How client connects to Oracle server? Explain step by step.
Q11) Give an example of how co-related subquery works in SQL.
