SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1138

What do you mean by stored procedures? How do we use it?

993

Difference between truncate, delete and drop commands?

1080

How do you add a column to a table?

1050

What is a table?

1007

What is the syntax to add a record to a table?

1085

What is the mutating table and constraining table?

1023

How to select random rows from a table?

1071

What are properties of the transaction?

996

Why is %isopen always false for an implicit cursor?

1098

What is normalization? How many normalization forms are there?

1080

When do we use triggers?

1072

What are the possible values for the boolean data field?

958

What are commit, rollback, and savepoint?

985

Explain the difference in execution of triggers and stored procedures?

1017

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which is better stored procedure or query?

955

What is memory optimized?

1076

What are tuples in sql?

1125

What are sql commands?

1008

What is the use of pl/sql table?

1060

What is sql and db2?

994

Explain what is a field in a database and record in a database?

1091

What does count (*) do in sql?

1003

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2478

List and explain the different types of join clauses supported in ansi-standard sql?

1352

What are functions in sql?

953

How is sql used in oracle?

1001

What type of database is sql?

1019

Why do we use joins?

1031

What are the advantages of normalization?

1074

For More Un-Answered { SQL PLSQL } Questions Click Here