Subject Title: RDBMS Prepared by: Kishore Bezawada
Year: III Semester: VI Updated on: 22-03-
--- Content provided by FirstRanker.com ---
SHORT ANSWER QUESTIONS:
Unit - I:
- What is RDBMS?
- Disadvantages of File-Oriented System
- Primary key
- Foreign key
- E-R Diagram
- Degree of Relationship
- Cardinality
- Recursive Relationship
- Candidate key
- Super key
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Unit - II:
- Database Integrity
- Functional Dependency
- 1NF & 2NF
- 3NF Vs BCNF
- 4NF & 5NF
- Indexing
- Tree
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Unit - III:
- Data types in SQL
- Operators in SQL
- DDL Commands
- DML Commands (Data Manipulations)
- TCL Commands
- DCL Commands
- Dual Table
- Nested Query
- Force View
- Indexes
- Synonyms
- Sequences
- Joins
- Aggregate functions
- Check constraint
- Group by clause
- Order by clause
- Having clause
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Unit - IV:
--- Content provided by FirstRanker.com ---
- Concurrency control
- Schedule
- Locking
- Deadlock
- Database Integrity
- Database Security
- Database Recovery
--- Content provided by FirstRanker.com ---
Unit - V:
- DDBMS
- Data Fragmentation
- Data Replication
- Data Distribution
- Client-Server Architecture
--- Content provided by FirstRanker.com ---
LONG ANSWER QUESTIONS:
--- Content provided by FirstRanker.com ---
Unit - I:
- What are the advantages of DBMS over File-based system?
- Explain the Functions & Role of DBA.
- Explain different Data Models.
- Explain Relational Operators (Relational Algebra) with examples.
- Explain about E-R Model in detail. (E-R Diagram)
- Explain the process of creating an E-R diagram with suitable example.
- Explain the process to convert an E-R diagram into Relational Database.
--- Content provided by FirstRanker.com ---
Unit - II:
- Explain about Database Integrity & Integrity Constraints (Keys).
- What is Normalisation? Explain different Normal Forms with suitable examples.
- Explain the Physical database design issues.
- Explain about different types of File Organization.
- What is an Indexing? Write about different types of-Indexes.
- Explain about Tree Structure.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Unit - III:
- Explain about different SQL Commands (SQL Statements).
- Explain different clauses in SQL with suitable examples.
- Explain about DDL Statements in SQL.
- Explain about DML Statements in SQL.
- Write about Integrity constraints in SQL.
- Write about SQL Functions with suitable examples. (Aggregate & Text Functions)
- Write about Nested Queries with suitable example.
- What are Joins? Explain about different joins in SQL with suitable examples.
- What is a View? Explain how to create views in SQL with examples.
- Write about SQL Table commands. (Create Table, Alter Table and Drop Table)
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Unit - IV:
- What is a Transaction? Explain ACID Properties of Transaction.
- What is a Lock? Explain different Locking Techniques.
- Explain Two-phase Locking protocol with example.
- What is Deadlock? Explain deadlock prevention techniques.
- Explain Database Recovery Techniques.
- Explain about Concurrency control.
--- Content provided by FirstRanker.com ---
Unit - V:
--- Content provided by FirstRanker.com ---
- Explain the need for Distributed Database Systems.
- Explain the Architecture of Distributed Database Management System (DDBMS).
- Explain the advantages of DDBMS.
- Write about Data Replication in DDBMS in detail.
- Write about Data Fragmentation in detail.
- Explain about Client-Server Architecture.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
This download link is referred from the post: OU B.Com 2021 Important Question Bank || Osmania University (Important Questions)