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 5349

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8835

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 6190

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

Infogain,

1 3447

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

Infogain,

3 9055

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

4 9180

How to find last day of the month in sql query

4 8508

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

2 5323

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 6717

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 6320

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 7475

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

Oracle,

1 6956

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 7061

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 7225

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 10654

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is varchar used for?

1130

What is the difference between microsoft access and sql server?

1100

Explain ddl statements in pl/sql?

1041

what is a trigger? : Sql dba

1084

What is string join?

1021

Can we insert data into view?

946

What is the sql*loader? : aql loader

1096

How do you get column names only for a table (sql server)?

1206

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2598

What view means?

1020

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1044

How do I save a sql query?

1062

what is subquery? : Sql dba

1181

how to add a new column to an existing table in mysql? : Sql dba

1110

Is left join and outer join same?

1111

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