Question 1

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE,and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

Accepted Answer

A)   SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONEFROM PRODUCT,VENDORWHERE PRODUCT.V_CODE  VENDOR.V_CODE;
B)   SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONEFROM PRODUCT,VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
C)   SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONEFROM PRODUCT,VENDORWHERE PRODUCT.V_CODE 
D)   SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONEFROM PRODUCT,VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;E) A) and B)
F) All of the above

Question 2

Only numeric data types can be added and subtracted in SQL.

Accepted Answer

A) True 
 B)False

Question 3

You can create a logical (virtual)table by using the MAKE VIEW command.

Accepted Answer

A) True 
 B)False

Question 4

A(n)____________________,also known as a nested query or an inner query,is a query that is embedded (or nested)inside another query.

Accepted Answer

The answer of A(n)____________________,also known as a nested query or...

Question 5

The SQL command that lets you insert rows into a table is ____.

Accepted Answer

A)   INSERT
B)   SELECT
C)   COMMIT
D)   UPDATEE) A) and B)
F) A) and C)

Question 6

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

Accepted Answer

The answer of The ____________________ clause of the GROUP BY...

Question 7

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False

Question 8

Oracle users can use the Access QBE (query by example)query generator.

Accepted Answer

A) True 
 B)False

Question 9

Using the ____________________ command,SQL indexes can be created on the basis of any selected attribute.

Accepted Answer

The answer of Using the ____________________ command,SQL indexes can be...

Question 10

SQL character data format(s) is(are) ____.

Accepted Answer

A)   CHAR and VARCHAR
B)   VARCHAR only
C)   Alphanumeric
D)   CHAR onlyE) A) and B)
F) A) and C)

Question 11

When joining three or more tables,you need to specify a join condition for one pair of tables.

Accepted Answer

A) True 
 B)False

Question 12

Data type selection is usually dictated by the nature of the data and by the intended use.

Accepted Answer

A) True 
 B)False

Question 13

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

Accepted Answer

The answer of Frequency distributions can be created quickly and...

Question 14

Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

Accepted Answer

A)   SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE 
B)   SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE => 24288
C)   SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE > 24288
D)   SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE = 24288E) C) and D)
F) None of the above

Question 15

Which query is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

Accepted Answer

A)   SELECT ONLY V_CODEFROM PRODUCT;
B)   SELECT UNIQUE V_CODEFROM PRODUCT;
C)   SELECT DIFFERENT V_CODEFROM PRODUCT;
D)   SELECT DISTINCT V_CODEFROM PRODUCT;E) None of the above
F) All of the above

Question 16

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

Accepted Answer

A)   SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONEFROM EMPLOYEELIST BY EMP_LNAME,EMP_FNAME,EMP_INITIAL;
B)   SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONEFROM EMPLOYEEORDER BY EMP_LNAME,EMP_FNAME,EMP_INITIAL;
C)   SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONEFROM EMPLOYEEDISPLAY BY EMP_LNAME,EMP_FNAME,EMP_INITIAL;
D)   SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONEFROM EMPLOYEESEQUENCE BY EMP_LNAME,EMP_FNAME,EMP_INITIAL;E) A) and B)
F) B) and C)

Question 17

A(n)____________________ character is a symbol that can be used as a general substitute for other characters or commands.

Accepted Answer

The answer of A(n)____________________ character is a symbol that can...

Question 18

The SQL command that lets you permanently save data changes is ____.

Accepted Answer

A)   INSERT
B)   SELECT
C)   COMMIT
D)   UPDATEE) B) and D)
F) A) and B)

Question 19

The special operator used to check for similar character strings is ____.

Accepted Answer

A)   BETWEEN
B)   IS NULL
C)   LIKE
D)   INE) B) and D)
F) None of the above

Question 20

You cannot insert a row containing a null attribute value using SQL.

Accepted Answer

A) True 
 B)False

Exam 7: Introduction to Structured Query Language (SQL)

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

Correct AnswerverifiedShow Answer

The ANSI SQL standards are also accepted by the ISO.

Correct AnswerverifiedShow Answer

You can create a logical (virtual)table by using the MAKE VIEW command.

Correct AnswerverifiedShow Answer

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

Correct AnswerverifiedShow Answer

Only numeric data types can be added and subtracted in SQL.

Correct AnswerverifiedShow Answer

The SQL command that lets you insert rows into a table is ____.

Correct AnswerverifiedShow Answer

A(n)____________________,also known as a nested query or an inner query,is a query that is embedded (or nested)inside another query.

Correct AnswerverifiedShow Answer

Which query is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

Correct AnswerverifiedShow Answer

SQL character data format(s) is(are) ____.

Correct AnswerverifiedShow Answer

The SQL command that lets you permanently save data changes is ____.

Correct AnswerverifiedShow Answer

The special operator used to check for similar character strings is ____.

Correct AnswerverifiedShow Answer

Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

Correct AnswerverifiedShow Answer

A(n)____________________ character is a symbol that can be used as a general substitute for other characters or commands.

Correct AnswerverifiedShow Answer

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

Correct AnswerverifiedShow Answer

Data type selection is usually dictated by the nature of the data and by the intended use.

Correct AnswerverifiedShow Answer

Using the ____________________ command,SQL indexes can be created on the basis of any selected attribute.

Correct AnswerverifiedShow Answer

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE,and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

Correct AnswerverifiedShow Answer

You cannot insert a row containing a null attribute value using SQL.

Correct AnswerverifiedShow Answer

When joining three or more tables,you need to specify a join condition for one pair of tables.

Correct AnswerverifiedShow Answer

Oracle users can use the Access QBE (query by example)query generator.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified