Can objects of the same schema reside in different tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
What is a sub query? Describe its types?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
What are the different types of synonyms?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How would you design a database for an e-commerce website?
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.
What is a subquery?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to find no of saturdays in a month using single sql ?
How can I combine multiple rows into a comma-delimited list in oracle?
What is an oracle wallet?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com