Sure Apps
Welcome
Home
Login/Register
FAQs
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Learn
Sql
Pl/Sql
Reports
Forms
Oracle Apps
Commands
Sql
Pl/Sql
Reports
Forms
Oracle Apps

Oracle Pl/Sql: Frequently Asked Questions

List all Questions.
1 pl/sql?
A. Procedural Language.

2 What background process refreshes materialized views?
A. Job Queue Processes

3 What is deadlock?
A. When an attempt has been made to update the data of a table on which already another data manipulation command has been issued, deadlock occurs.

4 What are mandatory parameters required while registering PL/SQL procedures with Oracle application as a concurrent Program?
A. 1.ERRBUF is used to return an error message.
2.RETCODE is used to return the error status.

5 What are the possible return status of the RETCODE parameter?
A. we do have 3 return statuses. They are:
0 Success
1 Warning
2 - Error

6 What is a Cursor?
A. SQL internal area to execute DML or DDL commands.

7 Can we use COMMIT or ROLLBACK in trigger?
A. No.

8 What is a pl/Sql Table?
A. Pl/Sql table is of the object type TABLE. it has single column and a primary key.

9 What is a materialized view?
A. It's a view based on a single or multiple table. But it is on aggregated data, like sum, similar group.

10 How many triggers we have in PL/sql?
A. twelve(12).

11 How many Event triggers we have? And What are they?
A. We have three(3) event triggers. They are INSERT, UPDATE and DELETE.

12 How many triggers are there based on the timing and what are there?
A. We have two triggers based on the timing. They are BEFORE and AFTER.

13 How many triggers can be written based on the level? And what are they?
A. We can have triggers at 2 levels. ROW and Statement level.

14 List the triggers with all the combinations of timing, event and level.
A. There are a total of 12 triggers.
1. BEFORE INSERT (ROW Level)
2. AFTER INSERT (ROW Level)
3. BEFORE DELETE (ROW Level)
4. AFTER DELETE (ROW Level)
5. BEFORE UPDATE (ROW Level)
6. AFTER UPDATE (ROW Level)
7. BEFORE INSERT (STATEMENT Level)
8. AFTER INSERT (STATEMENT Level)
9. BEFORE DELETE (STATEMENT Level)
10. AFTER DELETE (STATEMENT Level)
11. BEFORE UPDATE (STATEMENT Level)
12. AFTER UPDATE (STATEMENT Level)

15 Name few Psuedo columns
A. CURRVAL,
NEXTVAL,
ROWID,
ROWNUM,
LEVEL.

Click here for more...
Ask A Question
DisclaimerContact UsPrivacy Policy