ORACLE INTERVIEW QUESTION & ANSWERS
| 76. |
What is a Program Global Area[PGA]? |
| |
PGA is a memory buffer that contains data and control informations for a server process. |
| 77. |
Name the four main object privileges used in the Oracle Database lOg? |
| |
The four most common privileges are - Select
- Insert
- Update
- Delete
|
| 78. |
What is the difference between system and object privileges? |
| |
This statement when executed will display all the available system privileges such as Create Session, Drop User, Alter Database and so on. |
| 79. |
What is a system tablespace? |
| |
The System tablespace is used by the Oracle Database Engine to hold system information
such as :- Data dictionary
- Names and locations consist of :
- Tablespaces
- Tables
- Indexes
- Clusters
|
| 80. |
What is role? |
| |
A role is a set of group of privileges that can be granted to users or another role.
This is a great way for database administrators to save time and effort. |
