Which of the following is not a database object
TABLESPACE
TABLE
INDEX
NONE
- 1 Answers
- 10373 Views
- I also Faced
- E-Mail Answers
When do you get a .pll extension in oracle? Explain its importance
What is snapshot is too old? Give and example for better understand.
Explain the use of indexes option in exp command.
why dont we assign not null constraint as table level constraint.
How to drop a stored function?
What is oracle database client?
Can multiple cursors being opened at the same time?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to insert a new row into a table in oracle?
Why is oracle so popular?
what is the output of select * from emp where null=null & select * from emp where 1=1
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
Oracle General 
