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

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 3

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 4

The basic idea of a join is to combine the contents of two or more relations into a new relation.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) Char 
B) VarChar 
C) Integer 
D) Numeric 
E) Both A and B 
A) Char 
B) VarChar 
C) Integer 
D) Numeric 
E) Both A and B

Question 7

SQL stands for ________.

Accepted Answer

Structured

Question 8

The SUM built-in function in SQL is used to total the values in a numeric column.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

Compare and contrast subqueries and joins.

Accepted Answer

Subqueries and joins are both used to pr

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Given the table $$\text { CUSTOMER(\underline{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 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

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 17

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 18

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

Accepted Answer

A) True 
 B)False

Question 19

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

To run an SQL query in Microsoft Access,

Question 20

Given the table $$\text { STUDENT(\underline{StudentID}, Name, Advisor) }$$,which of the following SQL statements would be used to add new student data to the STUDENT table?

Accepted Answer

A) INSERT DATA STUDENT SET StudentID=123,Name='Jones',Advisor='Smith'; 
B) INSERT INTO STUDENT VALUES (123,'Jones','Smith'); 
C) INSERT INTO STUDENT (New Student Data)VALUES (123,'Jones','Smith'); 
D) INPUT DATA STUDENT SET StudentID=123,Name=' Jones',Advisor='Smith'; 
E) INPUT INTO STUDENT (123,'Jones','Smith'); 
A) INSERT DATA STUDENT SET StudentID=123,Name='Jones',Advisor='Smith'; 
B) INSERT INTO STUDENT VALUES (123,'Jones','Smith'); 
C) INSERT INTO STUDENT (New Student Data)VALUES (123,'Jones','Smith'); 
D) INPUT DATA STUDENT SET StudentID=123,Name=' Jones',Advisor='Smith'; 
E) INPUT INTO STUDENT (123,'Jones','Smith');

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

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

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.

The basic idea of a join is to combine the contents of two or more relations into a new relation.

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

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

SQL stands for ________.

The SUM built-in function in SQL is used to total the values in a numeric column.

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

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

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

Compare and contrast subqueries and joins.

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

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

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

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.

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?

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

Explain how to run an SQL query in Microsoft Access.

Given the table $\text { STUDENT(\underline{StudentID}, Name, Advisor) }$ ,which of the following SQL statements would be used to add new student data to the STUDENT table?

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

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.

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

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.

The basic idea of a join is to combine the contents of two or more relations into a new relation.

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

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

SQL stands for ________.

The SUM built-in function in SQL is used to total the values in a numeric column.

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

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

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

Compare and contrast subqueries and joins.

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

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

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

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.

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?

For a column to be defined as the primary key using table constraints,the column must have been given the property NULL.

Explain how to run an SQL query in Microsoft Access.

Given the table STUDENT(StudentID‾, Name, Advisor) \text { STUDENT(\underline{StudentID}, Name, Advisor) } STUDENT(StudentID​, Name, Advisor) ,which of the following SQL statements would be used to add new student data to the STUDENT table?

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

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

Given the table $\text { STUDENT(\underline{StudentID}, Name, Advisor) }$ ,which of the following SQL statements would be used to add new student data to the STUDENT table?