FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Beginning Structured Query Language Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

The conditional LIKE must be used in conjunction with wildcard characters.

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) BETWEEN
B) NULL
C) LIKE
D) IN

E) B) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

In the SQL environment, the word ____________________ covers both questions and actions.

With the exception of the database ____________________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

A(n) ____ is a query that is embedded (or nested) inside another query.

The SQL command that modifies an attribute's values in one or more table's rows is ____.

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

String comparisons are made from left to right.

The ____________________ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables you to transform data into information.

If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.

The special operator used to check whether a subquery returns any rows is ____.

To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.

Date procedures are often more software-specific than other SQL procedures.

To list all the contents of the PRODUCT table, you would use ____.

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

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

Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.

The ANSI SQL standards are also accepted by the ISO.