SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Types of joins ?

Digital GlobalSoft, HeadStrong,

3 11615

Types of cursors and explanation each of them ?

DELL,

4 12576

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 13416

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

DELL,

2 9424

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35599

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 60012

Types of locks in database ?

HCL, TCS, Tieto,

8 76545

Types of indexes. What is the default key created when a primary key is created in a table ?

TCS,

5 14476

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

TCS,

3 11609

Can we create non-clustured index on a clustered index ?

TCS,

4 16629

Types of backups ?

TCS,

3 10323

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 60835

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

Microsoft, TCS,

4 25221

Write a query to get 2nd maximum salary in an employee table ?

Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

69 116216

Types of joins ?

Polaris, TCS,

11 23504

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are stored procedures compiled?

873

What is ttitle and btitle?

1012

explain the difference between myisam static and myisam dynamic. : Sql dba

887

define sql update statement ? : Sql dba

1051

How many types of cursors supported in pl/sql?

1097

Does google use sql?

915

Explain ttitle and btitle.

1059

How to call a javascript function from pl sql?

1073

What is anonymous block in sql?

1077

What does inner join mean?

1066

what is a table in a database ? : Sql dba

994

What is rowtype?

956

When to use inner join and left join?

908

Can we enter data in a table in design view?

913

What is the difference between a subquery and a join?

1018

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