Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How to get a list of all tables in the database?

1 4338

How to set up autotrace for a user account?

1112

How to run the anonymous block again?

1175

How to see the table columns used in an index?

1071

How to drop an index?

1015

What happens to the current transaction if the session is killed?

1039

How to define an external table with a text file?

1128

How to get a list of all user accounts in the database?

1131

How to define a sub function?

1203

How to define a data field as not null?

1163

How to enter a new row into a table interactively?

1053

How to build data dictionary view an new database?

1052

How to get a create statement for an existing table?

1016

How to pass parameters to procedures?

1089

How to use "in" parameter properly?

1120

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

When do I need to use a semicolon vs a slash in oracle sql?

1146

How to get execution path reports on query statements?

1045

What is a proxy class?

1107

Explain the use of grant option in imp command.

1083

how can we store any pdf file in oracle

2222

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1096

What is the sql query to concatenate column values from multiple rows in oracle?

1106

Explain the use of tables option in exp command.

1167

What is dynamic proxy?

1054

What is the difference between substr and instr?

1093

How to export several tables together?

1106

What is instant client oracle?

1074

Explain the use of record length option in exp command.

1119

How to define a data source name (dsn) in odbc manager?

1084

How to lock and unlock a user account in oracle?

1163

For More Un-Answered { Oracle General } Questions Click Here