Answer Posted / joe
4 different types of index
1.Clustered
2.Non Clustered
3.Primary XML
4.Spatial
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
List out the components of logical database structure of oracle database.
Is a rollback possible to any savepoint?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain implicit cursor.
How do I start tns listener?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is a private synonym?
How to omit columns with default values in insert statement in oracle?
Explain the use of file option in exp command.
How to fetch the row which has the max value for a column?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What's dateware house and what's clustor with practicle example
How do we represent comments in oracle?
What is ADDM Advisor in Oracle?