What are the values that can be specified for OPTIMIZER
MODE Parameter ?
Answer Posted / guest
COST and RULE
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What happens if variable names collide with table/column names?
What are the different types of partitions in oracle?
How to connect to a local oracle 10g xe server?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is data block in Oracle?
What do you mean by cdb and pdb in oracle 12c?
What is an oracle tablespace?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is literal?
Give the constructs of a package, function or a procedure.
What is where clause in oracle?
Can we write dml statement in function in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is the difference between PFILE and SPFILE in Oracle?
Explain the truncate in oracle?