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 do a full database export?

1050

How to bring a tablespace online?

998

Can group functions be mixed with non-group selection fields?

963

What is the relation of a user account and a schema?

1064

How many file formats are supported to export data?

1139

Why cursor variables are easier to use than cursors?

1022

How to insert a record into a table?

1021

How to define a variable to match a table column data type?

938

How to invoke the original export import utilities?

977

What is the difference between formal parameters and actual parameters?

1005

How to view the dropped tables in your recycle bin?

1 1397

How to define an anonymous procedure without variables?

1025

How many data types are supported?

1027

How to connect to the server with user account: sys?

970

How to define default values for formal parameters?

985

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a partition in oracle?

1039

What is coalesce function?

1009

How are extents allocated to a segment?

1063

What is a procedure in oracle?

1076

How to change user password in oracle?

975

How do I find the database name in oracle?

981

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2205

What is proxy method?

931

What is the quickest way to fetch the data from a table?

1001

Give the advantages and disadvantages of clusters.

997

What are the different types of database objects?

993

Explain the use of record option in exp command.

948

What is set operator oracle?

923

Explain about achiever in sql?

981

Can we store pictures in the database and if so, how it can be done?

985

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