Question 1

In SQL, all _____ expressions evaluate to true or false.

Accepted Answer

The answer of In SQL, all _____ expressions evaluate to...

Question 2

Comparison operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Question 3

A(n)  _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns)  but also the rows with unmatched values.

Accepted Answer

A)   outer
B)   inner
C)   equi-
D)   crossE) C) and D)
F) B) and D)

Question 4

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

Accepted Answer

The answer of "_____" means that the names of the...

Question 5

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

Accepted Answer

The answer of A specialty field in mathematics, known as...

Question 6

In subquery terminology, the first query in the SQL statement is known as the _____ query.

Accepted Answer

A)   outer
B)   left
C)   inner
D)   baseE) All of the above
F) B) and C)

Question 7

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False

Question 8

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Accepted Answer

A)   NVL
B)   TO_CHAR
C)   DECODE
D)   CONVERTE) All of the above
F) A) and D)

Question 9

The syntax for a left outer join is _____.

Accepted Answer

A)   SELECT     column-listFROM        table1 OUTER JOIN table2 LEFTWHERE     join-condition
B)   SELECT     column-listFROM table1 LEFT [OUTER] JOIN table2ON join-condition
C)   SELECT     column-listWHERE     LEFT table1 = table
D)   SELECT    column-listFROM       table1 LEFT table2 [JOIN]WHERE     join-conditionE) C) and D)
F) None of the above

Question 10

What is a subquery? What is always executed first?

Accepted Answer

A subquery, also known as a ne...

Question 11

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

Accepted Answer

A)   MON
B)   MM3
C)   MONTH
D)   MME) None of the above
F) All of the above

Question 12

The basic SQL vocabulary has fewer than _____words.

Accepted Answer

100
one hu...

Question 13

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 14

Which comparison operator indicates a value isnot equal?

Accepted Answer

A)   
B)   
C)   >=
D)   E) C) and D)
F) B) and C)

Question 15

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 16

Which is a feature of a correlated subquery?

Accepted Answer

A)   The inner subquery executes first.
B)   The outer subquery initiates the process of execution in a subquery.
C)   The inner subquery initiates the process of execution in a subquery.
D)   The outer subquery executes independent of the inner subquery.E) A) and D)
F) B) and D)

Question 17

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

Question 18

_____ is a relational set operator.

Accepted Answer

A)   EXCEPT
B)   PLUS
C)   ALL
D)   EXISTSE) A) and B)
F) A) and C)

Question 19

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

Accepted Answer

The LIKE special operator is used in con...

Question 20

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Accepted Answer

A) True 
 B)False

Exam 7: Introduction to Structured Query Language Sql

In SQL, all _____ expressions evaluate to true or false.

Correct AnswerverifiedShow Answer

Which comparison operator indicates a value isnot equal?

Correct AnswerverifiedShow Answer

What is a subquery? What is always executed first?

Correct AnswerverifiedA subquery, also known as a ne...View AnswerShow Answer

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

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

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

Correct AnswerverifiedShow Answer

The syntax for a left outer join is _____.

Correct AnswerverifiedShow Answer

The basic SQL vocabulary has fewer than _____words.

Correct Answerverified100one hu...View AnswerShow Answer

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Correct AnswerverifiedShow Answer

The ANSI SQL standards are also accepted by the ISO.

Correct AnswerverifiedShow Answer

All SQL commands must be issued on a single line.

Correct AnswerverifiedShow Answer

Comparison operators cannot be used to place restrictions on character-based attributes.

Correct AnswerverifiedShow Answer

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Correct AnswerverifiedShow Answer

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

Correct AnswerverifiedShow Answer

Which is a feature of a correlated subquery?

Correct AnswerverifiedShow Answer

_____ is a relational set operator.

Correct AnswerverifiedShow Answer

In subquery terminology, the first query in the SQL statement is known as the _____ query.

Correct AnswerverifiedShow Answer

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

Correct AnswerverifiedShow Answer

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe LIKE special operator is used in con...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A subquery, also known as a ne...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
100
one hu...
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
The LIKE special operator is used in con...
View Answer