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

Cap Gemini, MTS,

4 12629

How to find only %th Highest Sal

Infogain, Symphony,

6 12529

How will you make performance better for application including front end and back

Metric Stream,

2 9946

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 10722

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13264

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 15797

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

Doyensys, Infosys, Metric Stream,

5 19566

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 9446

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.

GE,

2 5443

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

GE,

4 10134

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 3891

. 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. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so

3 6488

when normalization is required

HCL,

3 7911

can i create trigger on synonym is it possible or not please help me

CGI,

4 11182

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 11827

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the difference between count 1 and count (*) in a sql query?

1056

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1641

what is a cursor? : Sql dba

1066

What is the difference between union and union all command?

1153

define sql insert statement ? : Sql dba

1080

what are the differences between char and varchar? : Sql dba

1123

what are different types of collation sensitivity? : Sql dba

1125

Is sql a backend language?

1146

What is PL/SQL Records?

1261

What is mutating sql table?

1160

Define commit, rollback and savepoint?

1085

What is sql catalog?

1071

In a distributed database system, can we execute two queries simultaneously?

1157

Can we create table inside stored procedure?

1017

how to get a list of all tables in a database? : Sql dba

1033

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