FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Introduction to Structured Query Language Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

A(n) _____ join will select only the rows with matching values in the common attribute(s) .

A) natural
B) outer
C) full
D) cross

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

_____ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

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

_____ is a string function that returns the number of characters in a string value.

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

Describe the important features and applications of SQL functions.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

The special operator used to check whether an attribute value matches a given string pattern is _____.

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

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

A(n) _____ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Numeric functions take one numeric parameter and return one value.

When using a(n) _____ join, only rows from the tables that match on a common value are returned.

String comparisons are made from left to right.

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

You cannot insert a row containing a null attribute value using SQL.

The _____ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.