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 2nd Sem Previous Question Papers | Au 2nd Sem old Question Papers

Andhra University Degree 2nd Semester Previous year Question Papers of groups B.Sc and B.Com th…

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

Andhra University Degree 4th Semester Previous Year Question Papers of the last few years of the …

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 4th Sem Maths (2020) Question Paper

Au Degree 4th Sem Maths (2020) Question Paper

This paper is removed due to an error... You may like Maths - 2019 paper Maths - 2018 pape…

Au 2nd Sem Maths Question Papers

Andhra University Degree 2nd Semester Mathematics Question Papers of the last few years are avail…

Au Degree 2nd Sem Maths (2020) Question Paper

Au Degree 2nd Sem Maths (2020) Question Paper

Andhra University Degree 2nd Semester Mathematics Question Paper of the year 2020 is available her…

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 2nd Sem English (2019) Question Paper

Andhra University Degree 2nd Semester English Question Paper of the year 2019 is available belo…

Au Degree 4th Sem Maths (2019) Question Paper

Andhra University Degree 4th Semester Mathematics Question Paper of the year 2019 is available b…

Au Degree 2nd Sem ICT (2021) Question Paper

Andhra Univesity Degree 2nd Semester Life Skills Course, Information and Communication Technology…

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