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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

Reliance,

2 7764

what is variable in package specification

3 6744

i don't want the message as 14 rows updated just it should update what it will do

4 9282

how can i read files from a pl/sq l program

3 10113

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

Alps, Aricent, Bank Of America, Wipro,

29 51825

what is the command for user data type?

2 8942

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

Wipro,

15 50319

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

AOL,

1 6341

In testing where do we use sql language and how it helps in testing?

2 7295

what command is used to create a table by copying the structure of another table including constraints ?

CMC, eicc,

6 16423

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

51 74025

Difference between views and materialized views?

BirlaSoft,

5 22277

Write a simple program on cursors

BirlaSoft,

2 8183

How to convert ms-excel file to oracle table?

2 9801

what are the different types of joins?

Choice Solutions,

4 10685

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the difference between unique and primary key constraints?

1071

What is consistency?

1123

What is delete command in sql?

1112

explain commit and rollback in mysql : sql dba

1016

What does inner join mean?

1167

What are few of the schema objects that are created using PL/SQL?

1038

which tcp/ip port does sql server run on? : Sql dba

1026

Can we create clustered index without primary key?

963

Explain foreign key in sql?

1023

What are all types of user defined functions?

1073

what is self-join? : Sql dba

1163

Is sqlite free?

972

How do I truncate a sql log file?

1074

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1764

Is a secondary key the same as a foreign key?

1037

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