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 11856

Types of cursors and explanation each of them ?

DELL,

4 12979

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 13723

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 9631

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 36101

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 61548

Types of locks in database ?

HCL, TCS, Tieto,

8 77074

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

TCS,

5 14865

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

TCS,

3 11862

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

TCS,

4 16886

Types of backups ?

TCS,

3 10604

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61780

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

Microsoft, TCS,

4 25583

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 119964

Types of joins ?

Polaris, TCS,

11 24372

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is before and after trigger?

1005

How do I truncate a word?

1155

What is tuple in sql?

1136

What is union, minus and interact commands?

1361

Can we use commit inside a trigger?

1140

What is the use of nvl function?

1239

What is dialect in sql?

983

How do I run a pl sql procedure in sql developer?

1016

Why self join is used in sql?

1026

how many ways we can we find the current date using mysql? : Sql dba

1140

Which one is better subquery or joins?

1114

What is the difference between local variables and global variables?

1170

Does postgresql run on the cloud?

1213

Why use triggers in sql?

1008

How can you select unique records from a table?

1144

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