CS403 Quiz 3

Q1. Identify the basic part(s) of a SELECT statement?

1. Both SELECT and FROM
2. FROM
3. DISTINCT
4. SELECT

Correct answer: Both SELECT and FROM

Q2. In vertical partitioning if we divide a table into two vertical partitions, then efficiency of those applications which __________ will be reduced .

1. Access data from first vertical partition.
2. Access data from relations
3. Access data from second vertical partition
4. Access data from both the vertical partitions.

Correct answer: Access data from both the vertical partitions.

Q3. The following is an example of __________ inference rule.

If stId → prName and prName → credits then stId

→ credits

A. Additive

B. Augmentation

C. Projectivity D. Transitivity

Q4. What happens if the WHERE clause is omitted from a DELETE statement?

1. No record from the table will be deleted
2. The statement will not be executed and will give a syntax error
3. All records from the table are deleted
4. First record of the table will be deleted

Correct answer: All records from the table are deleted

Q5. Which of the following SQL clauses used to sort the records in result set?

1. order by
2. from
3. having
4. where

Correct answer: order by

Q6. We should not compromise ________ over efficiency.

1. Consistency
2. Query response time
3. Privacy
4. Accuracy

Correct answer: Accuracy

Q7. The maximum PL/SQL size of data type “VARCHAR2” in DBMS is _____________ bytes.

1. 28767
2. 42767
3. 32767
4. 52767

Correct answer: 32767

Q8. Which of the following is a type of SQL command?

1. DTL command
2. DAL command
3. DCL command
4. TML commands

Correct answer: DCL command

Q9. If A -> B and A -> C, then A -> BC

The Inference Rule applies is;

A. Decomposition B. Augmentation C. Reflexivity

D. Union

Q10. Which of the following is incorrect about alter table statement?

1. Can not be used to create a new table
2. Can be used to add column in the existing table
3. Can be used to delete a column
4. Cannot be used to modify type or size of an existing column

Correct answer: Cannot be used to modify type or size of an existing column