Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
expressions coded in the HAVING clause:
|
can use either aggregate search conditions or non-aggregate search conditions |
|
Assuming that all the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?
INSERT INTO InvoiceCopy (VendorID, InvoiceNumber, InvoiceTotal, PaymentTotal, CreditTotal, TermsID, InvoiceDate, InvoiceDueDate) VALUES (97, '456789', 8344.50, 0, 0, 1, '2006-08-01') |
The number of items in the column list doesn't match the number in the VALUES list
|
|
In order to insert several rows into a table with an INSERT statement, you code a subquery in place of the VALUES clause.
|
True
|
|
If introduced as follows, the subquery can return which of the values listed below?
WHERE 2 < (subquery) |
a single value
|
|
When coded in a WHERE clause, which of the following search conditions will not return a result set that includes all invoices with an InvoiceTotal value of $1000 or less?
|
InvoiceTotal IN (0,1000) |
|
If you define a column as an identity column, |
a number is generated for that column whenever a row is added to the table
|
|
By default, all duplicate values are included in the aggregate calculation, unless you specify the DISTINCT keyword
|
True
|
|
Which of the statements below best describes the result set returned by this SELECT statement?
SELECT VendorID, SUM(InvoiceTotal - PaymentTotal - CreditTotal) AS Column2 FROM Invoices WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0 GROUP BY VendorID |
The total unpaid balance due for each VendorID |
|
Which of the following recommendations won’t improve the readability of your SQL statements? |
Use comments to describe what each statement does. |
|
A correlated subquery is one that |
is executed once for each row in the outer query |