Question 1

Explain why it is important to learn SQL.

Accepted Answer

The answer of Explain why it is important to learn...

Question 2

SQL is a data sublanguage,not a complete programming language.

Accepted Answer

A) True 
 B)False

Question 3

What are SQL Built-in Functions?

Accepted Answer

The answer of What are SQL Built-in Functions?...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Microsoft Access SQL commands are run within the SQL View of a Query window.

Accepted Answer

A) True 
 B)False

Question 6

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

The answer of Explain the essential format of the CREATE...

Question 7

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Accepted Answer

A) True 
 B)False

Question 8

Given the table STUDENT(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');

Question 9

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 10

The result for SELECT statements in SQL is a relation unless the result is a single number.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Accepted Answer

A)  text(10) 
B)  char(10) 
C)  varchar(10) 
D)  fixed(10) 
E)  length(10)

Question 12

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

The answer of Explain how to run an SQL query...

Question 13

Explain two methods for defining a primary key using SQL.

Accepted Answer

The answer of Explain two methods for defining a primary...

Question 14

Discuss SQL data types.

Accepted Answer

The answer of Discuss SQL data types....

Question 15

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

Question 16

Compare and contrast subqueries and joins.

Accepted Answer

The answer of Compare and contrast subqueries and joins....

Question 17

Microsoft Access can run QBE queries,but not SQL queries.

Accepted Answer

A) True 
 B)False

Exam 3: Structured Query Language

Explain why it is important to learn SQL.

SQL is a data sublanguage,not a complete programming language.

What are SQL Built-in Functions?

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

Microsoft Access SQL commands are run within the SQL View of a Query window.

Explain the essential format of the CREATE TABLE statement.

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

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

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

The result for SELECT statements in SQL is a relation unless the result is a single number.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Explain how to run an SQL query in Microsoft Access.

Explain two methods for defining a primary key using SQL.

Discuss SQL data types.

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.

Compare and contrast subqueries and joins.

Microsoft Access can run QBE queries,but not SQL queries.