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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Can we have exception part in trigger ?

1 7394

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

HCL, JPMorgan Chase,

5 14603

what is meant by databases

4 6354

How many levels can subqueries be nested in a FROM clause?

7 25956

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 5155

How to get employee name from employee table which is the fiveth highest salary of the table

Infosys, Rolta,

20 29344

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 34362

what is difference b/w pravite procedures and public procedures?

Steria, Wipro, Zensar,

3 20212

cursor types? explain with example programs?

HP,

1 5923

<> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

ITC Infotech,

1 4882

what is the use of HASH, LIST partitions?

ITC Infotech,

1 5340

what is SCALAR Queries?

ITC Infotech,

2 7825

what is HASH join?

Genpact, HCL,

2 12680

what is overloading procedure or overloading function ?

Genpact,

3 8148

how to create table with in the procedure or function?

Genpact, HCL,

2 14671

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Can cursors be part of a trigger body?

1635

What are the different types of functions in sql?

1048

Define the select into statement.

1046

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1011

What are the two characteristics of a primary key?

968

What is schema in sql?

941

What is count * in sql?

993

What are the differences between in and exists clause?

1108

What is the use of primary key?

1005

what is isam? : Sql dba

1001

What is parallel hint?

1314

What are all the different normalizations?

1025

What is trigger point?

990

What found sql?

939

What is synchronized subquery?

1161

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