Chapter-1 Database Fundamentals
1. What is a DBMS? Explain its features and advantages over traditional file systems. Give examples of commonly used DBMS software.
Answer....
2. Define the terms: Data, Database, DBMS, and RDBMS. How is an RDBMS different from a DBMS?
Answer....
3. What are constraints in DBMS? Explain different types of constraints (NOT NULL, UNIQUE, CHECK, DEFAULT, PRIMARY KEY, FOREIGN KEY) with examples.
Answer....
4. What is database transaction? Explain different state of transaction.
Answer....
5. What is transaction? Write down properties of transaction.
Answer....
6. What is meant by TCL? Explain about different TCL commands with proper example.
Answer....
7. What is the purpose of using functions in SQL? Explain the use of aggregate functions like SUM(), AVG(), MAX(), MIN(), and COUNT() with example.
Answer....
Chapter-2 Introduction to MySQL
1. What are data types in MySQL? Explain any five commonly used SQL data types with examples.
Answer....
2. Explain how to insert, update, and delete records in a MySQL table using INSERT, UPDATE, and DELETE commands. Provide example commands for each operation on a table named EMPLOYEES.
Answer....
3. What is SQL? Explain its importance in managing databases. Describe the different types of SQL commands (DDL, DML, DCL, TCL) with suitable examples for each.
Answer....
4. What is the use of function in MySQL? Explain String function used in MySQL.
Answer....
5. What is the use of function in MySQL? Explain Math function used in MySQL.
Answer....
6. What is the use of function in MySQL? Explain Date and Time function used in MySQL.
Answer....
