Chapter Study

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

Comprehensive questions and detailed answers for Unit 5: Creating and Altering Database and Tables SQL (6Hrs.). Perfect for exam preparation and concept clarity.

Questions

Marks

Back to All Chapters

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	Amount
L01	B1	5000
L02	B2	6000

Relation loan

Write a relational algebra expression to find all customer who taken loan from branch "B1".

MediumTHEORY5 marks2022(TU FOHSS Final)

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

MediumTHEORY5 marks2023(TU FOHSS Final)

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

MediumTHEORY5 marks2024(TU FOHSS Final)

Showing 3 questions

Sample Questions

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: 5Chapter: Unit 5: Creating and Altering Database and Tables SQL (6Hrs.)

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

Marks: 5Chapter: Unit 5: Creating and Altering Database and Tables SQL (6Hrs.)

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

Marks: 5Chapter: Unit 5: Creating and Altering Database and Tables SQL (6Hrs.)