SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What are nested triggers ?

Amazon, Appeal Soft, IBM, Infosys, TCS,

6 30810

What is normalization ?

BirlaSoft, CTS, HCL,

9 19402

What is an index and types of indexes. How many number of indexes can be used per table ?

Accenture, BirlaSoft, Cognizant, CTS, Symphony,

12 79001

What is a constraint. Types of constraints ?

Accenture, BirlaSoft,

5 23763

What are code pages ?

BirlaSoft,

1 2286

What is referential integrity ?

BirlaSoft,

3 7232

What is a trigger ?

Accenture, BirlaSoft,

11 18167

What are different types of joins ?

BirlaSoft,

5 7791

What is a self join ?

BirlaSoft,

6 11328

Authentication mechanisms in Sql Server ?

BirlaSoft,

1 6329

What are user defined stored procedures ?

BirlaSoft,

3 12097

Can we use more than one null value for unique key?

A1 Technology, Wipro,

31 56273

how do u call in & out parameters for stored procedures?

A1 Technology, TCS, Techicon,

10 16243

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

Accenture, Unisoft Infotech,

2 16103

Give which cursor is better for better performance means type of cursors?

2 6653


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the basic form of sql query?

468


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

554


How to start oracle sql developer?

544


what is a control file ? : Sql dba

552


What is identity column in sql server?

496






Explain unique key in sql.

540


What are the 3 modes of parameter?

654


What is using in sql?

537


Can we join tables without foreign key?

500


What are the different sql languages?

515


What is the difference between nvl function, ifnull function, and isnull function?

565


Explain the steps needed to create the scheduled job?

538


What is the difference between partition and index?

460


how can you create an empty table from an existing table? : Sql dba

638


How do I enable sql encryption?

497