Advanced SQL Quiz

What is the purpose of views in SQL?

• To simplify complex queries

• To make the business logic consistent

• To enable backward compatibility

• To add extra security layers

Which of the following statements is true about updatable views in MySQL?

• Left join or outer join can be used in the SELECT statement of an updatable view

• DISTINCT can be used in the SELECT statement of an updatable view

• Aggregate functions can be used in the SELECT statement of an updatable view

• UNION or UNION ALL clause can be used in the SELECT statement of an updatable view

What are the advantages of stored procedures in SQL?

• Preventing SQL injection

• Improving database consistency

• Reusable and maintenance-free

• Reducing network traffic

What is the purpose of triggers in SQL?

• To prevent SQL injection

• To encapsulate several SQL statements

• To validate data in the database

• To execute code in response to specified table or view events

What is the purpose of transactions in SQL?

• To insert a new order for a customer

• To start a new transaction

• To get the latest order number

• To prevent MySQL from auto-committing changes