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 7763

what is variable in package specification

3 6740

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

4 9281

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

3 10106

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 51814

what is the command for user data type?

2 8939

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 50306

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 7293

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

CMC, eicc,

6 16420

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

51 74005

Difference between views and materialized views?

BirlaSoft,

5 22270

Write a simple program on cursors

BirlaSoft,

2 8179

How to convert ms-excel file to oracle table?

2 9798

what are the different types of joins?

Choice Solutions,

4 10682

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1089

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

What are the commands used in sql?

1079

What is a natural join sql?

972

What is a left inner join?

1013

Why we use triggers in mysql?

992

How to convert comma separated string to array in pl/sql?

1180

what is a composite key ? : Sql dba

1059

What is sql rowcount?

1016

What is scalar and vector?

1002

How much does a sql dba make? : SQL DBA

942

Why primary key is required?

1006

What is the use of index in hive?

1007

When sql appeared?

1096

Why do we use view in sql?

959

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