Introduction to SQL Questions

Relational Databases — What Is a SQL View? Which description correctly identifies a view in SQL and how it is accessed?

SQL-92 Basics — Meaning of the Asterisk () in SELECT According to the SQL-92 standard, when you write SELECT * from a single table, what does the asterisk () specify?

SQL Data Definition — Removing a Table Which command correctly eliminates (drops) the table named CUSTOMER from a relational database?

SQL Querying — Subqueries vs. Joins Which statement about subqueries in a SELECT statement is accurate with respect to equivalence with joins?

SQL Projection — Specifying Columns to Display How do you specify the columns to display and the source tables in a standard SQL SELECT statement?

In SQL, the set of query and modification commands (used to insert, update, delete, and retrieve data) make up which language category?

In an SQL SELECT statement, how must a subquery be enclosed syntactically?

In SQL, the set of commands used for defining database schema objects (such as CREATE, ALTER, and DROP) make up which language category?

In Microsoft Access, which two wildcard characters are used for pattern matching?

In SQL, the referential action ON UPDATE CASCADE ensures which property of relational databases?

In SQL, when is the wildcard operator (e.g., %, _, *, ?) in a WHERE clause particularly useful?

According to the SQL-92 standard, which two wildcard characters are used with the LIKE operator?

Which of the following lists the five built-in aggregate functions provided by standard SQL?

Which SQL statement is equivalent to: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Which of the following statements is valid standard SQL to create an index (choose the only syntactically correct example)?

In Structured Query Language (SQL), which clause should you use to sort the result set returned by a SELECT query (for example, alphabetically by a column or numerically ascending/descending)?

In relational databases, what is a key benefit of using a standard, vendor-neutral SQL language across systems and tools?

When designing a new SQL table, which foundational elements should be considered during the CREATE TABLE phase to ensure data quality and performance?

For a basic SQL query, what is the correct canonical ordering of clauses to retrieve filtered data from specific tables?

In SQL pattern matching, which keyword is used with wildcard characters (for example, % and _) to filter rows by a textual pattern?