ORACLE INTERVIEW QUESTION & ANSWERS
| 61. |
Can you have more than one instance on a system? |
| |
Yes, the Oracle RDBMS supports more than one instance running on a server. |
| 62. |
What tool is used to modify the state of the system? |
| |
The system state can be modified via the ALTER SYSTEM command. |
| 63. |
What are the types of oracle segments? |
| |
An Oracle database can use four types of segments : - Data segment
- Index segment
- Rollback segment
- Temporary segment
|
| 64. |
How to define tuble variables? |
| |
Tuble variables are defined in the from clause by the way of as clause.
|
| 65. |
What two accounts are created by default when a database is created? |
| |
When a database is created, the SYS and SYSTEM accounts are automatically created. |
