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 12011

What are the components of a PL/SQL block ?

3 12665

What are the datatypes a available in PL/SQL ?

2 7174

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

4 12803

What is difference between % ROWTYPE and TYPE RECORD ?

2 22597

What is PL/SQL table ?

6 11333

What is a cursor ? Why Cursor is required ?

3 13582

Explain the two type of Cursors ?

Hi Caliber IT,

8 19508

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

4 10298

What are the cursor attributes used in PL/SQL ?

4 9951

What is a cursor for loop ?

4 9663

What will happen after commit statement ?

2 8238

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 11265

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

2 13764

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql in java?

1086

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1100

How much does sqlite cost?

1038

how to load data files into tables with 'mysqlimport'? : Sql dba

1092

What is sql*plus?

1079

What is sql in oracle?

1061

Are sql connections encrypted?

1022

What is a behavioral trigger?

972

Is join an inner join?

974

what are the different type of sql's statements ? : Sql dba

926

What is an escape character in sql?

1025

What happens when a trigger is associated to a view?

914

What is the purpose of the sql select top clause?

1112

What is varchar data type in sql?

1083

Is it possible to create the following trigger: before or after update trigger for each row?

1286

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