Question 1

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 2

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 3

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 4

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

Accepted Answer

A) True 
 B)False

Question 5

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 6

To open a new Microsoft Access Query window ________.

Accepted Answer

A)  click the New button on the Home command tab 
B)  click the New Query button on the Home command tab 
C)  click the Create Query button on the Create command tab 
D)  click the New Query in Design view button on the Create command tab 
E)  click the Query Design button on the Command tab 
A)  click the New button on the Home command tab 
B)  click the New Query button on the Home command tab 
C)  click the Create Query button on the Create command tab 
D)  click the New Query in Design view button on the Create command tab 
E)  click the Query Design button on the Command tab

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A subquery is appropriate only if the final result contains only data from a single table.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.

Accepted Answer

A) True 
 B)False

Question 11

Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns,but not around values for Integer and Numeric columns.

Accepted Answer

The answer of Conditions in an SQL INSERT command and...

Question 12

Data from a maximum of three tables can be combined through the use of subqueries in SQL.

Accepted Answer

A) True 
 B)False

Question 13

SQL was developed by ________ in the late 1970s.

Accepted Answer

the IBM Co

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

Accepted Answer

A)  UNIQUE 
B)  SORT 
C)  ORDER BY 
D)  DISTINCT 
E)  REDUCE 
A)  UNIQUE 
B)  SORT 
C)  ORDER BY 
D)  DISTINCT 
E)  REDUCE

Question 17

Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

Accepted Answer

A)  WHERE CUSTOMER-AcctBalance > 50 
B)  WHERE (CUSTOMER-AcctBalance > 50) 
C)  WHERE AcctBalance > 50 
D)  WHERE (AcctBalance > 50) 
E)  HAVING AcctBalance > 50 
A)  WHERE CUSTOMER-AcctBalance > 50 
B)  WHERE (CUSTOMER-AcctBalance > 50) 
C)  WHERE AcctBalance > 50 
D)  WHERE (AcctBalance > 50) 
E)  HAVING AcctBalance > 50

Question 18

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 19

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 20

When using SQL to create a table,a column is defined by declaring,in this order: data type,column name,and optional constraints.

Accepted Answer

A) True 
 B)False

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

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

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

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

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

To open a new Microsoft Access Query window ________.

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

A subquery is appropriate only if the final result contains only data from a single table.

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

Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.

Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns,but not around values for Integer and Numeric columns.

Data from a maximum of three tables can be combined through the use of subqueries in SQL.

SQL was developed by ________ in the late 1970s.

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

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

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

Given the table CUSTOMER(CustID,Name,PhoneNum,AcctBalance) What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

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

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

When using SQL to create a table,a column is defined by declaring,in this order: data type,column name,and optional constraints.

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

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

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

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

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

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

To open a new Microsoft Access Query window ________.

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

A subquery is appropriate only if the final result contains only data from a single table.

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

Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.

Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns,but not around values for Integer and Numeric columns.

Data from a maximum of three tables can be combined through the use of subqueries in SQL.

SQL was developed by ________ in the late 1970s.

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

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

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

Given the table CUSTOMER(CustID,Name,PhoneNum,AcctBalance) What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

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

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

When using SQL to create a table,a column is defined by declaring,in this order: data type,column name,and optional constraints.

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