SQL Views and Normalization Quiz

What are SQL views?

• Tables that contain data

• SELECT statements saved in the database

• Complex queries that cannot be simplified

• Temporary tables used for calculations

Which of the following is a benefit of using views?

• They contain actual data.

• They increase complexity.

• They can reduce complexity.

• They cannot be used to format data.

How do views affect data reusability?

• They decrease reusability.

• They have no impact on reusability.

• They increase reusability by avoiding repetitive joins.

• They complicate data retrieval.

What can views be used for in terms of data formatting?

• They cannot format data.

• They can format data.

• They only format numerical data.

• They only format text data.

What type of columns can views create?

• Only text columns

• Only numerical columns

• Calculated columns

• No columns

What is one way views can simplify column names?

• By making them more complex

• By using column aliases

• By deleting columns

• By restricting column names

How do views handle subsets of data?

• They include all parts of the tables.

• They contain only the relevant parts of the tables.

• They duplicate data.

• They have no impact on data subsets.

What is a security benefit of using views?

• They grant full access to all tables.

• They restrict access to original tables.

• They have no impact on security.

• They allow unauthorized alterations.

What SQL statement is used to create a new view?

• ALTER VIEW

• DROP VIEW

• CREATE VIEW

• SELECT VIEW

Where is a view stored after it is created?

• In a separate file

• Within the database

• In the cloud

• In the user's computer