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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is the basic structure of PL/SQL ?

6 12173

What are the components of a PL/SQL block ?

3 12790

What are the datatypes a available in PL/SQL ?

2 7251

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 12923

What is difference between % ROWTYPE and TYPE RECORD ?

2 22684

What is PL/SQL table ?

6 11509

What is a cursor ? Why Cursor is required ?

3 13704

Explain the two type of Cursors ?

Hi Caliber IT,

8 19735

What are the PL/SQL Statements used in cursor processing ?

4 10439

What are the cursor attributes used in PL/SQL ?

4 10081

What is a cursor for loop ?

4 9813

What will happen after commit statement ?

2 8329

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14469

What is a database trigger ? Name some usages of database trigger ?

4 11380

How many types of database triggers can be specified on a table ? What are they ?

2 13853

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the advantage of index in sql?

1014

Can a trigger call a stored procedure?

1125

What are the 3 types of behavioral triggers?

1309

How do you modify a table in sql?

1159

define sql update statement ? : Sql dba

1156

How many disk partitions should I have?

1037

How to take user input in pl sql?

1198

Is keyword pl sql?

1049

Define overloaded procedure?

1126

Why functions are used in sql?

1038

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1102

what are all the different types of indexes? : Sql dba

1101

What is difference between primary and secondary key?

1071

How many row comparison operators are used while working with a subquery?

1069

What is database migration?

1005

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