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 11974

What are the components of a PL/SQL block ?

3 12634

What are the datatypes a available in PL/SQL ?

2 7148

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

4 12784

What is difference between % ROWTYPE and TYPE RECORD ?

2 22588

What is PL/SQL table ?

6 11300

What is a cursor ? Why Cursor is required ?

3 13555

Explain the two type of Cursors ?

Hi Caliber IT,

8 19472

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

4 10278

What are the cursor attributes used in PL/SQL ?

4 9931

What is a cursor for loop ?

4 9635

What will happen after commit statement ?

2 8228

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 14260

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

4 11241

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

2 13753

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do you update f as m and m as f from the below table testtable?

1846

What is hibernate and its relation to sql?

1116

Why function is used in sql?

938

how to write date and time literals? : Sql dba

956

How many types of triggers are there in pl sql?

1063

What are the key differences between SQL and PL SQL?

1209

What is implicit cursor in pl sql?

1088

what is schema? : Sql dba

1044

What is auto increment feature in sql?

1117

what are the differences between require and include, include_once and require_once? : Sql dba

1018

What is scope of pl sql developer in future?

1013

Explain the components of sql?

1053

how can we know the number of days between two given dates using mysql? : Sql dba

1044

how to select first 5 records from a table? : Sql dba

972

What are the advantages of sql?

1051

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