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?

1158

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

996

Difference between truncate, delete and drop commands?

1082

How do you add a column to a table?

1055

What is a table?

1015

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

1090

What is the mutating table and constraining table?

1026

How to select random rows from a table?

1075

What are properties of the transaction?

998

Why is %isopen always false for an implicit cursor?

1106

What is normalization? How many normalization forms are there?

1085

When do we use triggers?

1079

What are the possible values for the boolean data field?

963

What are commit, rollback, and savepoint?

993

Explain the difference in execution of triggers and stored procedures?

1022

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which query operators in sql is used for pattern matching?

966

what is innodb? : Sql dba

1105

What are three advantages to using sql?

1019

What are the basic sql commands?

1093

Why do we use %rowtype & %type in plsql?

1049

What is the example of procedure?

928

Why do we need pl sql?

977

what is an index? : Sql dba

995

What is sql profiling in oracle?

1064

how are mysql timestamps seen to a user? : Sql dba

1139

Are dml statements autocommit?

1045

Can we use ddl statements in stored procedure?

1154

What are stuff and replace function?

1081

What is the difference between syntax error and runtime error?

1141

Which is the correct statement about truncate and delete?

1112

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