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 7867

what is variable in package specification

3 6845

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

4 9392

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

3 10263

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 52591

what is the command for user data type?

2 9031

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 50726

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

AOL,

1 6406

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

2 7376

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

CMC, eicc,

6 16644

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

51 75400

Difference between views and materialized views?

BirlaSoft,

5 22466

Write a simple program on cursors

BirlaSoft,

2 8267

How to convert ms-excel file to oracle table?

2 9901

what are the different types of joins?

Choice Solutions,

4 10827

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is the command used to fetch first 5 characters of the string? : Sql dba

1679

How do sql triggers work?

1088

What is db journal file?

1149

What is the use of non clustered index?

1042

explain the advantages and disadvantages of stored procedure? : Sql dba

1059

Why we use stored procedure instead of query?

1045

How to use distinct and count in sql query? Explain

1080

What is database sql?

1097

What is the difference between sql and t sql?

1102

What are different categories of sql commands?

1191

What is the purpose of using pl/sql?

1186

What are %type and %rowtype for?

1102

what are different types of keys in sql?

1214

How to get unique records from a table?

1019

what is acid property in database? : Sql dba

1063

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