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 11740

Types of cursors and explanation each of them ?

DELL,

4 12770

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 13572

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 9521

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35834

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 60765

Types of locks in database ?

HCL, TCS, Tieto,

8 76803

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

TCS,

5 14672

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

TCS,

3 11744

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

TCS,

4 16766

Types of backups ?

TCS,

3 10476

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61272

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

Microsoft, TCS,

4 25399

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 118059

Types of joins ?

Polaris, TCS,

11 23937

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the purpose of the primary key?

1056

What is the difference between count 1 and count (*) in a sql query?

981

what are the performance and scalability characteristics of mysql? : Sql dba

995

What is a temporal table?

923

What is a call statement? Explain with an example.

997

Is a table valued function object?

1004

Where is all the data on the internet stored?

1005

How delete all data from all tables in sql?

943

where are cookies actually stored on the hard disk? : Sql dba

1023

how do you know the version of your mysql server? : Sql dba

1000

What is delete command in sql?

1108

Can primary key be changed?

903

Is it possible to create the following trigger: before or after update trigger for each row?

1280

Can we rename a column in the output of sql query?

991

What is recursive join in sql?

1003

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