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 6451

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

3 10063

What is Overloading of procedures ?

2 7539

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

Symphony,

2 9308

What are two parts of package ?

Infosys,

2 17414

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

JDA,

2 16388

How packaged procedures and functions are called from the following?

2 6280

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

3 11554

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 7395

what is sql and plsql

6 11295

what is the difference between to_char and to_date functions?

Infosys,

10 67195

what is organisational index?

1 5313

what are the advantages of cursors than procedures?

2 11991

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32417

What is a 'instead of trigger'?

Eenadu, TCS,

3 12959

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How long will it take to learn pl sql?

936

How do I create an index in word?

1031

Explain the uses of control file.

1048

What do you mean by field in sql?

1077

How do I run sql profiler?

1066

how can we submit a form without a submit button? : Sql dba

985

How do I filter in sql profiler?

993

What is composite data type in pl sql?

1109

How can I delete duplicate rows?

1014

What is clause?

1149

What is orm in sql?

1046

what does the t-sql command ident_incr does? : Transact sql

1077

Explain the working of foreign key?

1067

What are the different dml commands in sql?

1172

What are the topics in pl sql?

970

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