SQL Interview Questions and Answers Multiple Choice Questions (MCQ) PDF - 4

MCQ 16: SQL provides mechanisms to rename

1. Relation
2. Attributes
3. Both A and B
4. Tuples

MCQ 17: The where clause of the update statement may contain any construct legal in the where clause of

1. Update statement
2. Having statement
3. From statement
4. Select statement

MCQ 18: The request such as:
insert into student
select *
from student;
encounters the problem of

1. Syntax error
2. Consistency
3. Duplication
4. Attributes

MCQ 19: The output of a request such as:
insert into student
select *
from student;
would be

1. Finite number of tuples
2. Infinite number of tuples
3. Finite number of attributes
4. Infinite number of relations

MCQ 20: The command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as

1. update instructor
   set salary=salary * 1.03
   where salary > 100000;
2. update instructor
   set salary=salary * 1.03
   where salary <>=100000;
3. update in instructor
   set salary=salary * 1.03
   where salary >=100000;
4. update into instructor
   set salary=salary * 1.03
   where salary >=100000;