SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is the basic structure of PL/SQL ?

6 10000

What are the components of a PL/SQL block ?

3 11140

What are the datatypes a available in PL/SQL ?

2 6125

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

4 11477

What is difference between % ROWTYPE and TYPE RECORD ?

2 21583

What is PL/SQL table ?

6 9101

What is a cursor ? Why Cursor is required ?

3 12131

Explain the two type of Cursors ?

Hi Caliber IT,

8 17049

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

4 8726

What are the cursor attributes used in PL/SQL ?

4 8465

What is a cursor for loop ?

4 8126

What will happen after commit statement ?

2 7329

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 12621

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

4 9847

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

2 12758


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I kill a query in postgresql?

550


Explain the methods used to protect source code of pl/sql.

537


How long will it take to learn pl sql?

522


What is the purpose of a sql?

522


what is the difference between where clause and having clause? : Sql dba

531






What is cursor in pl sql with examples?

478


What is the difference between sum and count in sql?

518


What are crud methods?

549


Can we debug stored procedure?

518


What is the clause we need to add in function body to return variable?

538


How do I find sql profiler?

513


What are the benefits of pl sql?

523


What is dml statement?

515


What is t sql used for?

548


Can we create a trigger on view?

485