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 6558

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

3 10170

What is Overloading of procedures ?

2 7635

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

Symphony,

2 9382

What are two parts of package ?

Infosys,

2 17502

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

JDA,

2 16521

How packaged procedures and functions are called from the following?

2 6378

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

3 11631

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 7497

what is sql and plsql

6 11518

what is the difference between to_char and to_date functions?

Infosys,

10 67490

what is organisational index?

1 5372

what are the advantages of cursors than procedures?

2 12106

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32901

What is a 'instead of trigger'?

Eenadu, TCS,

3 13078

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Why do we need cursor in pl sql?

1181

what are the differences between binary and varbinary? : Sql dba

1079

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1631

Can we connect to postgresql using sql developer?

1044

What is a null value?

1184

What is a function in oracle pl sql?

1093

Can a table contain multiple foreign key’s?

1047

What are different methods to trace the pl/sql code?

1163

Explain spool.

1213

What is trigger and how to use it in sql?

1063

Can a foreign key have a different name?

992

How do I debug a stored procedure?

1158

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1017

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3617

How to load data with sql*loader?

1108

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