Question 1

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

Question 2

A(n) ____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

Accepted Answer

The answer of A(n) ____________________ join returns all rows with...

Question 3

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

Accepted Answer

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

Question 4

Triggers can only be used to update table values.

Accepted Answer

A) True 
 B)False

Question 5

The syntax for the UNION query is ____.

Accepted Answer

A)   query + query
B)   UNION (query, query) 
C)   UNION: query query
D)   query UNION queryE) B) and D)
F) B) and C)

Question 6

The ____ data type is compatible with NUMBER.

Accepted Answer

A)   VARCHAR(15) 
B)   SMALLINT
C)   DATE
D)   CHAR(10) E) C) and D)
F) B) and D)

Question 7

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

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

A)   UNION
B)   UNION ALL
C)   INTERSECT
D)   MINUSE) All of the above
F) B) and C)

Question 9

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

Accepted Answer

A)   IN
B)   NOT IN
C)   AND
D)   UNIONE) A) and C)
F) A) and B)

Question 10

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

Accepted Answer

A)   CURRVAL
B)   NEXTVAL
C)   NEXT
D)   GET_NEXTE) None of the above
F) B) and C)

Question 11

When using the Oracle TO_NUMBER function to convert a character string into a number, ____ represents a digit.

Accepted Answer

A)   0
B)   9
C)   $
D)   #E) All of the above
F) B) and C)

Question 12

The ____ query combines rows from two queries and excludes duplicates.

Accepted Answer

A)   UNION
B)   UNION ALL
C)   INTERSECT
D)   MINUSE) A) and D)
F) None of the above

Question 13

When using a(n)  ____ join, only rows that meet the given criteria are returned.

Accepted Answer

A)   full
B)   inner
C)   outer
D)   setE) None of the above
F) B) and C)

Question 14

A(n) ____________________ routine pools multiple transactions into a single batch to update a master table field in a single operation.

Accepted Answer

The answer of A(n) ____________________ routine pools multiple transactions into...

Question 15

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

Question 16

Oracle recommends ____ for creating audit logs.

Accepted Answer

A)   triggers
B)   stored procedures
C)   stored functions
D)   tablesE) C) and D)
F) B) and C)

Question 17

If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n)  ____ clause.

Accepted Answer

A)   OF
B)   USING
C)   HAS
D)   JOIN ONE) B) and C)
F) A) and B)

Question 18

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Accepted Answer

A) True 
 B)False

Question 19

To test a trigger, you should use the EXECUTE TRIGGER command.

Accepted Answer

A) True 
 B)False

Question 20

The Oracle ____ function returns the current date.

Accepted Answer

A)   DATE
B)   SYSDATE
C)   CURRENT_DATE
D)   TO_DATEE) A) and B)
F) None of the above

Exam 6: Procedural Language Sql and Advanced Sql

A(n) ____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

Correct AnswerverifiedShow Answer

A(n) ____________________ routine pools multiple transactions into a single batch to update a master table field in a single operation.

Correct AnswerverifiedShow Answer

The ____ query combines rows from two queries and excludes duplicates.

Correct AnswerverifiedShow Answer

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Correct AnswerverifiedShow Answer

To test a trigger, you should use the EXECUTE TRIGGER command.

Correct AnswerverifiedShow Answer

Oracle recommends ____ for creating audit logs.

Correct AnswerverifiedShow Answer

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

When using a(n) ____ join, only rows that meet the given criteria are returned.

Correct AnswerverifiedShow Answer

The Oracle ____ function returns the current date.

Correct AnswerverifiedShow Answer

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

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 INTERSECT if the RDBMS does not support it.

Correct AnswerverifiedShow Answer

The ____ data type is compatible with NUMBER.

Correct AnswerverifiedShow Answer

The syntax for the UNION query is ____.

Correct AnswerverifiedShow Answer

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Correct AnswerverifiedShow Answer

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

When using the Oracle TO_NUMBER function to convert a character string into a number, ____ represents a digit.

Correct AnswerverifiedShow Answer

If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) ____ clause.

Correct AnswerverifiedShow Answer

Triggers can only be used to update table values.

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

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

Correct Answer
verified