DBMS

Database Management Systems

Master database concepts, ER modeling, relational algebra, SQL, normalization, transaction management, and concurrency control.

2,584MCQs

easy

854 questions

medium

1393 questions

hard

340 questions

Normalization

Transactions

SQL Commands

Introduction to Databases

Database System Concepts and Architecture

Data Modeling using ER Model

Enhanced ER (EER) Model

Relationship Types, Relationship Sets, Roles, and Structural Constraints

ER Diagrams, Naming Conventions, and Design Issues

Relational Data Model and Relational Database Constraints

Relational Algebra

SQL: Data Definition and Data Types

SQL Queries and Constraints

Relational Calculus: Tuple and Domain

Functional Dependencies and Normalization (1NF, 2NF, 3NF)

Normalization (BCNF, 4NF, 5NF) and Database Design

Query Processing and Optimization

Big Data and NoSQL Databases

Data Mining and Data Warehousing

Which normal form removes transitive dependencies?

A.1NF

B.2NF

C.3NF

D.BCNF

ACID properties ensure:

A.Data security

B.Transaction reliability

C.Fast queries

D.Data compression

Which SQL command is used to remove a table from database?

A.DELETE

B.REMOVE

C.DROP

D.TRUNCATE