Ug Papers
  • Home
  • Universities
  • Share Files
  • File Upload
  • Telegram
Join our Telegram channel and Discuss group. Thanks for the people who uploaded the question papers.

Au Degree 5th Sem Computer Science Paper - V (DBMS -2017) Question Paper

By Venkat | March 21, 2021

Andhra University Degree 5th Semester Computer Science Paper - V (Data Base Management Systems) Question Paper of the year 2017 is available here. (Taken from Test Papers) Check it below.

You may like
  • DBMS - 2019  Paper.
Year - 2017
Andhra University
B.Sc. (CBCS) Degree Examination 
Fifth Semester
NOVEMBER 2017
Computer Science
DATA BASE MANAGEMENT SYSTEMS
Time : 3 Hours       Max: 75 Marks
 [Section - A]   (5 x 5 = 25 Marks)
Answer any five questions.
1. List the drawbacks of file based system.
2. Discuss the objectives of DBMS.
3. What is an ER diagram? List and explain its symbols.
4. Explain CODD rules.
5. Explain about domain relational calculus.
6. Explain about data types in SQL.
7. Explain the concepts of Exception Handling.
8. What are triggers? Explain various types of triggers.
[Section - B]   (5 x 10 = 50 Marks)
Answer the following (One fram each Unit).
Unit I
9. Explain the DBMS approach, advantages, and its classifications.
          Or
10. Explain the terms data, Information, Database, and DBMS. Explain DBMS architecture.
Unit II
11. Explain the procedure of reducing E-R diagram to tables with suitable illustrations.
          Or
12. What are the features of Enhanced Entity Relationship model? Also, explain about generalization and specialization.
Unit III
13. Explain about relational data. model, also discuss about relational algebra, relational algebra operations, their advantages, and limitations. 
          Or
14. Explain about relational calculus and tuple relational calculus.
Unit IV
15. Explain about
(a) commands in SQL
(b) DDL
(c) Aggregate functions.
          Or
16. Explain about
(a) DML
(b) Embedded SQL
(c) Table modification commands.
Unit V
17. Explain the structure of PL/SQL and also the short comings in SQL.
          Or
18. Explain about
(a) Operator precedence in PL/SQL
(b) Iterative control
(c) Steps to create cursors in PL/SQL
Related
  • Au Degree 5th sem Previous Question Papers.
  • Au Degree 3rd sem Previous Question Papers.
  • Au Degree 1st sem Previous Question Papers.
Special Thanks to Yamuna for uploading this Question Paper.
Tags :
AU Degree 5th Sem Au Degree 5th sem 2019 Bsc computer science DBMS Previous Question Papers

Comments

Post a Comment

Links to non-related sites will be removed.

UG Papers App

Download our Official UG Papers app from PlayStore.

Get it on Google Play

Labels

  • Andhra University
  • AU Degree 1st Sem
  • AU Degree 2nd Sem
  • AU Degree 3rd Sem
  • AU Degree 4th Sem
  • AU Degree 5th Sem
  • AU Degree 6th Sem
  • Entrance Exams
  • Previous Question Papers
  • Universities

Featured Post

Andhra University | AU Old Question Papers

By Venkat |September 11, 2019

Andhra University was established in 1926 and C.R.Reddy is the founder of Andhra University. It offers various Under Graduate, Post Graduate and…

Popular Posts

AU Degree 1st Sem Previous Question Papers | Au 1st sem old Question Papers

Andhra University Degree 1st Semester Previous Year Question Papers of the last few years are avai…

AU Degree 3rd sem Previous Question Papers | AU 3rd sem Old Papers

Andhra University Degree 3rd Semester Previous Year Question Papers are collected. The links to A…

AU Degree 5th Sem Previous Question Papers | AU 5th Sem old Question Papers

Some of the Andhra University 5th Semester Degree Question Papers are Collected by us. The Links …

AU Degree 3rd Sem English Question Papers

Andhra University Degree 3rd sem English Question papers are below by year wise. English - 201…

Au Degree 1st Sem Maths (2019) Question Paper

Au Degree 1st Sem Maths (2019) Question Paper

Andhra University Degree 1st Semester Mathemitics Question Paper of the year 2019 is available her…

AU Degree 3rd Sem Maths Question Papers

Andhra University Degree 3rd Sem Mathematics Question Papers by year wise are below. Year - 2018…

Au Degree 1st Sem Human Values & Professional Ethics (2019) Question Paper

Au Degree 1st Sem Human Values & Professional Ethics (2019) Question Paper

Andhra University Degree 1st Semester Human Values and Professional Ethics Question Paper of the y…

AU Degree 6th Sem Previous Question Papers | AU 6th Sem Old Question Papers

Andhra University 6th Semester Question Papers of the last few years are available here for noth…

Au Degree 3rd Sem Maths (2019) Question Paper

Au Degree 3rd Sem Maths (2019) Question Paper

Andhra University Degree 3rd Semester Maths Question Paper of the year 2019 is available below. Che…

Sri Krishnadevaraya University | SKU Previous Question Papers

Sri Krishnadevaraya University (SKU) was  established in the year 1981 in Anantapur. It was a Publi…

  • Contact Us
  • Privacy Policy
  • Terms of Use
  • Disclaimer
Copyright © Ugpapers