Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
My SQL

My SQL

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

Preview this deck

The ____ special operator is used to check whether an attribute value is null. BETWEEN IS NULL LIKE IN

Front

1 / 16

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 (16)

Section 1

(16 cards)

The ____ special operator is used to check whether an attribute value is null. BETWEEN IS NULL LIKE IN

Front

IS NULL

Back

To delete data from the database, use the ____ command. ROLLBACK COMMIT DELETE UPDATE

Front

DELETE

Back

The SQL command that lets you select attributes from rows in one or more tables is ____. INSERT SELECT COMMIT UPDATE

Front

SELECT

Back

Which of the following commands changes the value in a column? REPLACE CHANGE ADD UPDATE

Front

UPDATE

Back

When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____. no rows will be deleted the first row will be deleted the last row will be deleted all rows will be deleted

Front

all rows will be deleted

Back

In subquery terminology, the first query in the SQL statement is known as the ____ query. outer left inner base

Front

outer

Back

In MySQL, use the ____ data type for variable-length character columns. CHARLENGTH VARIABLE VARCHAR TEXT

Front

VARCHAR

Back

The ____ function calculates a total of the values in a column. SUM CALCULATE TOTAL ADD

Front

SUM

Back

If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) ____ clause. OF USING HAS JOIN ON

Front

JOIN ON

Back

For any column whose data type is CHAR, values must be enclosed in ____. parentheses square brackets single quotation marks double quotation marks

Front

single quotation marks

Back

Which of the following commands lists all the privileges granted to a user? SHOW SECURITY SHOW PRIVILEGES SHOW USERS SHOW GRANTS

Front

SHOW GRANTS

Back

A ____ join returns rows with matching values and includes all rows from both tables with unmatched values. natural inner full outer left outer

Front

full outer

Back

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause? inner outer product nested

Front

inner

Back

The ____ operator could be used in place of INTERSECT if the RDBMS does not support it. IN OF AND UNION

Front

IN

Back

The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____. COUNT MIN MAX SUM

Front

COUNT

Back

The special operator used to check whether an attribute value is within a range of values is ____. BETWEEN NULL LIKE IN

Front

BETWEEN

Back