Question 1

Explain why it is important to learn SQL.

Accepted Answer

Most modern DBMS products support SQL as...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   setting the Data Types in Access table Design View.
B)   setting the field properties in Access table Design View.
C)   setting the relationship properties in the Edit Relationship dialog box.
D)   setting the referential integrity properties in the Edit Relationship dialog box.
E)   running an ALTER TABLE query in Access SQL.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

To run an SQL query in Microsoft Access,...

Question 6

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

Accepted Answer

A)   Integer
B)   Char(25) 
C)   VarChar(35) 
D)   Numeric(5,3) 
E)   DateTime

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A)   Char
B)   VarChar
C)   Integer
D)   Numeric
E)   Both A and B

Question 10

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

Accepted Answer

A)   SELECT
B)   FROM
C)   WHERE
D)   ORDER BY
E)   GROUP BY

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of The SQL command used to add new...

Question 14

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.

Accepted Answer

The answer of The values of existing data can be...

Question 15

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

The answer of Microsoft Access SQL allows table structures to...

Question 19

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

Accepted Answer

The answer of One way to specify all of the...

Question 20

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?

Accepted Answer

A)   ODD JOIN
B)   OPEN JOIN
C)   OUTER JOIN
D)   INNER JOIN
E)   COMBINE JOIN

Exam 3: Structured Query Language

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?

Correct AnswerverifiedShow Answer

Distinguish between the HAVING clause and the WHERE clause.

Correct AnswerverifiedThe HAVING clause and the WHERE clause d...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain how to run an SQL query in Microsoft Access.

Correct AnswerverifiedTo run an SQL query in Microsoft Access,...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain why it is important to learn SQL.

Correct AnswerverifiedMost modern DBMS products support SQL as...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
The HAVING clause and the WHERE clause d...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
To run an SQL query in Microsoft Access,...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Most modern DBMS products support SQL as...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified