SQL Fundamentals Quiz

SQL keywords and function names are case-insensitive in standard SQL. SELECT, select, and Select are all treated identically. However, string literals and identifiers (depending on database settings) may be case-sensitive.

SELECT INTO creates a new table and copies data from an existing table. This is useful for creating backup copies or staging tables. SELECT column_list INTO new_table FROM source_table copies the structure and data.

Constraints can be added after table creation using ALTER TABLE statements. You can add PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and DEFAULT constraints to existing tables, making database schema modification flexible.

Users cannot directly see a database index. Indexes are internal optimization structures used by the database engine to speed up queries, but they're not visible to users.

SQL views can include functions, WHERE clauses, and JOIN statements. Views are virtual tables based on the result-set of an SQL statement and can use most SQL features.

TINYINT data type in MySQL allows values from -128 to 127 (signed) or 0 to 255 (unsigned), not up to 198. The statement claiming 0-198 is false.

In SQL, aggregate functions like COUNT, SUM, AVG cannot be used directly in WHERE clauses. To filter based on aggregate results, you must use the HAVING clause after GROUP BY.

SQL wildcards (% for any characters, _ for single character) are specifically designed to work with the LIKE operator for pattern matching. They cannot be used with standard comparison operators.

The IN operator in SQL allows you to specify multiple values in a WHERE clause, making it more concise than writing multiple OR conditions. For example, WHERE column IN (1,2,3) is equivalent to WHERE column = 1 OR column = 2 OR column = 3.

SQL commands are categorized into three main types: DDL (Data Definition Language like CREATE, DROP), DML (Data Manipulation Language like SELECT, INSERT), and DCL (Data Control Language like GRANT, REVOKE).

TRUNCATE is a DDL command in Oracle that performs an implicit commit. It cannot be rolled back, so no explicit COMMIT is needed or possible after TRUNCATE.

ORDER BY accepts column names (option A) or ordinal positions (option C). Options B and D incorrectly mix ordinal positions with column names in a way that breaks SQL syntax consistency in some databases.

This appears to reference formal language notations. RHO and PIE (possibly Pi calculus) are theoretical notations used in formal language theory and database theory, while OMEGA and DELTA are not standard SQL notations.

In Oracle, when the listener is down but the instance is up, local connections using IPC/bequeath protocol still work. Remote connections require the listener to establish the initial connection.

SQL LIKE uses % for multi-character wildcards and _ for single-character wildcards. Some databases (like Access) also support ? as a single-character wildcard. The asterisk (*) is not standard SQL LIKE syntax.