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 11754

Types of cursors and explanation each of them ?

DELL,

4 12804

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 13591

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 9537

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35884

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 60907

Types of locks in database ?

HCL, TCS, Tieto,

8 76843

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

TCS,

5 14696

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

TCS,

3 11757

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

TCS,

4 16785

Types of backups ?

TCS,

3 10490

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61321

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

Microsoft, TCS,

4 25419

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 118477

Types of joins ?

Polaris, TCS,

11 24007

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is trigger point?

994

What is pl sql architecture?

959

What is anonymous block in sql?

1120

What is the difference between delete, truncate and drop command?

1151

How does pl sql work?

959

Which one is better subquery or joins?

1061

What is sql keyword?

999

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

how many tables will create when we create table, what are they? : Sql dba

1073

How to connect a sql*plus session to an oracle server?

1126

Does truncate table reset auto increment?

992

Explain the purpose of %type and %rowtype data types with the example?

994

What are pl sql data types?

1009

Is it possible to pass parameters to triggers?

1103

How to read xml file in oracle pl sql?

913

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