Database Management Systems (Laboratory)

1.1.1EasyCODE

DDL - CREATE

Question Answer

1.1.2EasyCODE

DDL - ALTER

Question Answer

1.1.3EasyCODE

DDL - DROP

Question Answer

1.1.4EasyCODE

DDL - TRUNCATE

Question Answer

2.1.1EasyCODE

DML - INSERT

Question Answer

2.1.2EasyCODE

DML - UPDATE

Question Answer

2.1.3EasyCODE

DML - DELETE

Question Answer

3.1.1EasyCODE

DDL - DROP Column

Question Answer

3.1.2EasyCODE

ANY

Question Answer

3.1.3EasyCODE

ALL

Question Answer

3.1.4EasyCODE

IN

Question Answer

3.1.5EasyCODE

EXISTS

Question Answer

3.1.6EasyCODE

NOT EXISTS

Question Answer

3.1.7MediumCODE

Set Operations - UNION

Question Answer

3.1.8MediumCODE

Set Operations - INTERSECT

Question Answer

3.1.9MediumCODE

Simple Queries - Group By and Having Clause

Question Answer

3.1.10MediumCODE

Left Outer Join

Question Answer

3.1.11MediumCODE

Right Outer Join

Question Answer

3.1.12HardCODE

Self Join

Question Answer

4.1.1EasyCODE

SQL Basic Operations

Question Answer

4.1.2MediumCODE

Full Outer Join - Police Department

Question Answer

4.1.3EasyCODE

Natural Join

Question Answer

4.1.4EasyCODE

Cross Join - Satellite Prevention

Question Answer

4.1.5MediumCODE

Nested Queries - 1

Question Answer

4.1.6MediumCODE

Nested Queries - 2

Question Answer

5.1.1HardCODE

Swap Two Numbers

Question Answer

5.1.2HardCODE

Largest of Three Numbers

Question Answer

5.1.3HardCODE

Average of Subjects

Question Answer

5.1.4MediumCODE

Sum of Digits

Question Answer

5.1.5HardCODE

Reversing a Number

Question Answer

5.1.6HardCODE

Prime Number

Question Answer

5.1.7HardCODE

Fact Function to find Factorial

Question Answer

6.1.1HardCODE

IN, OUT AND INOUT Parameters

Question Answer

6.1.2HardCODE

Stored Procedure - Retrieving Most Recent Order Details for a Customer

Question Answer

6.1.3HardCODE

Stored Procedures - Calculating Total Ordered Quantity for a Given Product

Question Answer

6.1.4HardCODE

Stored Procedure - Retrieving Top 10 Products Based on Highest Unit Price

Question Answer

7.1.1HardCODE

Views - Display Products

Question Answer

7.1.2MediumCODE

Views - Display Products by Category

Question Answer

7.1.3HardCODE

Views - 3

Question Answer

8.1.1HardCODE

Trigger after INSERT

Question Answer

8.1.2HardCODE

Trigger after DELETE

Question Answer

8.1.3HardCODE

Trigger after UPDATE

Question Answer