Answer Posted / sweta
Dual is like a dummy table which contains 1 column and 1 row
in this.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you record information about current session?
What is a correlated sub-query? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
who owns the operating system files created by the utl_file package?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Why would you use sql agent? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you connect from 10g user to 11g user??
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the difference between clustered and non-clustered index? : sql server DBA
Where would you look for errors from the database engine?
What is dbcc? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Query processing is slow(eg select query)how will u solve that