Question 1

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 2

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 3

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 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
E)  GROUP BY

Question 4

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 5

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 
A)  ODD JOIN 
B)  OPEN JOIN 
C)  OUTER JOIN 
D)  INNER JOIN 
E)  COMBINE JOIN

Question 6

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 
A)  Char 
B)  VarChar 
C)  Integer 
D)  Numeric 
E)  Both A and B

Question 7

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 8

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 
A)  Text 
B)  Char 
C)  Varchar 
D)  Integer 
E)  Numeric

Question 9

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d

Question 10

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 11

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 12

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 13

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) ; 
A)  (percent sign) % 
B)   (exclamation mark) ! 
C)  (underscore) _ 
D)   (question mark) ? 
E)   (semi-colon) ;

Question 14

Explain why it is important to learn SQL.

Accepted Answer

Most modern DBMS products support SQL as

Question 15

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. 
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 16

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

Accepted Answer

A) True 
 B)False

Question 17

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

To run an SQL query in Microsoft Access,

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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 
A)  Integer 
B)  Char(25) 
C)  VarChar(35) 
D)  Numeric(5,3) 
E)  DateTime

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

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

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

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

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?

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

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

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

Distinguish between the HAVING clause and the WHERE clause.

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

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

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.

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

Explain why it is important to learn SQL.

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

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

Explain how to run an SQL query in Microsoft Access.

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

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

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

Getting Started

The Relational Model

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 3: Structured Query Language

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

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

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

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

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?

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

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

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

Distinguish between the HAVING clause and the WHERE clause.

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

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

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.

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

Explain why it is important to learn SQL.

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

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

Explain how to run an SQL query in Microsoft Access.

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

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

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

Getting Started

The Relational Model

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters