Question 1

The SQL aggregate function that gives the number of rows containing non-null values for a given column is

Accepted Answer

A)   COUNT
B)   MIN
C)   MAX
D)   SUME) All of the above
F) A) and D)

Question 2

A(n)  is a query that is embedded (or nested)  inside another query.

Accepted Answer

A)   alias
B)   operator
C)   subquery
D)   viewE) B) and C)
F) A) and C)

Question 3

DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.

Accepted Answer

The answer of DATE() and SYSDATE are special functions that...

Question 4

Which 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 5

The command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Accepted Answer

The answer of The command, coupled with appropriate search conditions,...

Question 6

Which of the following queries 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_CODE FROM PRODUCT;
B)   SELECT UNIQUE V_CODE FROM PRODUCT;
C)   SELECT DIFFERENT V_CODE FROM PRODUCT;
D)   SELECT DISTINCT V_CODE FROM PRODUCT;E) A) and C)
F) C) and D)

Question 7

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 8

If integer values are relatively small, must be used instead of INT.

Accepted Answer

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

Question 9

Which of the following queries 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_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE 
B)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288;
C)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288;
D)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;E) None of the above
F) B) and C)

Question 10

Which of the following is used to select partial table contents?

Accepted Answer

A) SELECT FROM BY ; B) LIST FROM

BY ; C) SELECT FROM

WHERE ; D) LIST FROM

WHERE ;E) None of the above F) All of the above

Question 11

According to the rules of precedence, which of the following computations should be completed first?

Accepted Answer

A)   Performing additions and subtractions
B)   Performing multiplications and divisions
C)   Performing operations within parentheses
D)   Performing power operationsE) All of the above
F) B) and D)

Question 12

The specification is used to avoid having duplicated values in a column.

Accepted Answer

The answer of The specification is used to avoid having...

Question 13

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 14

The conditional LIKE must be used in conjunction with wildcard characters.

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

An alias is especially useful when a table must be joined to itself in a(n) query.

Accepted Answer

The answer of An alias is especially useful when a...

Question 17

The SQL command that allows a user to list the contents of a table is .

Accepted Answer

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

Question 18

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

To list all the contents of the PRODUCT table, a user would use .

Accepted Answer

A)   LIST * FROM PRODUCT
B)   SELECT * FROM PRODUCT
C)   DISPLAY * FROM PRODUCT
D)   SELECT ALL FROM PRODUCTE) A) and D)
F) C) and D)

Exam 7: Introduction to Structured Query Language Sql

Which 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

The SQL aggregate function that gives the number of rows containing non-null values for a given column is

Correct AnswerverifiedShow Answer

Which of the following is used to select partial table contents?

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

If integer values are relatively small, must be used instead of INT.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SQL command that allows a user to list the contents of a table is .

Correct AnswerverifiedShow Answer

Most SQL implementations yield case-insensitive searches.

Correct AnswerverifiedShow Answer

Which of the following queries 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

The conditional LIKE must be used in conjunction with wildcard characters.

Correct AnswerverifiedShow Answer

A(n) is a query that is embedded (or nested) inside another query.

Correct AnswerverifiedShow Answer

An alias is especially useful when a table must be joined to itself in a(n) query.

Correct AnswerverifiedShow Answer

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

Correct AnswerverifiedShow Answer

According to the rules of precedence, which of the following computations should be completed first?

Correct AnswerverifiedShow Answer

To list all the contents of the PRODUCT table, a user would use .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Correct AnswerverifiedShow Answer

DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.

Correct AnswerverifiedShow Answer

The specification is used to avoid having duplicated values in a column.

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

Correct Answer
verified
Any changes made to the table contents a...
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

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