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 define a procedure inside another procedure?

1024

What to do if the binary spfile is wrong for the default instance?

1069

How to create a server parameter file?

1135

How to rename an existing table?

1129

What are the execution control statements?

1063

How to run create database statement?

1032

What happens if the update subquery returns multiple rows?

1116

How to use "startup" command to start default instance?

1031

What happens if the imported table already exists?

1033

How to create a stored program unit?

1228

How to call a stored function with parameters?

1045

How to turn on or off recycle bin for the instance?

1083

How to assign a table row to a record variable?

1040

How to define an anonymous procedure with variables?

1158

How to declare a local variable?

1115

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is instant client oracle?

1021

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

997

What is a package ? What are the advantages of package ?

1091

Differentiate between function and procedure in oracle.

1076

Explain the features of oracle?

1046

How to define an anonymous block?

1157

How many types of synonyms in Oracle?

1124

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

Explain cascading triggers.

1073

How to select an oracle system id (sid)?

1064

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

Why do we use bulk collect in oracle?

1058

What is a proxy class?

1052

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

what is the dual table in oracle?

991

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