Question 1

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Accepted Answer

A) True 
 B)False

Question 2

Given the table
CUSTOMER(CustID,Name,PhoneNumber,AccountBalance)
write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Accepted Answer

SELECT Name,PhoneNum

Question 3

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 4

The TOP built-in function in SQL is used to find the maximum value in a numeric column.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Accepted Answer

A) text(10) 
B) char(10) 
C) varchar(10) 
D) fixed(10) 
E) length(10) 
A) text(10) 
B) char(10) 
C) varchar(10) 
D) fixed(10) 
E) length(10)

Question 7

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 8

In Microsoft Access,tables are added to a Query window by:

Accepted Answer

A) selecting the tables from the Use Table dialog box. 
B) selecting the tables from the Show Table dialog box. 
C) selecting the tables from the Tables section of the Navigation Pane. 
D) selecting the tables from the Queries section of the Navigation Pane. 
E) selecting the tables from the Relationships window. 
A) selecting the tables from the Use Table dialog box. 
B) selecting the tables from the Show Table dialog box. 
C) selecting the tables from the Tables section of the Navigation Pane. 
D) selecting the tables from the Queries section of the Navigation Pane. 
E) selecting the tables from the Relationships window.

Question 9

Microsoft Access SQL commands are run in:

Accepted Answer

A) the SQL window. 
B) the QBE window. 
C) the Query View of an SQL window. 
D) the Design View of a Query window. 
E) the SQL View of a Query window. 
A) the SQL window. 
B) the QBE window. 
C) the Query View of an SQL window. 
D) the Design View of a Query window. 
E) the SQL View of a Query window.

Question 10

Which of the following data types used in SQL would define a numeric field of the pattern 99.99?

Accepted Answer

A) integer(2,2) 
B) integer(5,2) 
C) numeric(2,2) 
D) numeric(4,2) 
E) numeric(5,2) 
A) integer(2,2) 
B) integer(5,2) 
C) numeric(2,2) 
D) numeric(4,2) 
E) numeric(5,2)

Question 11

In Microsoft Access,default values must be set as a field property while the table is in Design View.

Accepted Answer

A) True 
 B)False

Question 12

Given the table $$\text { CUSTOMER(\underline{CustID}, Name, PhoneNum, AcctBalance) }$$
What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

Accepted Answer

A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum 
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum) 
C) SELECT Name,PhoneNum 
D) SELECT (Name,PhoneNum) 
E) SELECT * 
A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum 
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum) 
C) SELECT Name,PhoneNum 
D) SELECT (Name,PhoneNum) 
E) SELECT *

Question 13

In SQL,multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Existing tables in a database can be structurally modified by using the SQL ________ command.

Accepted Answer

The answer of Existing tables in a database can be...

Question 16

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 17

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

Accepted Answer

A) WHERE Hours = MIN(10)and MAX(50) 
B) WHERE Hours IN [10,50] 
C) WHERE Hours = 10 and Hours = 50 
D) WHERE Hours BETWEEN 10 AND 50 
E) WHERE Hours RANGE 10 TO 50 
A) WHERE Hours = MIN(10)and MAX(50) 
B) WHERE Hours IN [10,50] 
C) WHERE Hours = 10 and Hours = 50 
D) WHERE Hours BETWEEN 10 AND 50 
E) WHERE Hours RANGE 10 TO 50

Question 18

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

Accepted Answer

A) True 
 B)False

Question 19

Using standard SQL,unmatched rows will not appear in the result of a join.

Accepted Answer

A) True 
 B)False

Question 20

Using SQL commands,multiple tables can be queried using either subqueries or ________.

Accepted Answer

The answer of Using SQL commands,multiple tables can be queried...

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

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.

The TOP built-in function in SQL is used to find the maximum value in a numeric column.

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

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

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

In Microsoft Access,tables are added to a Query window by:

Microsoft Access SQL commands are run in:

Which of the following data types used in SQL would define a numeric field of the pattern 99.99?

In Microsoft Access,default values must be set as a field property while the table is in Design View.

Given the table $\text { CUSTOMER(\underline{CustID}, Name, PhoneNum, AcctBalance) }$ What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

In SQL,multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.

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

Existing tables in a database can be structurally modified by using the SQL ________ command.

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 is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

Using standard SQL,unmatched rows will not appear in the result of a join.

Using SQL commands,multiple tables can be queried using either subqueries or ________.

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 3: Structured Query Language

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

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.

The TOP built-in function in SQL is used to find the maximum value in a numeric column.

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

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

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

In Microsoft Access,tables are added to a Query window by:

Microsoft Access SQL commands are run in:

Which of the following data types used in SQL would define a numeric field of the pattern 99.99?

In Microsoft Access,default values must be set as a field property while the table is in Design View.

Given the table CUSTOMER(CustID‾, Name, PhoneNum, AcctBalance) \text { CUSTOMER(\underline{CustID}, Name, PhoneNum, AcctBalance) } CUSTOMER(CustID​, Name, PhoneNum, AcctBalance) What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

In SQL,multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.

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

Existing tables in a database can be structurally modified by using the SQL ________ command.

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 is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

Using standard SQL,unmatched rows will not appear in the result of a join.

Using SQL commands,multiple tables can be queried using either subqueries or ________.

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Given the table $\text { CUSTOMER(\underline{CustID}, Name, PhoneNum, AcctBalance) }$ What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?