Answer Posted / samir kumar sahoo
DROP object <object name>;
object means database object like table,index,view,sequence
etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the execution control statements?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the dml?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Give the various exception types.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Why do we need integrity constraints in a database?
How to create a new view in oracle?
Explain overloading. Can functions be overloaded?
What are the major difference between truncate and delete?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How do I call oracle stored procedures that take no parameters?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
what is the difference between functional dependecy and multilevel dependency?