FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Introduction to Structured Query Language

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Essay

Review LaterAdd Note

Review Later

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL keyword LIKE.Include an example based on the CUSTOMER table from the General Sales database;use at least one wildcard.

Correct Answer

verified

The LIKE keyword is used in the WHERE cl...

View Answer

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

The clause SELECT COUNT (*)results in a table with a single row and a single column.

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

To refer to a set of values needed for a condition,use the SQL IN operator.

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

An asterisk (*)following the SELECT verb means that all columns are to be displayed.

The SQL wildcard character "%" represents a series of one or more unspecified characters.

In an SQL query,which built-in function is used to compute the number of rows in a table?

The SQL syntax JOIN ...ON can be used as an alternate way of writing an SQL join statement.

What is SQL?

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all employees who are also customers,which SQL keyword would you most likely use?

To sort the rows of the result table,the ORDER BY clause is specified.

In an SQL query,which of the following symbols is used by ANSI SQL to represent a single unspecified character?

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

SQL is not a complete programming language.Rather it is a data sublanguage.

SQL is a ________.

In an SQL query,which built-in function is used to compute the average value of numeric columns?

The SQL WHERE clause contains the condition that specifies which rows are to be selected.

The rows of the result table can be sorted by the values in one or more columns.

In an SQL query,which SQL keyword is used to implement a subquery?

The SQL wildcard character "#" indicates a single,unspecified character in a specific location in an SQL query.