Question 1

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

Accepted Answer

A)   Additions and subtractions
B)   Multiplications and divisions
C)   Operations within parentheses
D)   Power operationsE) A) and D)
F) B) and C)

Question 2

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) B) and C)
F) A) and D)

Question 3

A(n)  _____ join performs a relational product (also known as the Cartesian product)  of two tables.

Accepted Answer

A)   full
B)   cross
C)   natural
D)   equi-E) B) and D)
F) C) and D) B

Question 4

The SQL data manipulation command HAVING:

Accepted Answer

A)   restricts the selection of rows based on a conditional expression.
B)   restricts the selection of grouped rows based on a condition.
C)   modifies an attribute's values in one or more table's rows.
D)   groups the selected rows based on one or more attributes.E) A) and D)
F) A) and C)

Question 5

What type of command does this SQL statement use?

Accepted Answer

A)   set operator
B)   natural join
C)   "old-style" join
D)   procedural statementE) A) and B)
F) A) and C)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The SQL command that allows a user to permanently save data changes is _____.

Accepted Answer

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

Question 8

The _____statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Accepted Answer

The answer of The _____statement in SQL combines rows from...

Question 9

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

Accepted Answer

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

Question 10

The syntax of theEXCEPT statement in Oracle is _____.

Accepted Answer

The answer of The syntax of theEXCEPT statement in Oracle...

Question 11

What are the four different types of results that can be returned from a subquery?

Accepted Answer

A subquery can return one or more values.
One single value (one column and one row):
This subquery is used anywhere a single value is expected, as in the right side of a comparison expression.An example is the preceding UPDATE subquery, in which an average price is assigned to the product's price.When a value is assigned to an attribute, a single value is assigned and not a list of them.Therefore, the subquery must return only one value (one column, one row).If the query returns multiple values, the DBMS generates an error.
A list of values (one column and multiple rows):
This type of subquery is used anywhere a list of values is expected, such as when using the IN clause-for example, when comparing the vendor code to a list of vendors.Again, in this case, there is only one column of data with multiple value instances.This type of subquery is used frequently in combination with the IN operator in a WHERE conditional expression.
A virtual table (multicolumn, multirow set of values):
This type of subquery can be used anywhere a table is expected, such as when using the FROM clause.
The fourth result that a subquery can return is no value at all.It is called NULL.

Question 12

The _____ command restricts the selection of grouped rows based on a condition.

Accepted Answer

A)   DISPLAY
B)   HAVING
C)   FROM
D)   CONVERTE) C) and D)
F) All of the above

Question 13

Explain the SQL function categories.

Accepted Answer

SQL functions fit into several broad cat...

Question 14

The _____ function returns the current system date in MS Access.

Accepted Answer

A)   TO_DATE() 
B)   SYSDATE() 
C)   DATE() 
D)   TODAY() E) B) and C)
F) All of the above

Question 15

The _____ operator could be used in place of INTERSECT if the DBMS does not support it.

Accepted Answer

The answer of The _____ operator could be used in...

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

A(n)  _____ is an alternate name given to a column or table in any SQL statement.

Accepted Answer

A)   alias
B)   data type
C)   stored function
D)   triggerE) A) and C)
F) All of the above

Question 18

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 19

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

Accepted Answer

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

Question 20

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Accepted Answer

A) True 
 B)False

Exam 7: Introduction to Structured Query Language Sql

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

Correct Answer
verified

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

Correct Answer
verified

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

Correct Answer
verified
B

The SQL data manipulation command HAVING:

Correct Answer
verified

What type of command does this SQL statement use?

Correct Answer
verified

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

Correct Answer
verified

The SQL command that allows a user to permanently save data changes is _____.

Correct Answer
verified
C

The _____statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Correct Answer
verified

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

Correct Answer
verified

The syntax of theEXCEPT statement in Oracle is _____.

Correct Answer
verified

What are the four different types of results that can be returned from a subquery?

The _____ command restricts the selection of grouped rows based on a condition.

Correct Answer
verified

Explain the SQL function categories.

Correct Answer
verified
SQL functions fit into several broad cat...
View Answer

The _____ function returns the current system date in MS Access.

Correct Answer
verified

The _____ operator could be used in place of INTERSECT if the DBMS does not support it.

Correct Answer
verified

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

Correct Answer
verified

A(n) _____ is an alternate name given to a column or table in any SQL statement.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Correct Answer
verified

Exam 7: Introduction to Structured Query Language Sql

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

Correct AnswerverifiedB

The SQL data manipulation command HAVING:

Correct AnswerverifiedShow Answer

What type of command does this SQL statement use?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SQL command that allows a user to permanently save data changes is _____.

Correct AnswerverifiedC

The _____statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The syntax of theEXCEPT statement in Oracle is _____.

Correct AnswerverifiedShow Answer

What are the four different types of results that can be returned from a subquery?

The _____ command restricts the selection of grouped rows based on a condition.

Correct AnswerverifiedShow Answer

Explain the SQL function categories.

Correct AnswerverifiedSQL functions fit into several broad cat...View AnswerShow Answer

The _____ function returns the current system date in MS Access.

Correct AnswerverifiedShow Answer

The _____ operator could be used in place of INTERSECT if the DBMS does not support it.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n) _____ is an alternate name given to a column or table in any SQL statement.

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 _____ specification is used to avoid having duplicated values in a column.

Correct AnswerverifiedShow Answer

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
SQL functions fit into several broad cat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified