MySQL

Multiple Choice

Answer as soon as possible

1. In many ways, views are treated as tables in MySQL.

(a) True

(b) False

2. When a view in MySQL is created, the data required to return the results is copied and stored in a table. This table is keep current with triggers, i.e. anytime the original data is changed, the copy in the view's table is updated as well.

(a) True

(b) False

3. In MySQL, you can put triggers on views.

(a) True

(b) False

4. We can use triggers and stored procedures to enforce data integrity rules.

(a) True

(b) False

5. MySQL 8 allows the creation of indexes on views to speed up queries that reference these views.

(a) True

(b) False

6. What is the maximum number of triggers for each event type and trigger time (ex: BEFORE UPDATE) that can added to a single table?

(a) 1

(b) 2

(c) 16

(d) 64

(e) There is no limit

7. Which of the following are event trigger types for triggers. (Select all that applies)

(a) UPDATE

(b) INSERT

(c) SELECT

(d) DROP TABLE

(e) DELETE

(f) CREATE

8. Which of the following is the correct way to create a view called numEmployees that gets the number of rows in the employees table in MySQL?

(a) CREATE VIEW numEmployees AS SELECT count(*) FROM employees;

(b) STORE SELECT count(*) FROM employees AS VIEW numEmployees;

(c) CREATE VIEW SELECT count(*) FROM employees AS numEmployees;

(d) STORE AS VIEW numEmployees SELECT count(*) FROM employees;

(e) CREATE numEmployees AS VIEW SELECT count(*) FROM employees;