Question 1

Just like database triggers, stored procedures are stored in the database.

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

Accepted Answer

The answer of The ____________________ statement can be used to...

Question 3

You can declare variables inside a stored procedure.

Accepted Answer

A) True 
 B)False

Question 4

The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

Accepted Answer

A)  auto-number 
B)  sequence 
C)  TO_NUMBER function 
D)  trigger 
A)  auto-number 
B)  sequence 
C)  TO_NUMBER function 
D)  trigger

Question 5

Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator?

Accepted Answer

A)  7 
B)  10 
C)  15 
D)  17 
A)  7 
B)  10 
C)  15 
D)  17

Question 6

Each statement inside the PL/SQL code must end with a period (".").

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  TO_DATE() 
B)  SYSDATE() 
C)  DATE() 
D)  TODAY() 
A)  TO_DATE() 
B)  SYSDATE() 
C)  DATE() 
D)  TODAY()

Question 8

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

Accepted Answer

A) True 
 B)False

Question 9

The syntax for a left outer join is ____.

Accepted Answer

A)  SELECT column-list
FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition 
B)  SELECT column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C)  SELECT column-list
WHERE LEFT table1 = table 2 
D)  SELECT column-list
FROM table1 LEFT table2 [JOIN]
WHERE join-condition 
A)  SELECT column-list
FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition 
B)  SELECT column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C)  SELECT column-list
WHERE LEFT table1 = table 2 
D)  SELECT column-list
FROM table1 LEFT table2 [JOIN]
WHERE join-condition

Question 10

"Union-compatible" means that the ____.

Accepted Answer

A)  names of the relation attributes can be different, but the data types must be alike 
B)  names of the relation attributes must be the same, but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be alike 
D)  number of attributes must be the same, but the names and data types can be different 
A)  names of the relation attributes can be different, but the data types must be alike 
B)  names of the relation attributes must be the same, but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be alike 
D)  number of attributes must be the same, but the names and data types can be different

Question 11

A(n) ____________________ subquery is a subquery that executes once for each row in the outer query.

Accepted Answer

The answer of A(n) ____________________ subquery is a subquery that...

Question 12

____ is a relational set operator.

Accepted Answer

A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS 
A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS

Question 13

Every PL/SQL block must be given a name.

Accepted Answer

A) True 
 B)False

Question 14

A ____ is a query (SELECT statement) inside a query.

Accepted Answer

A)  subquery 
B)  range query 
C)  join 
D)  set query 
A)  subquery 
B)  range query 
C)  join 
D)  set query

Question 15

A(n) ____ join will select only the rows with matching values in the common attribute(s).

Accepted Answer

A)  natural 
B)  cross 
C)  full 
D)  outer 
A)  natural 
B)  cross 
C)  full 
D)  outer

Question 16

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

Accepted Answer

A) True 
 B)False

Question 17

Explain the different basic types of join operations. What are they and how do they work?

Accepted Answer

Join operations can be classified as inn

Question 18

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

Accepted Answer

A)  cross 
B)  natural 
C)  equi- 
D)  full 
A)  cross 
B)  natural 
C)  equi- 
D)  full

Question 19

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)  CONVERT 
A)  NVL 
B)  TO_CHAR 
C)  DECODE 
D)  CONVERT

Question 20

The ____________________ statement combines rows from two or more queries without including duplicate rows.

Accepted Answer

The answer of The ____________________ statement combines rows from two...

Just like database triggers, stored procedures are stored in the database.

The ____________________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

You can declare variables inside a stored procedure.

The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

Each statement inside the PL/SQL code must end with a period (".").

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

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

The syntax for a left outer join is ____.

"Union-compatible" means that the ____.

A(n) ____________________ subquery is a subquery that executes once for each row in the outer query.

____ is a relational set operator.

Every PL/SQL block must be given a name.

A ____ is a query (SELECT statement) inside a query.

A(n) ____ join will select only the rows with matching values in the common attribute(s).

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

Explain the different basic types of join operations. What are they and how do they work?

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

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.

The ____________________ statement combines rows from two or more queries without including duplicate rows.

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

Just like database triggers, stored procedures are stored in the database.

The ____________________ statement can be used to combine rows from two queries, returning only the rows that appear in both sets.

You can declare variables inside a stored procedure.

The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

Each statement inside the PL/SQL code must end with a period (".").

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

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

The syntax for a left outer join is ____.

"Union-compatible" means that the ____.

A(n) ____________________ subquery is a subquery that executes once for each row in the outer query.

____ is a relational set operator.

Every PL/SQL block must be given a name.

A ____ is a query (SELECT statement) inside a query.

A(n) ____ join will select only the rows with matching values in the common attribute(s).

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

Explain the different basic types of join operations. What are they and how do they work?

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

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.

The ____________________ statement combines rows from two or more queries without including duplicate rows.

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