Question 1

Triggers can only be used to update table values.

Accepted Answer

A) True 
 B)False

Question 2

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)  # 
A)  0 
B)  9 
C)  $ 
D)  #

Question 3

Oracle recommends ____ for creating audit logs.

Accepted Answer

A)  triggers 
B)  stored procedures 
C)  stored functions 
D)  tables 
A)  triggers 
B)  stored procedures 
C)  stored functions 
D)  tables

Question 4

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)  UNION 
A)  IN 
B)  OF 
C)  AND 
D)  UNION

Question 5

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

Accepted Answer

A)  CURRVAL 
B)  NEXTVAL 
C)  NEXT 
D)  GET_NEXT 
A)  CURRVAL 
B)  NEXTVAL 
C)  NEXT 
D)  GET_NEXT

Question 6

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

Accepted Answer

A)  full 
B)  inner 
C)  outer 
D)  set 
A)  full 
B)  inner 
C)  outer 
D)  set

Question 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS 
A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS

Question 11

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 ON 
A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON

Question 12

The Oracle ____ function returns the current date.

Accepted Answer

A)  DATE 
B)  SYSDATE 
C)  CURRENT_DATE 
D)  TO_DATE 
A)  DATE 
B)  SYSDATE 
C)  CURRENT_DATE 
D)  TO_DATE

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The syntax for the UNION query is ____.

Accepted Answer

A)  query + query 
B)  UNION (query, query) 
C)  UNION: query query 
D)  query UNION query 
A)  query + query 
B)  UNION (query, query) 
C)  UNION: query query 
D)  query UNION query

Question 15

The ____ data type is compatible with NUMBER.

Accepted Answer

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

Question 16

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)  MINUS 
A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS

Question 17

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)  UNION 
A)  IN 
B)  NOT IN 
C)  AND 
D)  UNION

Question 18

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)  cross 
A)  outer 
B)  inner 
C)  equi- 
D)  cross

Question 19

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 20

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

Triggers can only be used to update table values.

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

Oracle recommends ____ for creating audit logs.

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

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

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

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

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

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

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

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.

The Oracle ____ function returns the current date.

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

The syntax for the UNION query is ____.

The ____ data type is compatible with NUMBER.

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.

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

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.

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

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.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 6: Procedural Language Sql and Advanced Sql

Triggers can only be used to update table values.

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

Oracle recommends ____ for creating audit logs.

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

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

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

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

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

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

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

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.

The Oracle ____ function returns the current date.

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

The syntax for the UNION query is ____.

The ____ data type is compatible with NUMBER.

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.

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

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.

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

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.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters