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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 5181

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8695

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

Pitney Bowes,

1 6030

What is the criteria while applying index to any column on any table.

Infogain,

1 3292

What is the diffrence between IN and EXISTS.which one is faster.

Infogain,

3 8817

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 8880

How to find last day of the month in sql query

4 8227

Fetch an entire row from the employees table for a specific employee ID:

2 5149

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 6494

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 6093

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 7158

while loading data into database how can u skip header and footer records in sql*loader

Oracle,

1 6754

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

Oracle, Wipro,

1 6888

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

Parexel,

1 7064

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

MTS,

7 10250

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the use of non clustered index?

938

What are the features of pl sql?

1020

Explain two easy sql optimizations.

972

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

923

What is sqlservr exe?

949

Define union, minus, union all, intersect ?

957

What is data modelling in sql?

970

What is the current version of sql?

983

What is not equal in sql?

1024

Can we group by two columns in sql?

948

How will you distinguish a global variable with a local variable in pl/sql?

1105

What is the trigger in sql?

910

What are the syntax and use of the coalesce function?

1117

How many tables can a sql database have?

931

Explain the difference between rename and alias?

975

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