Pages

Thursday, 3 October 2024

DBMS PRACTICE QUESTIONS 2

DBMS PRACTICE QUESTIONS 2

1. Explain all types of JOINS in relational algebra with example. (UNIT 3)

2. Explain SET OEPRATIONS in relational algebra with example. (UNIT 3)

3. How can we measure cost of Join query? Explain using example. (UNIT 5)

4. Explain query optimization process. (UNIT 5)


PRACTICAL 4 TABLE DATA

 CREATE TABLE STUDENTS ( StuID INT, FirstName VARCHAR(25), LastName VARCHAR(25),    Website VARCHAR(50), City VARCHAR(25), Division VARCHAR(...