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

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

A) full
B) outer
C) inner
D) set

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

Numeric functions take one numeric parameter and return one value.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

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

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.

String comparisons are made from left to right.

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

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

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

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

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

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

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

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

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.

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

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

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.