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 7402

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 14627

what is meant by databases

4 6367

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

7 25978

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 5174

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

Infosys, Rolta,

20 29444

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 34398

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

Steria, Wipro, Zensar,

3 20229

cursor types? explain with example programs?

HP,

1 5937

<> 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 4891

what is the use of HASH, LIST partitions?

ITC Infotech,

1 5350

what is SCALAR Queries?

ITC Infotech,

2 7844

what is HASH join?

Genpact, HCL,

2 12696

what is overloading procedure or overloading function ?

Genpact,

3 8173

how to create table with in the procedure or function?

Genpact, HCL,

2 14682

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to read/write files from pl/sql?

1036

how many ways we can we find the current date using mysql? : Sql dba

1099

What is mutating table error?

1182

How do you use a while loop in pl sql?

1013

what is the difference between truncate and drop statements? : Sql dba

1126

What will you get by the cursor attribute sql%rowcount?

1038

Why self join is used in sql?

976

How does sql profiler work?

1023

how to enter numeric values as hex numbers? : Sql dba

1064

What is data definition language?

1092

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

960

How to Execute a Package in PL/SQL.?

1205

How to sort the rows in sql.

1075

What is sql partition?

1108

How do I run a sql query in pgadmin 4?

961

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