Oracle Interview Questions | Technical Interview & Viva Questions : KyaPoocha.com

Oracle Interview Questions

Pages (999999): « 1 [2] 3 4 » ... Last »

Compare and contrast TRUNCATE and DELETE for a table?

View the Answer

Give two examples of how you might determine the structure of the table DEPT?

View the Answer

How do you switch from an init.ora file to a spfile?

View the Answer

Why are recursive relationships bad? How do you resolve them

View the Answer

What file will give you Oracle instance status information?

View the Answer

How can you determine if the SQLNET process is running for SQLNET V1? How about V2?

View the Answer

How can you determine if an Oracle instance is up from the operating system level?

View the Answer

When should you consider denormalization?

View the Answer

What is a pseudo column. Give some examples

View the Answer

Difference between an implicit & an explicit cursor?

View the Answer

What is a cursor for loop?

View the Answer

What is use of a cursor variable? How it is defined

View the Answer

How you open and close a cursor variable.Why it is required?

View the Answer

What is difference between a formal and an actual parameter?

View the Answer

What are ORACLE PRECOMPILERS?

View the Answer

Pages (999999): « 1 [2] 3 4 » ... Last »