About this question paper
This is the previous year question paper of IT RDBMS and Sql (MSc) (Semester 1) conducted by Atal Bihari Vajpayee Vishwavidyalaya, Bilaspur (Dec 2020). Practising it helps you understand the exam pattern, important questions and marks distribution of your university.
How to prepare with this paper
- पूरा पेपर एक बार पढ़ें और जो प्रश्न आपको आते हैं उन पर निशान लगाएँ।
- देखें कि हर प्रश्न सिलेबस की किस इकाई से है — जो इकाइयाँ बार-बार आती हैं, वही सबसे ज़रूरी हैं।
- बिना नोट्स देखे 3 घंटे में पेपर हल करें, फिर अपनी किताब से उत्तर मिलाएँ।
- इसी विषय के दूसरे वर्षों के पेपर भी डाउनलोड करें और दोहराए गए प्रश्न ढूँढें।
Questions in this paper (text version)
यह टेक्स्ट मूल PDF से लिया गया है ताकि आप इसे जल्दी पढ़ और खोज सकें। सूत्र, चित्र और हिंदी टेक्स्ट सही न दिखें तो ऊपर दी गई PDF देखें।
Compulsory/Optional
Time: Three hours Maximum Marks-80
Note: Answer from both the section as directed.
SECTION.A
(a) Define data independence. List its type.
(b) List any four DDL commands.
(c) What do you mean by cross product?
(e) Define candidate key.
0) Define Referential integrity.
SECTION.B
2. Answer the following questions: 2X5
(a) What do you mean by data dictionary?
(b) Define key and its concept.
(c) Differentiate group by and order by clause in SQL.
Answer all questions: 72X5
3. Write notes on.
l. Client/Serverdatabase
lll. object relational database
(a) What do you mean by data model? Explain their types in brief.
(b) Differentiate file oriented and database oriented approach.
Unit-ll
4. (a) Explain four different types of SET operators with suitable example.
student and books.
5. Consider Following Schema
(ENO, ENAME, Department, DesiBnation, DOJ, Salary, Dept-Location)
Solve the following query:
(i) List the employees having Designation as "Manager'' and .Dept-Location as "Mumbai"
(iv) List Ename of employees havin8 znd alphabet in the name as "A".
(b) Define languages or tQt;ld describe the use of Grant and REVOKE privilege with the help of example.
(a) What do mean by normalization? Differentiate 3'd normalform and Boyce code normal form with
suitable example
Unit-lV
6. (a) Give block-structure of PL/SQL and explain main components.
(a) Write PVSQL program to display the Factorial of any number.
Unit-V
7. (a) What are the steps to involve in query processing. Explain how you would estimate the cost of query
processing.
(b) Explain the concept of security and authorization in SQL.
Write notes on.
(iD Database lntegrity