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 7755

what is variable in package specification

3 6726

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

4 9263

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

3 10093

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 51701

what is the command for user data type?

2 8920

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 50206

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

AOL,

1 6339

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

2 7289

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

CMC, eicc,

6 16391

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

51 73842

Difference between views and materialized views?

BirlaSoft,

5 22247

Write a simple program on cursors

BirlaSoft,

2 8159

How to convert ms-excel file to oracle table?

2 9785

what are the different types of joins?

Choice Solutions,

4 10651

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many types of index are there?

1030

What is the difference between view and stored procedure?

959

Is stored procedure faster than query?

963

How do I know if I have sql express or standard?

1026

What are the differences between implicit and explicit cursors?

1060

how to get @@error and @@rowcount at the same time? : Sql dba

1018

What is pl sql and why it is used for?

1110

what are the advantages and disadvantages of views in a database? : Sql dba

1039

What do you mean by stored procedures?

1007

Which type of cursor is used to execute the dml statement?

950

Why do we create stored procedures & functions in pl/sql and how are they different?

936

Can we use commit inside a trigger?

1080

what are date and time intervals? : Sql dba

1053

Is primary key clustered or nonclustered?

1006

What is sql stand for?

979

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