Question 1

A query that uses the ____ set operator joins the output of two unrelated queries into a single output result.

Accepted Answer

A) INTERSECT 
B) DIFFERENCE 
C) MERGE 
D) UNION 
A) INTERSECT 
B) DIFFERENCE 
C) MERGE 
D) UNION D

Question 2

To place a search condition on the results of queries that display group function calculations use the ____________________ clause.

Accepted Answer

HAVING

Question 3

Explain how Oracle uses transactions to shield users from changes that may be rolled back.

Accepted Answer

The purpose of transaction processing is to enable every user to see a consistent view of the database.To achieve this consistency,a user cannot view or update data values that are part of another user's uncommitted transactions because these uncommitted transactions,which are called pending transactions,might be rolled back.The Oracle DBMS implements transaction processing by locking data rows associated with pending transactions.When the DBMS locks a row,other users cannot view or modify the row.When the user commits the transaction,the DBMS releases the locks on the rows,and other users can view and update the rows again.

Question 4

To delete table data without saving rollback information,use the ____________________ command.

Accepted Answer

The answer of To delete table data without saving rollback...

Question 5

What will happen when the following query is executed: UPDATE student
SET s_class='SR';

Accepted Answer

A) All records in the student table will be updated 
B) No records in the student table will be updated 
C) An error will occur 
D) The first record in the student table will be updated 
A) All records in the student table will be updated 
B) No records in the student table will be updated 
C) An error will occur 
D) The first record in the student table will be updated

Question 6

You must use the GROUP BY clause in a query if you are using a group function.

Accepted Answer

A) True 
 B)False

Question 7

The format model to display a four digit year (e.g. ,2005)is ____________________.

Accepted Answer

The answer of The format model to display a four...

Question 8

How would you select the current value of the sequence s_id_seq?

Accepted Answer

A) DISPLAY s_id_seq.CURRVAL; 
B) SELECT s_id_seq.CURRVAL; 
C) SELECT s_id_seq.CURRVAL FROM DUAL; 
D) SHOW s_id_seq.CURRVAL 
A) DISPLAY s_id_seq.CURRVAL; 
B) SELECT s_id_seq.CURRVAL; 
C) SELECT s_id_seq.CURRVAL FROM DUAL; 
D) SHOW s_id_seq.CURRVAL

Question 9

A(n)____________________ is a structure that contains information that identifies the LOB data type and points to the alternate memory location.

Accepted Answer

The answer of A(n)____________________ is a structure that contains information...

Question 10

The operator ^= indicates not equal.

Accepted Answer

A) True 
 B)False

Question 11

How does Oracle prevent other users from modifying data that has been changed in a pending transaction?

Accepted Answer

A) The records are locked 
B) The records are marked as dirty 
C) The records are not available 
D) There is nothing to prevent another user from modifying the records 
A) The records are locked 
B) The records are marked as dirty 
C) The records are not available 
D) There is nothing to prevent another user from modifying the records

Question 12

To create a locator for a LOB column,use the ____ function.

Accepted Answer

A) make_blob() 
B) init_blob() 
C) new_blob() 
D) empty_blob() 
A) make_blob() 
B) init_blob() 
C) new_blob() 
D) empty_blob()

Question 13

When using a nested query,the main query is executed after the subquery.

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ function operates on character data and returns a string starting at the start position and of the specified length.

Accepted Answer

The answer of The ____________________ function operates on character data...

Question 15

Which statement would be used to select all students with more than one grade?

Accepted Answer

A) WHERE COUNT(grade)> 1 
B) WHERE COUNT(grade)>= 1 
C) HAVING COUNT(grade)> 1 
D) HAVING COUNT(grade)>= 1 
A) WHERE COUNT(grade)> 1 
B) WHERE COUNT(grade)>= 1 
C) HAVING COUNT(grade)> 1 
D) HAVING COUNT(grade)>= 1

Question 16

To match a null value use ____.

Accepted Answer

A)  NULL 
B) != NULL 
C) IS NULL 
D) IS 0 
A)  NULL 
B) != NULL 
C) IS NULL 
D) IS 0

Question 17

In a SQL query,the search condition begins with ____.

Accepted Answer

A) WHERE 
B) FROM 
C) BY 
D) COND 
A) WHERE 
B) FROM 
C) BY 
D) COND

Question 18

Which command is used to give a user permission to alter another user's table?

Accepted Answer

A) ADD 
B) GIVE 
C) GRANT 
D) ALTER 
A) ADD 
B) GIVE 
C) GRANT 
D) ALTER

Question 19

When you use the insert command,you must specify column names.

Accepted Answer

A) True 
 B)False

Question 20

If you omit the search condition in the delete query no record will be deleted.

Accepted Answer

A) True 
 B)False

A query that uses the ____ set operator joins the output of two unrelated queries into a single output result.

To place a search condition on the results of queries that display group function calculations use the ____________________ clause.

Explain how Oracle uses transactions to shield users from changes that may be rolled back.

To delete table data without saving rollback information,use the ____________________ command.

What will happen when the following query is executed: UPDATE student SET s_class='SR';

You must use the GROUP BY clause in a query if you are using a group function.

The format model to display a four digit year (e.g. ,2005)is ____________________.

How would you select the current value of the sequence s_id_seq?

A(n)____________________ is a structure that contains information that identifies the LOB data type and points to the alternate memory location.

The operator ^= indicates not equal.

How does Oracle prevent other users from modifying data that has been changed in a pending transaction?

To create a locator for a LOB column,use the ____ function.

When using a nested query,the main query is executed after the subquery.

The ____________________ function operates on character data and returns a string starting at the start position and of the specified length.

Which statement would be used to select all students with more than one grade?

To match a null value use ____.

In a SQL query,the search condition begins with ____.

Which command is used to give a user permission to alter another user's table?

When you use the insert command,you must specify column names.

If you omit the search condition in the delete query no record will be deleted.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 3: Using SQL Queries to Insert, update, delete, and View Data

A query that uses the ____ set operator joins the output of two unrelated queries into a single output result.

To place a search condition on the results of queries that display group function calculations use the ____________________ clause.

Explain how Oracle uses transactions to shield users from changes that may be rolled back.

To delete table data without saving rollback information,use the ____________________ command.

What will happen when the following query is executed: UPDATE student SET s_class='SR';

You must use the GROUP BY clause in a query if you are using a group function.

The format model to display a four digit year (e.g. ,2005)is ____________________.

How would you select the current value of the sequence s_id_seq?

A(n)____________________ is a structure that contains information that identifies the LOB data type and points to the alternate memory location.

The operator ^= indicates not equal.

How does Oracle prevent other users from modifying data that has been changed in a pending transaction?

To create a locator for a LOB column,use the ____ function.

When using a nested query,the main query is executed after the subquery.

The ____________________ function operates on character data and returns a string starting at the start position and of the specified length.

Which statement would be used to select all students with more than one grade?

To match a null value use ____.

In a SQL query,the search condition begins with ____.

Which command is used to give a user permission to alter another user's table?

When you use the insert command,you must specify column names.

If you omit the search condition in the delete query no record will be deleted.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters