JAVA 1.Which SQL keyword is used to merge rows from multiple tables? A) JOIN. B)

ID: 655699 • Letter: J

Question

JAVA

1.Which SQL keyword is used to merge rows from multiple tables?

A) JOIN.

B) INNER JOIN.
C) GROUP.
D) MERGE.

2.Which SQL keyword is required in every query?

A) FROM.
B) WHERE.
C) ORDER BY.
D) LIKE.

3.Which symbol indicates that all columns should be retrieved?

A) ?
B) *
C) +
D) /

4.To retrieve specific columns from a table, use _________ to separate the column names.

A) ?
B) *
C) ,
D) -

5.Selection criteria can be added to a SQL query using which keyword?

A) FROM.
B) WHERE.
C) SELECT.
D) LIKE.

6.Pattern matching in a SQL query is performed with which clause?

A) FROM.
B) WHERE.
C) SELECT.
D) LIKE.

7.The result of a query can be sorted by using the optional _________ clause.

A) ORDER BY.
B) ORDER.
C) SORT BY.
D) SORT.

8.The default sort order in a sorted query is _________.

A) ascending.
B) descending.
C) natural.
D) None of the above.

1. JOIN
2. FROM
3. *
4. ,
5. WHERE
6. LIKE
7. ORDER BY
8. ASCENDING

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.