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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

can i write pl/sql code in a package

2 6712

can i give user defined exception in a package

2 7264

after tell procedure whole code he asked can i write the same way in a function

3 5694

can i use dbms_output.put_line in a function u are telling as return statement

7 18079

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 4750

difference between cursor and procedure in a package

PCS,

3 29720

difference between oracle 8i and oracle 9i

8 25745

full outer join syntax

5 8801

what is called after appearing where clause

3 6456

how can i create a user defined datatype

3 7538

how can i read write files from pl/sql

3 9622

what is global variable in pl/sql

1 11874

can i call procedure in package

TCS,

3 10004

four procedures is are there should i write their in a package

2 6270

package specification-3 procedures package body-2 procedures will is execute

PWC,

2 10657

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is set serveroutput on?

1136

How to get list of all tables from a database?

1160

Define SQL and state the differences between SQL and other conventional programming Languages?

1210

What trigger means?

977

Do prepared statements prevent sql injection?

949

What is schema in sql?

948

When is a declare statement required?

1138

What does select top 1 do in sql?

1093

Is left join and outer join same?

1066

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1208

Is time a data type in sql?

902

When sql appeared?

1096

Explain the the delete statements in sql?

1062

what is a stored procedure? : Sql dba

1131

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

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