Question 1

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Accepted Answer

A) True 
 B)False

Question 2

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

Accepted Answer

A) True 
 B)False

Question 3

If your integer values are relatively small, use ____________________ instead of INT.

Accepted Answer

The answer of If your integer values are relatively small,...

Question 4

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

% means any and all following or precedi...

Question 5

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 and the output is ordered by the price 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;ORDER BY P_PRICE;
B)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;ORDER BY P_PRICE;
C)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE ORDER BY P_PRICE;
D)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;ORDER BY P_PRICE;E) All of the above
F) B) and D)

Question 6

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Accepted Answer

A)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE 
B)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = [1558-QW1]
C)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = (1558-QW1) 
D)   SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = {1558-QW1}E) C) and D)
F) B) and D)

Question 7

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 8

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

Accepted Answer

The answer of If you add a new column to...

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

Question 10

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

Accepted Answer

A)   COUNT
B)   MIN
C)   MAX
D)   SUME) A) and D)
F) A) and C)

Question 11

The basic SQL vocabulary has fewer than ____________________ words.

Accepted Answer

100
one hu...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

U.S. state abbreviations are always two characters, so ____________________(2) is a logical choice for the data type representing a state column.

Accepted Answer

The answer of U.S. state abbreviations are always two characters,...

Question 15

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 16

What command is used to save changes to the database? What is the syntax for this command?

Accepted Answer

Any changes made to the table contents a...

Question 17

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

Accepted Answer

A) True 
 B)False

Question 18

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 19

A table can be deleted from the database by using the ____________________ command.

Accepted Answer

The answer of A table can be deleted from the...

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Beginning Structured Query Language Sql

All SQL commands must be issued on a single line.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

Correct AnswerverifiedShow Answer

U.S. state abbreviations are always two characters, so ____________________(2) is a logical choice for the data type representing a state column.

Correct AnswerverifiedShow Answer

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

Correct AnswerverifiedShow Answer

If your integer values are relatively small, use ____________________ instead of INT.

Correct AnswerverifiedShow Answer

What command is used to save changes to the database? What is the syntax for this command?

Correct AnswerverifiedAny changes made to the table contents a...View AnswerShow Answer

Most SQL implementations yield case-insensitive searches.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Correct Answerverified% means any and all following or precedi...View AnswerShow Answer

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table can be deleted from the database by using the ____________________ command.

Correct AnswerverifiedShow Answer

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

Correct AnswerverifiedShow Answer

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

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 and the output is ordered by the price is ____.

Correct AnswerverifiedShow Answer

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The basic SQL vocabulary has fewer than ____________________ words.

Correct Answerverified100one hu...View AnswerShow Answer

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Any changes made to the table contents a...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
% means any and all following or precedi...
View 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
100
one hu...
View Answer

Correct Answer
verified