SQL Online Quiz - 3

SQL Server indexed views have strict limitations to ensure determinism and performance optimization. SELF JOINs are not allowed in indexed views because they create circular dependencies that make it difficult for the query optimizer to maintain the indexed view's integrity. Regular views, stored procedures, and triggers can all use SELF JOINs without restrictions.

When creating a table in SQL, you need to consider multiple aspects: data types for each column, primary keys to uniquely identify rows, and default values for columns. These are fundamental components of table definition in SQL CREATE TABLE statements. Ignoring any of these can lead to poor database design or errors. Therefore, all of these factors must be considered when designing a table.

To solve this question, the user needs to have knowledge of SQL and its different components. In particular, the user needs to understand the purpose of SQL query and modification commands.

Now, let's go through each option and explain why it is right or wrong:

A. DDL: This option is incorrect. DDL stands for Data Definition Language and is used to define and manage the structure of a database. DDL commands include CREATE, ALTER, and DROP. While DDL commands are part of SQL, they are not specifically related to SQL query and modification commands.

B. DML: This option is correct. DML stands for Data Manipulation Language and is used to retrieve, insert, update, and delete data in a database. DML commands include SELECT, INSERT, UPDATE, and DELETE, which are commonly used in SQL queries and modifications.

C. HTML: This option is incorrect. HTML stands for Hypertext Markup Language and is used for creating the structure and presentation of web pages. HTML is not related to SQL query and modification commands.

D. XML: This option is incorrect. XML stands for Extensible Markup Language and is used for storing and transporting data. XML is not directly related to SQL query and modification commands.

The Answer is: B. DML

The IN and NOT IN keywords allow you to specify multiple values in a WHERE clause, which is much cleaner and easier than writing long strings of OR or AND conditions for the same column.

Using IN with a single-value list is equivalent to using = for comparison. Both queries return names of customers from Virginia. The IN operator is typically used with multiple values, but works identically with one.

ON UPDATE CASCADE is a referential integrity constraint that automatically updates child records when the parent key changes. This ensures data remains consistent across related tables. Normalization reduces redundancy, materialized views pre-compute results, and the cascade specifically serves integrity.

Tables contain rows (also called records), and rows contain columns (fields) that hold actual data values. The statement 'Rows contain one or more database of information' is false - rows contain individual data elements (fields/columns), not entire databases. Databases contain tables, tables contain rows.

Columns define the specific data attributes like name, address, or phone number. Tables organize data, rows represent individual records, and databases contain tables. The actual data elements (name, address, phone) are stored in columns.