Question 1

Microsoft Access SQL commands are run in the ________ of a Query window.

Accepted Answer

The answer of Microsoft Access SQL commands are run in...

Question 2

An SQL data type of ________ would indicate a variable-length character string with maximum length 75.

Accepted Answer

The answer of An SQL data type of ________ would...

Question 3

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

Accepted Answer

A)  DROP TABLE STUDENT; 
B)  DELETE TABLE STUDENT; 
C)  REMOVE TABLE STUDENT; 
D)  SELECT * FROM STUDENT THEN DROP; 
E)  DELETE FROM STUDENT; 
A)  DROP TABLE STUDENT; 
B)  DELETE TABLE STUDENT; 
C)  REMOVE TABLE STUDENT; 
D)  SELECT * FROM STUDENT THEN DROP; 
E)  DELETE FROM STUDENT;

Question 4

In SQL,the LIKE keyword can be used to select on partial values.

Accepted Answer

A) True 
 B)False

Question 5

In SQL,the WHERE clause is used to specify which columns will be included in the result.

Accepted Answer

A) True 
 B)False

Question 6

The values of existing data can be modified using the SQL ________ command,which can be used to change several column values at once.

Accepted Answer

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

Question 7

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 8

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Accepted Answer

The answer of Table and relationship properties not supported by...

Question 9

Given the table CUSTOMER(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 10

Microsoft Access can run QBE queries,but not SQL queries.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Values of existing data can be changed using SQL through the CHANGE command.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not true about primary keys?

Accepted Answer

A)  Primary keys cannot be null. 
B)  Primary keys must be unique. 
C)  Primary keys must be a single attribute. 
D)  Primary keys are used to represent relationships. 
E)  Primary keys can be defined using an SQL CONSTRAINT phrase. 
A)  Primary keys cannot be null. 
B)  Primary keys must be unique. 
C)  Primary keys must be a single attribute. 
D)  Primary keys are used to represent relationships. 
E)  Primary keys can be defined using an SQL CONSTRAINT phrase.

Question 14

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?

Accepted Answer

A)  DROP TABLE STUDENT; 
B)  DELETE TABLE STUDENT; 
C)  REMOVE TABLE STUDENT; 
D)  SELECT * FROM STUDENT THEN DROP; 
E)  DELETE FROM STUDENT; 
A)  DROP TABLE STUDENT; 
B)  DELETE TABLE STUDENT; 
C)  REMOVE TABLE STUDENT; 
D)  SELECT * FROM STUDENT THEN DROP; 
E)  DELETE FROM STUDENT;

Question 15

Given the table
CUSTOMER(CustID,Name,PhoneNumber,AccountBalance)
write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Accepted Answer

SELECT Name,PhoneNum

Question 16

Which of the following cannot be done using the CONSTRAINT phrase?

Accepted Answer

A)  Create a single attribute primary key. 
B)  Define a foreign key. 
C)  Establish a referential integrity constraint. 
D)  All of the above can be done using the CONSTRAINT phrase. 
E)  None of the above can be done using the CONSTRAINT phrase. 
A)  Create a single attribute primary key. 
B)  Define a foreign key. 
C)  Establish a referential integrity constraint. 
D)  All of the above can be done using the CONSTRAINT phrase. 
E)  None of the above can be done using the CONSTRAINT phrase.

Question 17

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 18

The result for SELECT statements in SQL is a relation unless the result is a single number.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Microsoft Access SQL commands are run within the SQL View of a Query window.

Accepted Answer

A) True 
 B)False

Microsoft Access SQL commands are run in the ________ of a Query window.

An SQL data type of ________ would indicate a variable-length character string with maximum length 75.

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

In SQL,the LIKE keyword can be used to select on partial values.

In SQL,the WHERE clause is used to specify which columns will be included in the result.

The values of existing data can be modified using the SQL ________ command,which can be used to change several column values at once.

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

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

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

Microsoft Access can run QBE queries,but not SQL queries.

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

Values of existing data can be changed using SQL through the CHANGE command.

Which of the following is not true about primary keys?

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Which of the following cannot be done using the CONSTRAINT phrase?

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

The result for SELECT statements in SQL is a relation unless the result is a single number.

Microsoft Access SQL commands are run in:

Microsoft Access SQL commands are run within the SQL View of a Query window.

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

Microsoft Access SQL commands are run in the ________ of a Query window.

An SQL data type of ________ would indicate a variable-length character string with maximum length 75.

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

In SQL,the LIKE keyword can be used to select on partial values.

In SQL,the WHERE clause is used to specify which columns will be included in the result.

The values of existing data can be modified using the SQL ________ command,which can be used to change several column values at once.

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

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

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

Microsoft Access can run QBE queries,but not SQL queries.

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

Values of existing data can be changed using SQL through the CHANGE command.

Which of the following is not true about primary keys?

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Which of the following cannot be done using the CONSTRAINT phrase?

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

The result for SELECT statements in SQL is a relation unless the result is a single number.

Microsoft Access SQL commands are run in:

Microsoft Access SQL commands are run within the SQL View of a Query window.

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