Can objects of the same schema reside in different tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
Please explain compound trigger in oracle?
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 ?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain user account with reference to oracle.
What are the uses of linked server and explain it in detail?
List the parts of a database trigger.
What are the attributes of the cursor?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to use windows user to connect to the server?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to create tables for odbc connection testing?
Why does Oracle not permit the use of PCTUSED with indexes?