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 12004

What are the components of a PL/SQL block ?

3 12660

What are the datatypes a available in PL/SQL ?

2 7172

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

4 12802

What is difference between % ROWTYPE and TYPE RECORD ?

2 22594

What is PL/SQL table ?

6 11330

What is a cursor ? Why Cursor is required ?

3 13576

Explain the two type of Cursors ?

Hi Caliber IT,

8 19504

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

4 10296

What are the cursor attributes used in PL/SQL ?

4 9951

What is a cursor for loop ?

4 9657

What will happen after commit statement ?

2 8235

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14301

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

4 11263

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

2 13763

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What type of database is sql?

1022

Explain ddl statements in pl/sql?

1009

Does truncate release storage space?

1075

What is a nested table in word?

957

List out the acid properties and explain?

949

Why indexing is needed?

983

what is self join and what is the requirement of self join? : Sql dba

1144

What type of join is sql join?

980

What is embedded sql in db2?

1017

how many ways to get the current time? : Sql dba

1007

How do you update a sql procedure?

1029

What is field delimiter?

1048

Explain the structure of pl/sql in brief.

1093

explain mysql aggregate functions. : Sql dba

986

Explain the difference between triggers and constraints?

975

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