FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE
📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download OU B.Sc Computer Science 4th Sem Data Base Management System Important Questions

Download OU (Osmania University) B.Sc Computer Science 4th Sem Data Base Management System Important Question Bank For 2021 Exam

This post was last modified on 23 January 2021

Tags:OU BSc Computer Science2021Important QuestionsOsmania UniversityDBMSData Base Management System4th SemPDFDownloadfrdA230121A2049318
Download Document
Download Document
OU BSc Computer Science 2021 Important Question Bank || Osmania University (Important Questions)


FirstRanker.com
Firstranker's choice
FirstRanker.com

--- Content provided by⁠ FirstRanker.com ---

Subject Title: Data Base Management System
Year: |l Semester: V
Prepared by: K Madhavi
Updated on: 23-03-

Unit - I:

--- Content provided by​ FirstRanker.com ---

  1. What is Traditional file based system and Database approach?
  2. What are the advantages and disadvantages of DBMS?
  3. Explain Three-level ANSI-SPARC Architecture.
  4. What are the functions of DBMS?
  5. Explain the components of DBMS.

    6. --- Content provided by FirstRanker.com ---

  6. Explain in detail about Relational Algebra(Unary, set,join operators)
  7. Explain Different Data Models?
  8. List some aggregate functions in SQL
  9. Users of DBMS.
  10. Integrity constraints.

    11. --- Content provided by⁠ FirstRanker.com ---

  11. Explain in detail about SQL Data types?
  12. How to create, Alter a table explain with example
  13. What is a View? Explain Different types of views?
  14. How to give Privileges to users? Explain.

Unit - II:

--- Content provided by FirstRanker.com ---

  1. Explain Control Structure in PL/SQL?
  2. Explain Cursors in PL/SQL?
  3. Explain Packages in PL/SQL?
  4. Explain Procedures in PL/SQL?
  5. Explain Functions in PL/SQL?

    6. --- Content provided by‍ FirstRanker.com ---

  6. Explain Triggers in PL/SQL?
  7. What are sub queries and nested queries?
  8. Transactions in SQL(TCL)

Page 1 of 2

FirstRanker.com

--- Content provided by‌ FirstRanker.com ---

FirstRanker.com
Firstranker's choice

Unit - III:

  1. Explain in detail about different types of entities and attributes.
  2. What are the problems with ER model?

    3. --- Content provided by⁠ FirstRanker.com ---

  3. What are the basic constructs of ER model?
  4. What is an EER model?
  5. Explain functional dependency.
  6. Explain about different Normal Forms.
  7. Why do we need normalization?

    8. --- Content provided by‍ FirstRanker.com ---

Unit - IV:

  1. What are the different Concurrent problems? Explain with example.
  2. What is a lock? Types of locks in DBMS
  3. How data recovery works?
  4. What are computer based controls?

    5. --- Content provided by⁠ FirstRanker.com ---

  5. Write about RAID tools.

Page 2 of 2

FirstRanker.com


--- Content provided by‌ FirstRanker.com ---


This download link is referred from the post: OU BSc Computer Science 2021 Important Question Bank || Osmania University (Important Questions)

This post was last modified on 23 January 2021