php chapter 18

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Which of the following isn't a valid column alias? A. total B. total sales C. total_sales D. "Total Sales"

B. total sales

Which clause in a SQL statement will only allow the retrieval of a maximum number of rows? A. LIMIT B. RESTRICT C. MAX D. NUMBER

A. LIMIT

Which of the following is used as a wildcard in a SQL statement to specify that all columns should be retrieved? A.asterisk (*) B. exclamation point (!) C. question mark (?) D. dollar sign ($)

A. asterisk (*)

A _____ is used in a SQL statement to combine columns from two or more tables into a result set. A. join B. sort C. combine D. wildcard

A. join

Which of the following is NOT a comparison operator in a SQL statement? A.<> B. != C. = D>

B. !=

_____ functions perform calculations on the values in a set of selected rows in a SQL query. A. Illegal B. Ideal C. Aggregate D. Computational

C. Aggregate

Which of the following LIMIT clauses will return a maximum of five rows starting with the eleventh row in the result set? A. LIMIT 10, <= 5 B. LIMIT 11, <= 5 C. LIMIT 10, 5 D. LIMIT 11, 5

C. LIMIT 10, 5

In an SQL statement, the _____ clause specifies the rows to retrieve. A.SELECT B.FROM C. WHERE D. ORDER BY

C. WHERE

If introduced as follows, the subquery can return which of the values listed below?FROM (subquery) A. a single value B. a column of one or more rows C. a table D. a subquery can't be introduced in this way

C. a table

In a join, column names need to be qualified only A.in inner joins B. in outer joins C. when the code is confusing D. when the same names are used in both tables

D. when the same names are used in both tables


Ensembles d'études connexes

Chapter 16-Inventory and Operations Management

View Set

2) Harappan Civilization (2600 -1900 BC)

View Set

PSY 202 Week 8 - Chapter 13: Psychological Disorders

View Set

Open Trade practice questions, Currency Exchange Market notes, Balance of Payments Accounts

View Set

Pharmacology Exam 1 - Multiple Choice

View Set

Wong: Chapter 27: The Child with Cardiovascular Dysfunction

View Set

Expansion of The Muslim World unit Quiz study set

View Set