Question 1

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

Accepted Answer

Triggers can be used to enforce constrai

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() 
A)  CONVERT() 
B)  TO_DATE 
C)  TO_CHAR() 
D)  TO_STRING()

Question 3

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

Accepted Answer

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

Question 4

A(n)____________________ join returns the Cartesian product JOIN of T1 and T2 and is sometimes called "old style".

Accepted Answer

The answer of A(n)____________________ join returns the Cartesian product JOIN...

Question 5

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 6

One of the disadvantages of stored procedures is that they increase network traffic.

Accepted Answer

A) True 
 B)False

Question 7

In a subquery,the ____ query is executed first.

Accepted Answer

A)  left 
B)  right 
C)  inner 
D)  outer 
A)  left 
B)  right 
C)  inner 
D)  outer

Question 8

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

Accepted Answer

A)  DATE 
B)  INT 
C)  TINYINT 
D)  CHAR(15) 
A)  DATE 
B)  INT 
C)  TINYINT 
D)  CHAR(15)

Question 9

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 10

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 11

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 12

A stored function is another name for a stored procedure.

Accepted Answer

A) True 
 B)False

Question 13

Every PL/SQL block must be given a name.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Cursors are held in a reserved memory area in the client computer.

Accepted Answer

A) True 
 B)False

Question 16

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

Accepted Answer

A) True 
 B)False

Question 17

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 18

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Accepted Answer

The answer of The ____________________ clause is used to restrict...

Question 19

The ____________________ 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

The answer of The ____________________ function compares an attribute or...

Question 20

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

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

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

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

A(n)____________________ join returns the Cartesian product JOIN of T1 and T2 and is sometimes called "old style".

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

One of the disadvantages of stored procedures is that they increase network traffic.

In a subquery,the ____ query is executed first.

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

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

The Oracle ____ function returns the current date.

A stored function is another name for a stored procedure.

Every PL/SQL block must be given a name.

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

Cursors are held in a reserved memory area in the client computer.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

The syntax for a left outer join is ____.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

The ____________________ 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 syntax for the UNION query is ____.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 8: Advanced SQL

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

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

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

A(n)____________________ join returns the Cartesian product JOIN of T1 and T2 and is sometimes called "old style".

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

One of the disadvantages of stored procedures is that they increase network traffic.

In a subquery,the ____ query is executed first.

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

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

The Oracle ____ function returns the current date.

A stored function is another name for a stored procedure.

Every PL/SQL block must be given a name.

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

Cursors are held in a reserved memory area in the client computer.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

The syntax for a left outer join is ____.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

The ____________________ 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 syntax for the UNION query is ____.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters