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 12207

How to find only %th Highest Sal

Infogain, Symphony,

6 11989

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

Metric Stream,

2 9682

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

CTS,

2 10483

What are the Diff B/W Cursor and REF Cursor

CTS,

3 12956

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

Doyensys,

4 15341

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 19071

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

3 9056

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 5201

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 9714

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 3718

. 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 6203

when normalization is required

HCL,

3 7636

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

CGI,

4 10776

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 11541

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the difference between null value, zero, and blank space?

1138

Write a sql query to get the third highest salary of an employee from employee_table?

1027

how to convert dates to character strings? : Sql dba

1070

How to display the records between two range in Oracle SQL Plus?

1098

What is procedure and function?

921

How to run pl sql program in mysql?

939

how to convert character strings to dates? : Sql dba

983

Explain table and field in sql?

1015

what is meant by nl2br()? : Sql dba

974

Explain commit, rollback and savepoint.

932

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

944

How do I enable sql encryption?

966

how to shut down the server with 'mysqladmin'? : Sql dba

955

How to download oracle sql developer?

1056

What is difference between hql and sql?

991

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