Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is not one of the five SQL built-in functions?

Accepted Answer

A)  MODE 
B)  SUM 
C)  COUNT 
D)  MAX 
E)  AVG 
A)  MODE 
B)  SUM 
C)  COUNT 
D)  MAX 
E)  AVG

Question 4

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

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;

Question 5

Given the table
CUSTOMER(CustID,Name,PhoneNumber,AccountBalance)
write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Accepted Answer

SELECT Name,PhoneNum

Question 6

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

Accepted Answer

The answer of Table and relationship properties not supported by...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

In Microsoft Access,the default method of creating and running a query is ________.

Accepted Answer

Query By E

Question 11

The values of existing data can be removed from a table using the SQL ________ command,which can even be used to remove all the data in the table at one time.

Accepted Answer

The answer of The values of existing data can be...

Question 12

In SQL,the WHERE clause is used to specify which columns will be included in the result.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following standard SQL data types is not supported in Microsoft Access SQL?

Accepted Answer

A)  Integer 
B)  Char(25) 
C)  VarChar(35) 
D)  Numeric(5,3) 
E)  DateTime 
A)  Integer 
B)  Char(25) 
C)  VarChar(35) 
D)  Numeric(5,3) 
E)  DateTime

Question 14

Given the tables
STUDENT(StudentID,StudentName,AdvisorID)
ADVISOR(AdvisorID,AdvisorName,Office,Phone)
Which of the following SQL statements would be used to implant a join between the two tables?

Accepted Answer

A)  WHERE STUDENT MATCH ADVISOR 
B)  WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID 
C)  WHERE STUDENT = ADVISOR 
D)  WHERE STUDENT JOIN ADVISOR 
E)  WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID 
A)  WHERE STUDENT MATCH ADVISOR 
B)  WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID 
C)  WHERE STUDENT = ADVISOR 
D)  WHERE STUDENT JOIN ADVISOR 
E)  WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

Question 15

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 16

Microsoft Access SQL commands are run in the ________ of a Query window.

Accepted Answer

The answer of Microsoft Access SQL commands are run in...

Question 17

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 18

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

Question 19

Which of the following is not true about primary keys?

Accepted Answer

A)  Primary keys cannot be null. 
B)  Primary keys must be unique. 
C)  Primary keys must be a single attribute. 
D)  Primary keys are used to represent relationships. 
E)  Primary keys can be defined using an SQL CONSTRAINT phrase. 
A)  Primary keys cannot be null. 
B)  Primary keys must be unique. 
C)  Primary keys must be a single attribute. 
D)  Primary keys are used to represent relationships. 
E)  Primary keys can be defined using an SQL CONSTRAINT phrase.

Question 20

Which of the following cannot be done using the CONSTRAINT phrase?

Accepted Answer

A)  Create a single attribute primary key. 
B)  Define a foreign key. 
C)  Establish a referential integrity constraint. 
D)  Define an attribute to be NOT NULL. 
E)  Defining a name for the constraint. 
A)  Create a single attribute primary key. 
B)  Define a foreign key. 
C)  Establish a referential integrity constraint. 
D)  Define an attribute to be NOT NULL. 
E)  Defining a name for the constraint.

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

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Which of the following is not one of the five SQL built-in functions?

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

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

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

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

In Microsoft Access,the default method of creating and running a query is ________.

The values of existing data can be removed from a table using the SQL ________ command,which can even be used to remove all the data in the table at one time.

In SQL,the WHERE clause is used to specify which columns will be included in the result.

Which of the following standard SQL data types is not supported in Microsoft Access SQL?

Given the tables STUDENT(StudentID,StudentName,AdvisorID) ADVISOR(AdvisorID,AdvisorName,Office,Phone) Which of the following SQL statements would be used to implant a join between the two tables?

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

Microsoft Access SQL commands are run in the ________ of a Query window.

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

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?

Which of the following is not true about primary keys?

Which of the following cannot be done using the CONSTRAINT phrase?

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

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

When using SQL to create a table,specifying a data type of Char(10)indicates a fixed length field of 10 characters.

Which of the following is not one of the five SQL built-in functions?

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Table and relationship properties not supported by Microsoft Access SQL can usually be set ________ in the appropriate window or dialog box.

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

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

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

In Microsoft Access,the default method of creating and running a query is ________.

The values of existing data can be removed from a table using the SQL ________ command,which can even be used to remove all the data in the table at one time.

In SQL,the WHERE clause is used to specify which columns will be included in the result.

Which of the following standard SQL data types is not supported in Microsoft Access SQL?

Given the tables STUDENT(StudentID,StudentName,AdvisorID) ADVISOR(AdvisorID,AdvisorName,Office,Phone) Which of the following SQL statements would be used to implant a join between the two tables?

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

Microsoft Access SQL commands are run in the ________ of a Query window.

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

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?

Which of the following is not true about primary keys?

Which of the following cannot be done using the CONSTRAINT phrase?

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