Question 1

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

Question 2

In Oracle, the function converts a date to a character string.

Accepted Answer

A)   CONVERT() 
B)   TO_DATE
C)   TO_CHAR() 
D)   TO_STRING() E) C) and D)
F) All of the above

Question 3

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

Accepted Answer

A) True 
 B)False  False

Question 4

A trigger is executed as part of the transaction that triggered it.

Accepted Answer

A) True 
 B)False

Question 5

The PL/SQL block starts with the section.

Accepted Answer

A)   IS
B)   OPEN
C)   DECLARE
D)   BEGINE) All of the above
F) B) and D)

Question 6

In the context of SELECT subquery types, a is returned when an UPDATE subquery is used.

Accepted Answer

A)   NULL
B)   single value
C)   list of values
D)   virtual tableE) C) and D)
F) A) and B)

Question 7

The ANSI standard defines type(s)  of outer join(s)

Accepted Answer

A)   one
B)   two
C)   three
D)   fourE) A) and C)
F) B) and C)

Question 8

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

Accepted Answer

A) True 
 B)False

Question 9

In Oracle, make(s)  it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE) , basic loops (FOR and WHILE loops,)  and error trapping.

Accepted Answer

A)   cursor-style processing
B)   stored procedures
C)   embedded SQL
D)   Procedural Language SQLE) A) and B)
F) A) and C)

Question 10

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

Question 11

The syntax of the MINUS statement in Oracle is .

Accepted Answer

query MINUS query

Question 12

The statement SELECT * FROM T1, T2 produces a(n)  join.

Accepted Answer

A)   cross
B)   natural
C)   equi-
D)   fullE) A) and C)
F) A) and B)

Question 13

A persistent stored module is stored and executed on the database client machine.

Accepted Answer

A) True 
 B)False  False

Question 14

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Accepted Answer

A) True 
 B)False

Question 15

The use of the operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

Accepted Answer

The answer of The use of the operator allows you...

Question 16

The data type is considered compatible with VARCHAR(35) .

Accepted Answer

A)   DATE
B)   INT
C)   TINYINT
D)   CHAR(15) E) A) and D)
F) B) and C)

Question 17

The pseudo-column is used to select the next value from a sequence.

Accepted Answer

A)   CURRVAL
B)   NEXTVAL
C)   NEXT
D)   GET_NEXTE) C) and D)
F) A) and B)

Question 18

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

Accepted Answer

A)   IN
B)   NOT IN
C)   AND
D)   UNIONE) A) and D)
F) All of the above

Question 19

In a subquery, the query is executed first.

Accepted Answer

A)   left
B)   right
C)   inner
D)   outerE) B) and C)
F) None of the above

Question 20

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

Accepted Answer

A) True 
 B)False

Exam 8: Advanced Sql

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

Correct AnswerverifiedA subquery can return one or more values...View AnswerShow Answer

In Oracle, the function converts a date to a character string.

Correct AnswerverifiedShow Answer

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

Correct AnswerverifiedFalse

A trigger is executed as part of the transaction that triggered it.

Correct AnswerverifiedShow Answer

The PL/SQL block starts with the section.

Correct AnswerverifiedShow Answer

In the context of SELECT subquery types, a is returned when an UPDATE subquery is used.

Correct AnswerverifiedShow Answer

The ANSI standard defines type(s) of outer join(s)

Correct AnswerverifiedShow Answer

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

Correct AnswerverifiedShow Answer

In Oracle, make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE) , basic loops (FOR and WHILE loops,) and error trapping.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The syntax of the MINUS statement in Oracle is .

Correct Answerverifiedquery MINUS query

The statement SELECT * FROM T1, T2 produces a(n) join.

Correct AnswerverifiedShow Answer

A persistent stored module is stored and executed on the database client machine.

Correct AnswerverifiedFalse

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Correct AnswerverifiedShow Answer

The use of the operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

Correct AnswerverifiedShow Answer

The data type is considered compatible with VARCHAR(35) .

Correct AnswerverifiedShow Answer

The pseudo-column is used to select the next value from a sequence.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a subquery, the query is executed first.

Correct AnswerverifiedShow Answer

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A subquery can return one or more values...
View Answer

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
query MINUS query

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified