Can we create more than one index on particular column?
Answer / guest
No
But we can create composite index including that particular
column with other columns.
| Is This Answer Correct ? | 5 Yes | 3 No |
What is Virtual Private Database in Oracle?
What are the basic element of Base configuration of an oracle Database ?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
11. Display the client number and name and the client number and name of the person who referred that client.
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
IS it possible to built the oracle database without setting the kernal parameters?
What is a shared pool?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is instant client oracle?
What is a Temporary Segment ?
How to use "in out" parameter properly?