1.      Assume a schema of

EMP(Id,

Name, DeptId), Dept(Id, Name).

If there are 10 records in the Emp table and 5 records in the Dept

table, how many rows will be

displayed in the result of the following SQL query?

SELECT * FROM Emp, Dept

What

are the different types of outer joins? Choose all correct options.

Table

Category has a field 'Id' (integer data type). Which of the following queries

returns the same results as the  query

below?

SELECT * FROM Category WHERE Id BETWEEN 2 AND 4

Consider the following

table

STUDENTS(student_code, first_name, last_name,

email,

phone_no, date_of_birth, honours_subject, percentage_of_marks).

Which of the following

query

When you normalize a relation

by breaking it into two smaller relations, what must you do to maintain data

integrity?