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?

1078

What are the possible values for the boolean data field?

963

What are commit, rollback, and savepoint?

992

Explain the difference in execution of triggers and stored procedures?

1022

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which is better stored procedure or query?

957

Write a sql query to convert all character to uppercase after hypen.

1438

What are local and global variables and their differences?

1090

what is innodb? : Sql dba

1105

Is sql pronounced sequel or sql?

1260

what is the difference between cluster and non cluster index? : Sql dba

1025

Can we use pl sql in sql server?

1081

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

1048

What is sql and its types?

1186

what is the difference between $message and $$message? : Sql dba

997

What are joins in sql?

1044

Are pl sql variables case sensitive?

1045

Explain two easy sql optimizations.

1008

What are different types of functions in sql?

1004

How do you respond to dementia behavior?

969

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