Question 1

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

Question 2

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data types are Char,VarChar,Integer,and Numeric.The Char data type is for fixed-length character data.VarChar is for variable-length character data.Integer is for numeric data that are whole numbers only.Numeric is for numeric data that may include decimals.Char,VarChar,and Numeric must be qualified by a length specification to indicate the amount of storage space to be allocated for each data item.For example,Char(10)indicates fixed-length character data that is always stored as 10 characters.

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

Accepted Answer

A)  SELECT
B)  FROM
C)  WHERE
D)  ORDER BY
E)  GROUP BY

Question 5

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;

Question 6

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?

Accepted Answer

A)  DROP TABLE STUDENT;
B)  DELETE TABLE STUDENT;
C)  REMOVE TABLE STUDENT;
D)  SELECT * FROM STUDENT THEN DROP;
E)  DELETE FROM STUDENT;

Question 7

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.

Question 8

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 9

Given the table
$$\text { CUSTOMER(\underline{CustID}, Name, PhoneNumber, AccountBalance) }$$
write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Accepted Answer

The answer of Given the table
\[\text { CUSTOMER(\underline{CustID}, Name, PhoneNumber,...

Question 10

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 11

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

Question 12

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

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

Question 13

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

Accepted Answer

A) True 
 B)False

Question 14

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

Accepted Answer

The answer of The SQL keyword(s)________ mean(s)that a value must...

Question 15

An SQL data type of ________ would indicate a variable-length character string with maximum length 75.

Accepted Answer

The answer of An SQL data type of ________ would...

Question 16

Which of the following is not a standard data type used in SQL?

Accepted Answer

A)  Text
B)  Char
C)  Varchar
D)  Integer
E)  Numeric

Question 17

Given the tables $\text { STUDENT (\underline{SID}, StudentName, Major, AdvisorID) }$
$\text { ADVISOR (\underline{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

Question 18

Microsoft Access SQL allows table structures to be modified by using the standard SQL ________ command.

Accepted Answer

The answer of Microsoft Access SQL allows table structures to...

Question 19

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

Question 20

The values of existing data can be modified using the SQL ________ command,which can be used to change several column values at once.

Accepted Answer

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

Exam 3: Structured Query Language