ORACLE INTERVIEW QUESTION & ANSWERS
| 86. |
What are the features of Oracle 9i? |
| |
Oracle 9i improves the following technical aspects - Database performance
- Ease of management
- Scalability
- Security
- Availability
- Windows 2000 integration and application areas
- Internet content management
- E–commerce integration
- Packaged applications
- Business Intelligence
|
| 87. |
When should the trigger fire? |
| |
|
| 88. |
Which DML statement causes the trigger to execute? |
| |
DML statement causes the trigger to execute are : - Insert
- Update
- Delete
|
| 89. |
What is ROWID? |
| |
- ROWID is a pseudo column attached to each row of a table.
- It is 18 characters long, blockno, row number are the components of ROWID.
|
| 90. |
What are the types of tables in oracle database? |
| |
Oracle Database 10g supports many different types of tables.- Relational Table
- Object Table
- Temporary Table
- Index–Organized Table
- Cluster
- External Table
- XMLType Table
- Partitioned Table
|
