Question 1

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 E

Question 2

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

Accepted Answer

A)  Char 
B)  Date/Time 
C)  Integer 
D)  Numeric 
E)  Decimal 
A)  Char 
B)  Date/Time 
C)  Integer 
D)  Numeric 
E)  Decimal A

Question 3

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,PhoneNumber
FROM CUSTOMER
WHERE Name LIKE 'S%';

Question 4

SQL stands for ________.

Accepted Answer

Structured

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

Accepted Answer

A)  SORT BY Department 
B)  REVERSE Department 
C)  ORDER BY Department DESC 
D)  SORT BY Department DESC 
E)  SORT BY Department REVERSE 
A)  SORT BY Department 
B)  REVERSE Department 
C)  ORDER BY Department DESC 
D)  SORT BY Department DESC 
E)  SORT BY Department REVERSE

Question 9

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 10

In SQL,to refer to a range of values in a WHERE clause,use the WITHIN keyword.

Accepted Answer

A) True 
 B)False

Question 11

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

Accepted Answer

A) True 
 B)False

Question 12

If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

Accepted Answer

A) True 
 B)False

Question 13

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

Accepted Answer

A)  MODIFY TABLE 
B)  CHANGE TABLE 
C)  CREATE TABLE 
D)  SET TABLE 
E)  BUILD TABLE 
A)  MODIFY TABLE 
B)  CHANGE TABLE 
C)  CREATE TABLE 
D)  SET TABLE 
E)  BUILD TABLE

Question 14

SQL is not a complete programming language,but is rather a(n)________.

Accepted Answer

The answer of SQL is not a complete programming language,but...

Question 15

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 16

The SQL GROUP BY keyword can be used to group rows by common values.

Accepted Answer

A) True 
 B)False

Question 17

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 18

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

Accepted Answer

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

Question 19

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 20

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;

Microsoft Access SQL commands are run in ________.

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

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

SQL stands for ________.

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

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

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

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

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

In SQL,to refer to a range of values in a WHERE clause,use the WITHIN keyword.

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

SQL is not a complete programming language,but is rather a(n)________.

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

The SQL GROUP BY keyword can be used to group rows by common values.

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

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

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

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

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 3: Structured Query Language

Microsoft Access SQL commands are run in ________.

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

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

SQL stands for ________.

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

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

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

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

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

In SQL,to refer to a range of values in a WHERE clause,use the WITHIN keyword.

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

SQL is not a complete programming language,but is rather a(n)________.

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

The SQL GROUP BY keyword can be used to group rows by common values.

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

An SQL data type of ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point.

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

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

Getting Started

The Relational Model

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters