Database

1

Write a query to find employees whose salary is equal to the salary of at least one employee in department of id 10.

Select one:

A.

B.

C.

D.

2. Which SQL statement would you use to remove the row for Book_ID=15 from Book_Information table?

Select one:

A.TRUNCATE TABLE Book_Information WHERE Book_ID = 15;

B.DELETE FROM Book_Information WHERE Book_ID = 15;

C.DROP Book_Information WHERE Book_ID = 15;

D.DELETE Book_Information WHERE Book_ID = 15;

3.

Which of the following SQL commands will create a new record with empNo = 001?

Relation schema: Employee (empNo, empName, empAddr, DOB)

I. INSERT INTO Employee VALUES (001,Ali Lokman, KL, 30-OCT-1997);

II. INSERT INTO Employee (empNo, empName, empAddr, DOB) VALUES (001, Ali Lokman, KL, 30-OCT-1997);

III. UPDATE Employee SET empName=Ali Lokman, empAddr = KL, DOB=30-OCT-1997 WHERE empNo = 001;

Select one:

A.

I, II & III

B.

I & II

C.I

D.III