Plzzz b3 fast database

Problem 2: MCQ (30 pts) 1. Every Boyce code normal form is in a. First Normal Form b. Second Normal Form C. Third Normal Form d. All the above a. C. a. C. C. 2. A functional dependency is a relationship between or among: Entities b. Rows Attributes d. Tables 3. Insert, Delete and Update queries modify the of a table. Rows b. Columns Constraints d. Schema 4. Which function we use to find the number of rows in a query result: a. Total b. Sum C. Count d. Number 5. Which of the following is not a SQL aggregate function? a. AVG b. COUNT CONCAT d. SUM 6. Which of the following is not a valid SQL data type? a. INTEGER b. VARCHAR C. PRIMARY d. DATE 7. Which of the following value will match the condition LIKE'_B_!: a. XBY b. B C. 1B3 d. All the above 8. What is the purpose of the SQL operator IN? a. Specifies that the sort order should be increasing b. Used to test if one value appears in a set of values c. Indicates in which table each field can be found d. Used in the GROUP BY only 9. Which SQL keyword is used to sort the result? a. GROUP BY b. SORT C. ORDER BY d. SORT BY Page 4 of 8 CSC1335 Final E 2021 - 2022 a. 10. Which of the following constraint does not enforce uniqueness? UNIQUE b. Primary key C. Foreign key d. None of the mentioned