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 41

True/False

Review LaterAdd Note

Review Later

When joining three or more tables,you need to specify a join condition for one pair of tables.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

A(n)____________________ is performed when data is retrieved from more than one table at a time.

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

A table can be deleted from the database by using the ____________________ command.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

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.

The ____ command is used to restore the table's contents to their previous values.

The SQL aggregate function that gives the average for the specific column is ____.

A(n) ____ is an alternate name given to a column or table in any SQL statement.

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.

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

____________________ words are words used by SQL to perform specific functions.

Which query will output the table contents when the value of V_CODE is not equal to 21344?

An example of a command you would use when making changes to a PRODUCT table is ____.

In Oracle,the ____ command is used to change the display for a column,for example,to place a $ in front of a numeric value.

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

Most SQL implementations yield case-insensitive searches.