SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is the basic structure of PL/SQL ?

6 9955

What are the components of a PL/SQL block ?

3 11105

What are the datatypes a available in PL/SQL ?

2 6111

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

4 11449

What is difference between % ROWTYPE and TYPE RECORD ?

2 21562

What is PL/SQL table ?

6 9083

What is a cursor ? Why Cursor is required ?

3 12106

Explain the two type of Cursors ?

Hi Caliber IT,

8 17008

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

4 8699

What are the cursor attributes used in PL/SQL ?

4 8441

What is a cursor for loop ?

4 8104

What will happen after commit statement ?

2 7313

Explain the usage of WHERE CURRENT OF clause in cursors ?

Satyam,

4 12587

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

4 9828

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

2 12744


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Which is better trigger or stored procedure?

488


What do you mean by table in sql?

514


How do I view a sql database?

544


Explain constraints in sql?

557


Why do we use function in pl sql?

545






Can delete statement be rollbacked?

510


What does count (*) mean?

513


What is a record in pl/sql?

535


How do you rank data in sql?

503


What is sql analyzer?

521


Why primary key is required?

537


Explain ttitle and btitle.

657


What is the syntax to add a record to a table?

561


What is trigger in pl sql with examples?

509


What does inner join mean?

536