Name the three major set of files on disk that compose a database in Oracle?
How to drop an existing table in oracle?
various types of hints and their usage
What is a cursor and what are the steps need to be taken?
Explain oracle’s server parameter file.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is Partitions in Table ?
How to get a list of all tables in the database?
3. Display all the client numbers in the ORDER table. Remove duplicates.
How to load data through external tables?
State and explain about oracle instance?
Write a trigger example in oracle?
what is load balancing and what u have used to do this?(sql loader)