Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
31 cards
()
Section 1

Preview this deck

a column of one or more rows

Front

1 / 31

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (31)

Section 1

(31 cards)

a column of one or more rows

Front

If introduced as follows, the subquery can return which of the values listed below? WHERE vendor_id NOT IN (subquery)

Back

NULL

Front

When you code a column list in an INSERT statement, you can omit columns with default values and columns that allow ____________________________ values

Back

mushrooms, sausage, peppers

Front

The ENUM data type stores values that are mutually exclusive. Which choice is not appropriate for the ENUM type?

Back

a column of one or more rows

Front

If introduced as follows, the subquery can return which of the values listed below? WHERE invoice_total > ALL (subquery)

Back

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Front

The six clauses of the SELECT statement must be coded in the following order:

Back

The number of vendors in each state that has more than one vendor

Front

Which of the statements below best describes the result set returned by this SELECT statement? SELECT vendor_state, COUNT(*) AS column_2 FROM vendors GROUP BY vendor_state HAVING COUNT(*) > 1

Back

COUNT(*)

Front

All of the aggregate functions ignore null values, except for the ______________________________ function.

Back

SELECT

Front

You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement.

Back

a table

Front

If introduced as follows, the subquery can return which of the values listed below? FROM (subquery)

Back

one row for each vendor that shows the largest balance due for any of the vendor's invoices, but only if that balance due is larger than the average balance due for all invoices

Front

SELECT vendor_name, COUNT(*) AS number_of_invoices, MAX(invoice_total payment_ total credit_ total) AS balance_due FROM vendors v JOIN invoices i ON v.vendor_id = i.vendor_id WHERE invoice_total payment_ total credit_ total > (SELECT AVG(invoice_total payment_ total credit_ total) FROM invoices) GROUP BY vendor_name ORDER BY balance_due DESC (Please refer to code example 71.) When this query is executed, the result set will contain

Back

implicit

Front

When MySQL automatically converts one data type to another, it's known as a/an ______________________ conversion.

Back

each vendor with invoice totals over $500

Front

SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invoice_total) AS invoice_average FROM invoices JOIN vendors ON invoices.vendor_id = vendors.vendor_id WHERE vendor_state < 'e' GROUP BY vendor_state, vendor_city, vendor_name HAVING SUM(invoice_total) > 500 ORDER BY vendor_state, vendor_city, vendor_name (Please refer to code example) When this summary query is executed, the result set will contain one summary row for

Back

a subquery can't be introduced in this way

Front

If introduced as follows, the subquery can return which of the values listed below? WHERE (subquery)

Back

32492.05

Front

All of the following values can be stored in a column that's defined as DECIMAL(6,2), except

Back

a single value

Front

If introduced as follows, the subquery can return which of the values listed below? WHERE 2 < (subquery

Back

can use nonaggregate search conditions but can't use aggregate search conditions

Front

Expressions coded in the WHERE clause

Back

WHERE

Front

When you code an UPDATE statement for one or more rows, the SET clause names the columns to be updated and the values to be assigned to those columns, and the ______________________ clause specifies the conditions a row must meet to be updated.

Back

The number of items in the column list doesn't match the number in the VALUES list.

Front

Assuming that all of the table and column names are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO invoices (vendor_id, invoice_number, invoice_total, payment_total, credit_total, terms_id, invoice_date, invoice_due_date) VALUES (97, '456789', 8344.50, 0, 0, 1, '20120831')

Back

DELETE

Front

By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue.

Back

By default, the changes are automatically committed to the database.

Front

Which of the following statements is true when you use MySQL Workbench to run INSERT, UPDATE, and DELETE statements?

Back

subquery select

Front

To insert rows selected from one or more tables into another table with an INSERT statement, you code a/an ___________________________ in place of the VALUES clause.

Back

time

Front

The DATETIME data type includes not only the date, but also a ________________________.

Back

integers

Front

Numbers that don't include a decimal point are known as ____________________.

Back

CAST

Front

The _____________________ function is an ANSIstandard function that you can use to perform an explicit conversion.

Back

'ex' stored in a column of type VARCHAR2(20)

Front

Which uses the least amount of storage?

Back

a single value

Front

If introduced as follows, the subquery can return which of the values listed below? SELECT (subquery)

Back

they all use the same amount of storage

Front

Which uses the least amount of storage?

Back

dates only

Front

The DATE data type can store

Back

yyyy-mm-dd

Front

The default date format for MySQL is _________________.

Back

can use either aggregate search conditions or nonaggregate search conditions

Front

Expressions coded in the HAVING clause

Back

The total unpaid balance due for each vendor_id

Front

Which of the statements below best describes the result set returned by this SELECT statement? SELECT vendor_id, SUM(invoice_total payment_ total credit_ total) AS column_2 FROM invoices WHERE invoice_total payment_ total credit_ total > 0 GROUP BY vendor_id

Back