PL/SQL Quiz

1.What is the use of rollback segments?

Used to roll back a transaction
Both c and d
They can be used to recover the selected tables to a consistent state in case of failures
They ensure that transactions leave the uncommitted changes unnoticed

2. Which of the following SQL operations demands the use of wildcard comparisons?

IN
BETWEEN
EXISTS
LIKE

3. Where would you look for errors from the database engin?

In the error log
In the alter log
In the alert log
In the recovery log

4. A database trigger is an alternative for ?

Stored procedure
Primary key for implementing referential integrity
Foreign key for implementing referential integrity
All of the above

5.Which of the following statement is true?

Implicit cursors are not named
Implicit cursors must be developed by the database developers
Explicit cursors can handle tables with only 16 rows
Explicit cursors does not occupy Oracle’s memory space

6. How many different types of triggers can exists in a table in oracle?

10
12
15
16

7. A stored procedure only executed...

implicitly
when asked explicitly
when the trigger associated with it is also invoked
none of the above

8. Delete and truncate command in sql ?

retrieve rows in a table
remove some part of a table
remove all rows in a table
recover all the rows deleted in a table

9. A data block is ?

the place where all deleted records are persisted
the largest logical storage unit ever available for any database block
the smallest logical storage unit for a database object
all of the above

10. What command is used to encrypt a pl/sql application ?

DB_ENCRYPT
DBMS_ENCRYPT
DBMS_WRAP
WRAP

Please Enter your Mail ID:  (required) Show me the answer

Question 1: The correct answer is the Used to roll back a transaction.

Question 2: The correct answer is Like.

Question 3: The correct answer is In the error log.

Question 4: The correct answer is Stored Procedure.

Question 5: The correct answer is Implicit cursors are not named .

Question 6: The correct answer is 12.

Question 7: The correct answer is When Asked Explicitly.

Question 8: The correct answer is Removes all rows in a table.

Question 9: The correct answer is the smallest logical storage unit for a database object.

Question 10: The correct answer is WRAP.

You answered them all right!