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 11755

Types of cursors and explanation each of them ?

DELL,

4 12807

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 13592

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 9538

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35885

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 60925

Types of locks in database ?

HCL, TCS, Tieto,

8 76849

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

TCS,

5 14698

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 10493

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61331

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

Microsoft, TCS,

4 25421

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 118494

Types of joins ?

Polaris, TCS,

11 24017

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how can we find the number of rows in a table using mysql? : Sql dba

1083

What is parameter substitution in sql?

1029

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

What is a database event trigger?

1159

explain mysql aggregate functions. : Sql dba

989

What are the commands used in sql?

1079

Explain the update statement in sql

991

how to calculate expressions with sql statements? : Sql dba

1034

Explain mutating table error.

1202

What is over () in sql?

959

What is string join?

977

How many postgresql users are there, worldwide?

1061

Why we use pl sql?

959

what is acid property in database? : Sql dba

1029

How do I copy a table in sql?

988

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