Question 1

In Microsoft Access,tables are added to a QBE Query window by selecting the tables from the ________ dialog box.

Accepted Answer

The answer of In Microsoft Access,tables are added to a...

Question 2

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 3

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 4

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Question 7

SQL was developed by ________ in the late 1970s.

Accepted Answer

The answer of SQL was developed by ________ in the...

Question 8

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

Accepted Answer

A)  UPDATE STUDENT SET Advisor = 'Smith'; 
B)  MODIFY STUDENT SET Advisor = 'Smith'; 
C)  MODIFY Advisor SET STUDENT = 'Smith'; 
D)  UPDATE Advisor = 'Smith'; 
E)  SET STUDENT Advisor = 'Smith'; 
A)  UPDATE STUDENT SET Advisor = 'Smith'; 
B)  MODIFY STUDENT SET Advisor = 'Smith'; 
C)  MODIFY Advisor SET STUDENT = 'Smith'; 
D)  UPDATE Advisor = 'Smith'; 
E)  SET STUDENT Advisor = 'Smith';

Question 9

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

Which SQL keyword can be used in conjunction with wildcards to select partial values?

Accepted Answer

A)  SELECT 
B)  SEARCH 
C)  FIND 
D)  SUBSTRING 
E)  LIKE 
A)  SELECT 
B)  SEARCH 
C)  FIND 
D)  SUBSTRING 
E)  LIKE

Question 12

The order of the columns returned by an SQL SELECT statement is determined by the:

Accepted Answer

A)  ORDER BY clause. 
B)  SORT BY clause. 
C)  order they are listed in following SELECT. 
D)  order they are listed in following WHERE. 
E)  order they are listed in following FROM. 
A)  ORDER BY clause. 
B)  SORT BY clause. 
C)  order they are listed in following SELECT. 
D)  order they are listed in following WHERE. 
E)  order they are listed in following FROM.

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data typ

Question 16

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 17

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 20

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

Accepted Answer

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

In Microsoft Access,tables are added to a QBE Query window by selecting the tables from the ________ dialog box.

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?

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?

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

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.

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

SQL was developed by ________ in the late 1970s.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

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

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

Which SQL keyword can be used in conjunction with wildcards to select partial values?

The order of the columns returned by an SQL SELECT statement is determined by the:

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

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

Discuss SQL data types.

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

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

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

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

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

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

In Microsoft Access,tables are added to a QBE Query window by selecting the tables from the ________ dialog box.

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?

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?

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

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.

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

SQL was developed by ________ in the late 1970s.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

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

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

Which SQL keyword can be used in conjunction with wildcards to select partial values?

The order of the columns returned by an SQL SELECT statement is determined by the:

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

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

Discuss SQL data types.

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

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

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

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

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

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