does Oracle has only one table space?
Answer / oracledba
Oracle does not have one tablespace
Minimum tablespaces in Oracle are
SYSTEM,TEMP and UNDO - oracle 9i
SYSTEM,SYSAUX,TEMP and UNDO - oracle10g
| Is This Answer Correct ? | 6 Yes | 4 No |
What is a cursor variable?
How to recover a dropped index?
how to get the index id?
what is the scripts in data base?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
can you explain performance tunning in oracle(sql,PL/SQL)
Can we store pictures in the database and if so, how it can be done?
Explain self joins in oracle?
What are the common oracle dba tasks?
DBMS vs. RDBMS
Difference between oracle's plus (+) notation and ansi join notation?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?