In oracle there is column command, how will you explain that?
What is an oracle cursor variable?
What are the major difference between truncate and delete?
What are group functions in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
State the various uses of dbcc command?
What do you understand by a database object? Can you list a few of them?
Why do you create or replace procedures rather that drop and recreate.
How to delete a column in an existing table?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to create a new tablespace in oracle?
What is a trace file and how is it created in oracle?
Give the various rollback segment states.
What privilege is needed for a user to connect to oracle server?
Explain the use of inctype option in exp command.