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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Give the structure of the function ?

2 6436

Explain how procedures and functions are called in a PL/SQL block ?

3 10049

What is Overloading of procedures ?

2 7518

What is a package ? What are the advantages of packages ?

Symphony,

2 9298

What are two parts of package ?

Infosys,

2 17395

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

JDA,

2 16374

How packaged procedures and functions are called from the following?

2 6269

Name the tables where characteristics of Package, procedure and functions are stored ?

3 11536

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

iFlex,

2 7377

what is sql and plsql

6 11255

what is the difference between to_char and to_date functions?

Infosys,

10 67144

what is organisational index?

1 5311

what are the advantages of cursors than procedures?

2 11974

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32336

What is a 'instead of trigger'?

Eenadu, TCS,

3 12943

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql analyzer?

1005

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1068

what is a materialized view? : Sql dba

1056

Can I create table without primary key?

993

Why schema is used in sql?

1044

Can a trigger call a stored procedure?

1064

What are the differences between in and exists clause?

1105

How do I debug a stored procedure?

1107

Does sql*plus have a pl/sql engine?

1066

How to disable a trigger name update_salary?

1260

how to enter binary numbers in sql statements? : Sql dba

966

How to know the last executed procedure?

1085

How to return an array from java to pl/sql?

1127

What is the difference between a procedure and a function?

1099

What is the syntax and use of the coalesce function?

1160

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