| |
71. Which Line In The Following Statement Will Produce An Error?
Date Posted: 07/03/2012
Ans:
1.Cursor action_cursor is
2. Select name, rate, action
3. Into action_record
4. from action_table;
5. There are no errors in this statement.
|
| |
| |
72. The Command Used To Open A CURSOR FOR Loop Is
Date Posted: 07/03/2012
Ans:
1.Open
2. Fetch
3. Parse
4. None, cursor for loops handle cursor opening implicitly.
|
| |
| |
73. What Happens When Rows Are Found Using A FETCH Statement
Date Posted: 07/03/2012
Ans:
1.It causes the cursor to close
2. It causes the cursor to open
3. It loads the current row values into variables
4. It creates the variables to hold the current row values
|
| |
| |
74. Under Which Circumstance Must You Recompile The Package Body After Recompiling The Package Specification?
Date Posted: 07/03/2012
Ans:
1.Altering the argument list of one of the package constructs
2. Any change made to one of the package constructs
3. Any SQL statement change made to one of the package constructs
4. Removing a local variable from the DECLARE section of one of the package constructs
|
| |
| |
75. Procedure And Functions Are Explicitly Executed. This Is Different From A Database Trigger. When Is A Database Trigger Executed?
Date Posted: 07/03/2012
Ans:
1.When the transaction is committed
2. During the data manipulation statement
3. When an Oracle supplied package references the trigger
4. During a data manipulation statement and when the transaction is committed
|
| |
| |
76. Which Oracle Supplied Package Can You Use To Output Values And Messages From Database Triggers, Stored Procedures And Functions Within SQL*Plus?
Date Posted: 07/03/2012
Ans:
1.DBMS_DISPLAY
2. DBMS_OUTPUT
3. DBMS_LIST
4. DBMS_DESCRIBE
|
| |
| |
77. What Is An Integrity Constraint?
Date Posted: 07/03/2012
Ans: Integrity constraint is a rule that restricts values to a column in a table.
|
| |
| |
78. What Is Referential Integrity Constraint?
Date Posted: 07/03/2012
Ans: Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table.
|
| |
| |
79. What Is The Usage Of SAVEPOINTS?
Date Posted: 07/03/2012
Ans: SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.
|
| |
| |
80. What Is ON DELETE CASCADE?
Date Posted: 07/03/2012
Ans: When ON DELETE CASCADE is specified oracle maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.
|
| |
