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?

1220

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

1035

Difference between truncate, delete and drop commands?

1135

How do you add a column to a table?

1099

What is a table?

1057

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

1148

What is the mutating table and constraining table?

1075

How to select random rows from a table?

1133

What are properties of the transaction?

1045

Why is %isopen always false for an implicit cursor?

1150

What is normalization? How many normalization forms are there?

1136

When do we use triggers?

1145

What are the possible values for the boolean data field?

1010

What are commit, rollback, and savepoint?

1043

Explain the difference in execution of triggers and stored procedures?

1060

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is parameter substitution in sql?

1077

What are the benefits of stored procedures?

1126

Is oracel sql developer written in java?

1163

What are the two types of cursors in pl sql?

1121

How does an execution block start and end in pl sql?

995

Explain what is a subquery ?

1240

what are the advantages of using stored procedures? : Sql dba

1146

How do you optimize a stored procedure in sql?

1014

what is the difference between myisam static and myisam dynamic? : Sql dba

1111

What is procedure explain with example?

1005

What are pl/sql cursor exceptions?

1162

Explain the insert into statements in sql?

1049

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4052

What are the most important characteristics of pl/sql?

1224

What is the difference between between and in condition operators?

1063

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