FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Structured Query Language

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is not a standard data type used in SQL?

A) Text
B) Char
C) Varchar
D) Integer
E) Numeric

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which symbol is used in standard SQL as a wildcard to represent a single,unspecified character?

A) (percent sign) %
B) (exclamation mark) !
C) (underscore) _
D) (question mark) ?
E) (semi-colon) ;

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

Explain why it is important to learn SQL.

To force the DBMS to remove duplicate rows from the results of an SQL SELECT query,the keyword DISTINCT must be used.

The SQL command used to add new data to a table is ________.

Explain how to run an SQL query in Microsoft Access.

Which type of join,although not included in standard SQL,was created to allow unmatched rows to appear in the result of a join operation?

One way to specify all of the columns of a table is to use the special character * after the SQL keyword ________.

In SQL,the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.

The values of existing data can be removed from a table using the SQL ________ command,which can even be used to remove all the data in the table at one time.

Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?

Microsoft Access SQL allows table structures to be modified by using the standard SQL ________ command.

Standard SQL does not allow built-in functions to be used in a WHERE clause.

In Microsoft Access,standard SQL table creation syntax items not supported by Access SQL can generally be implemented by:

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

Which of the following standard SQL data types is not supported in Microsoft Access SQL?

Data is added to a table using the SQL INSERT command.

In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.

Distinguish between the HAVING clause and the WHERE clause.