1. Every Boyce code normal form is in

1. First Normal Form
2. Second Normal Form
3. Third Normal Form
4. All the above

2. A functional dependency is a relationship between or among:

1. Entities
2. Rows
3. Attributes
4. Tables

3. Insert, Delete and Update queries modify the ____________ of a table.

1. Rows
2. Columns
3. Constraints
4. Schema

4. Which function we use to find the number of rows in a query result:

1. Total
2. Sum
3. Count
4. Number

5. Which of the following is not a SQL aggregate function?

1. AVG
2. COUNT
3. CONCAT
4. SUM

6. Which of the following is not a valid SQL data type?

1. INTEGER
2. VARCHAR
3. PRIMARY
4. DATE

7. Which of the following value will match the condition LIKE '_B_ ':

1. XBY
2. _B_
3. 1B3
4. All the above

8. What is the purpose of the SQL operator IN?

1. Specifies that the sort order should be increasing
2. Used to test if one value appears in a set of values
3. Indicates in which table each field can be found
4. Used in the GROUP BY only

9. Which SQL keyword is used to sort the result?

1. GROUP BY
2. SORT
3. ORDER BY
4. SORT BY

10 Which of the following constraint does not enforce uniqueness?

1. UNIQUE
2. Primary key
3. Foreign key
4. None of the mentioned

Choose the best answer