Question 1

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 2

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 3

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

Question 4

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

Accepted Answer

A)  WHERE 
B)  HAVING 
C)  LIKE 
D)  SORT 
E)  DISTINCT 
A)  WHERE 
B)  HAVING 
C)  LIKE 
D)  SORT 
E)  DISTINCT

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Explain two methods for defining a primary key using SQL.

Accepted Answer

A primary key may be defined by either t

Question 7

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 8

What are SQL Built-in Functions?

Accepted Answer

SQL Built-in Functions are functions tha

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Compare and contrast subqueries and joins.

Accepted Answer

Subqueries and joins are both used to pr

Question 12

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

Accepted Answer

The answer of A complete table,including both the table structure...

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

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

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

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

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

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

Explain two methods for defining a primary key using SQL.

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.

What are SQL Built-in Functions?

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

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

Compare and contrast subqueries and joins.

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

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

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

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

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?

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

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

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

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

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

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

Explain two methods for defining a primary key using SQL.

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.

What are SQL Built-in Functions?

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

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

Compare and contrast subqueries and joins.

A complete table,including both the table structure and any data in the table,can be removed from the database by using the SQL ________ command.

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

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

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

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?

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