UNIT WISE IMPORTANT QUESTIONS FOR DBMS, SQL, PL/SQL - (OSMANIA UNIVERSITY, JNTU, KAKATIYA UNIVERSITY, NAGARJUNA UNIVERSITY,ANDHRA UNIVERSITY)

UNIT WISE IMPORTANT QUESTIONS FOR DBMS 
OSMANIA UNIVERSITY, NAGARJUNA UNIVERSITY, TELANGANA UNIVERSITY, ANDHRA UNIVERSITY, JNTU

UNIT - I

Explain Database, DBMS, Metadata.
Explain why DB design is important.
What are DB Systems?
Explain different types of Databases.
What are the advantages of DBMS?
List our Codd's Relational Database rules.
Distinguish between simple and composite attributes.
Explain DB System environment.
Explain DB basic Building Blocks.
Write about tables and their characteristics.
What is Logical Independence?
List the limitations of DBMS.
Discuss about Historical roots of Database.
What are the problems with File system and Data Management?
Explain about Data Redundancy.
List and explain the functions and capabilities of DBMS.
Describe about Data Modeling and Data Models.
Explain in detail why Database is important?
What are Business Rules? Discuss in detail.
Explain the evolution of Data models.
Explain the disadvantages of Data Models.
Explain in brief about the degree of Data Abstraction.
Write about the logical view of Data in Relation Database Model.
Define a Relation and explain the characteristics of Relational table.
What is a Relationship? Discuss about relationships within the Relational Database.
Define the terms Data Dictionary and System Catalog.
What is an Index?
Discuss in detail about integrity rule in Relational Data Model.
Explain in detail the components of DB system environment.
Explain with example the Relation Set Operators.

UNIT - II

What is Entity, Entity Type, Entity Instance and Domain?
What is a Relationship, Relationship Type and Relationship Instance?
Define Data Redundancy.
What is Denormalization?
Define ER Model.
Define Functional Dependency.
What is an Entity? Explain different type of Entities.
What is an Attribute? Explain different types of Attributes.
Explain Recursive Relationship with example.
Explain Degree of Relationship.
What is Entity Relationship model? Explain with example.
What are the basic constructs of ER model?
Discuss about the challenges of DB Design conflicting goals.
Explain with example how to develop an ER Diagram.
What is Normalization? Explain about DB Tables and Normalization.
Explain 1NF, 2NF, 3NF.
Explain BCNF and 4Nf.
What is a Surrogate Key? What are its advantages and disadvantages?
What is EER Model and how to represent Supertype and Subtype?
Explain Inheritance and Sub type discriminator with examples.
Describe in brief about Specialization and Generalization.
What is entity Clustering? Explain the use of Entity Clusters in ERD.
What is Primary Key? Explain some desirable Primary Key characteristics/guidelines.
Explain the usage of Composite Primary key with an example.
Explain with example the Disadvantage of storing Derived Attributes.

UNIT - III

(SQL, PL/SQL)

Explain Select Query in SQL.
Explain how to create table with syntax in SQL.
What are Views and Indexes?
Explain Cursor, Store Procedure.
Explain various Data types used in SQL and Pl/SQL.
What is the syntax to create sequences in Oracle?
Explain column constraints in SQL.
List and explain various DML, DDL commands in SQL.
List out some important SQL functions.
Explain Arithmetic functions.
What is a Join? Discuss about various joins used in SQL.
Explain Order by, Group by and Having Clauses with example.
List and explain SQL Relational Set Operators.
List and explain SQL Logical Operators.
Explain Special Operators.
Explain in brief about Subqueries and Correlated queries.
Discuss in brief about Procedural SQL.
What is SDLC? Explain various steps used in SDLS.
What is DBLC? What are the steps involved in DBLC?
Discuss in detail about the strategies of DB design.
What is a Trigger?
Explain various types of Cursors.
What is Exceptional Handling with example?

UNIT - IV

What is Concurrency Control?
Write about distributes Transparency.
Write a short note on Transction, Transaction Log, data fragmentation, Deadlock, Scheduler.
Explain DDBMS and DDBMS Components.
Explain characteristics, advantages and disadvantages of DDBMs.
Write about Transaction ACID Rule/ Transaction Properties.
Explain different types of Locks. Explain Binary Lock in brief.
Explain Commit and Rollback Commands.
Explain Concurrency Control with Locking methods.
Describe in detail about Time - stamp based Concurrency Control Method.
Describe in details about Optimistic Concurrency Method.
What is Data Replication? Explain 3 replicated strategies.
Explain Transaction Transparency.
Explain in detail Two Phase Commit Protocol.
Explain performance Transparency and Query Optimization.
Explain how to ensure Serializability using Two - Phase Locking.
Explain in detail the need for Data Analysis

UNIT - V

Define the terms:
           MOLAP, ROLAP, Data mining, Data Warehouse, Slice and Dice Technique, Decision Support System.
List out the components of Stat Schema.
List out the benefits of Decision Support System.
List out the advantages of Client, Server Application.
Define Data Administrator facts.
Describe 12 rules to define Data Warehouse.
Explain in detail the need for Data Analysis.
Explain Decision Support System.
What are main characteristics of Data warehouse?
Explain Characteristics of OLAP Architecture.
Explain ROLAP and why you would recommend its use in the relational DB Environment.
Discuss the different phases in Data-mining Process.
Write in detail about SQL extension for OLAP.
Explain the various types of Data Dictionary. Explain their features.
Explain with a diagram the tools of business Intelligence.
Explain the components of Business Intelligence with a Digram.