Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL quize

MySQL quize

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

Preview this deck

To use a FETCH statement with a cursor you always have to supply an explicit direction such next or prior.

Front

1 / 23

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

Section 1

(23 cards)

To use a FETCH statement with a cursor you always have to supply an explicit direction such next or prior.

Front

False

Back

The result of a SELECT statement can contain duplicate rows.

Front

true

Back

SQL is a procedural language.

Front

False

Back

To remove duplicate rows from the result set of a select use the following keyword(s):

Front

DISTINCT

Back

What SQL clause is used to restrict the rows returned by a query?

Front

WHERE

Back

In which of the follwing SQL statements is the keyword SET used?

Front

UPDATE

Back

Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?

Front

3

Back

A primary key may contain NULLS.

Front

False

Back

A table may be joined to itself.

Front

true

Back

Which of the following is the correct SQL statement to use to remove rows from a table?

Front

DELETE

Back

Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(managerid) from employees return?

Front

2

Back

Which of the following is not a valid aggregate function?

Front

COUNT • SUM • COMPUTE (correct answer, your response) • MIN

Back

The left outer join is one type of outer join. Another one is the

Front

The three types are left, right, and full. The keword outer is generally optional.

Back

To sort the results of a SELECT statement use the following clause:

Front

ORDER BY

Back

What type of lock will deny users any access to a table?

Front

EXCLUSIVE

Back

A NULL value is treated as a blank or 0.

Front

false SQL uses three-valued logic. A NULL is unknown which is not the same as empty or blank, etc. That is why SQL has a special IS NULL operator.

Back

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".

Front

false

Back

With .........locking a user may have to redo their work when a conflict occurs.

Front

optimistic

Back

In a select with a group by clause, a where clause, and a having clause, the where conditions are applied before the having conditions.

Front

true

Back

Use the .......clause to restrict groups returned by a grouped query.

Front

HAVING

Back

The two types of SQL environment are interactive and

Front

embedded

Back

The only way to join two tables is by using standard, ANSI syntax.

Front

False

Back

Use the....... statement to add a column to a table.

Front

ALTER

Back