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 create a stored procedure in oracle?

1030

How to return top 5 rows in oracle?

994

How to select some columns from a table in oracle?

1007

How to concatenate two text values in oracle?

1054

What is a data lock in oracle?

1019

What privilege is needed for a user to connect to oracle server?

943

What is an oracle user role?

939

How to download oracle database 10g xe?

962

How to join two tables in a single query using oracle?

933

How to check your oracle database 10g xe installation?

929

How to set a transaction to be read only in oracle?

1034

How to sort output in descending order in oracle?

990

What are ddl statements in oracle?

1020

How to use attributes of the implicit cursor in oracle?

951

How to name query output columns in oracle?

1133

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a select query statement in oracle?

901

How does oracle handle read consistency?

1052

Explain the characteristics of oracle dba?

1070

what is normalisation?what are its uses?

2214

How to fetch the row which has the max value for a column?

951

What is a snapshot log?

957

How many data types are supported?

1030

What privilege is needed for a user to insert rows to tables in another schema?

958

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1874

Name the three major set of files on disk that compose a database in Oracle?

1072

What is set operator oracle?

923

Explain the use of record option in exp command.

951

How to connect to oracle using service name instead of sid?

964

How do I escape a reserved word in oracle?

1132

What is Undo Management Advisor in Oracle?

1042

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