BCA Semester 4 – Database Management System – Unit 5: Creating and Altering Database and Tables SQL (6Hrs.)

Question 1

What is DDL and DML queries?Consider the following relation. Consider the following relation. |Customer name | Loan number | |---|---| X |L01 | Y | L02| Relation borrower |Loan number |Branch name |

Marks: 5

Year: 2022 Final TU FOHSS

Unit: DBMS – DDL, DML & Relational Algebra --- 1. DDL and DML Queries 1.1 DDL (Data Definition Language): - Purpose: Defines or modifies the structure of database objects like tables, indexes, sc

Question 2

What are different SQL constraints to specify the rules for the data in the database? Explain.

Marks: 5

Year: 2023 Final TU FOHSS

Unit: DBMS – SQL Constraints --- 1. Definition SQL Constraints are rules applied to columns or tables to restrict the type of data that can be stored. - They ensure data integrity, accuracy, and

Question 3

Why integrity constraints are used in databases? Explain different types of integrity constraints with examples.

Marks: 5

Year: 2024 Final TU FOHSS

Integrity Constraints in Databases --- Why Integrity Constraints are Used Integrity constraints ensure accuracy, consistency, and reliability of data in a database. They prevent invalid or inconsiste

Loan number	Branch name	Amount
L01	B1	5000
L02	B2	6000