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

  • AU Degree 1st Sem
  • AU Degree 2nd Sem
  • AU Degree 3rd Sem
  • AU Degree 4th Sem
  • AU Degree 5th Sem
  • AU Degree 6th Sem
  • Andhra University
  • 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…

Sri Krishnadevaraya University | SKU Previous Question Papers

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

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 2nd Sem Telugu Question Papers

Andhra University Degree 2nd Semester Telugu Question Papers of the last few years are below by y…

Dr. B.R Ambedkar University | BRAU Previous Question Papers

Ambedkar University (BRAU) was  established in the year 2008 in Srikakulam. It was a State Universi…

AU Degree 2nd Sem Fundamentals of Accounting Question Paper

Andhra University Degree 2nd Semester Fundamentals of Accounting Question Papers of the last few…

Rayalaseema University | RU Previous Question Papers

Rayalaseema University (RU) was  established in the year 2008 in Kurnool. It was a State Universit…

Au Degree 2nd Sem Chemistry (2019) Question Paper

Andhra University Degree 2nd Semester Chemistry Question Paper of the year 2019 is available her…

Au Degree 2nd Sem Physics (2021) Question Paper

Andhra Univesity Degree 2nd Semester Physics Question Paper of the year 2021 is below. Have a look …

Au Degree 2nd Sem Computer (2019) Question Paper

Andhra University Degree 2nd Semester Computer Science Question Paper of the year 2019 is availa…

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