Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 3949

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 7339

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 4762

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

Infogain,

1 2034

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

Infogain,

3 6876

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

4 6642

How to find last day of the month in sql query

4 5998

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

2 3571

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 4580

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 4207

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 4939

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

Oracle,

1 5015

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 5199

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 5685

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 6879


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Explain what is sql?

253


How do I partition a table in sql?

187


What are different sql data types?

186


Explain about various levels of constraint.

209


Why should I use postgresql?

179






What is embedded sql in db2?

183


What is inner join in sql?

214


what is blob? : Sql dba

206


What is sorting in sql?

186


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

987


Mention what does plv msg allows you to do?

262


what are the types of subquery? : Sql dba

215


what is a foreign key ? : Sql dba

201


Is nosql faster than sql?

183


What is database white box testing and black box testing?

221