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 6342

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

3 9900

What is Overloading of procedures ?

2 7367

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

Symphony,

2 9208

What are two parts of package ?

Infosys,

2 17272

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

JDA,

2 16233

How packaged procedures and functions are called from the following?

2 6171

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

3 11424

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 7250

what is sql and plsql

6 10975

what is the difference between to_char and to_date functions?

Infosys,

10 66766

what is organisational index?

1 5218

what are the advantages of cursors than procedures?

2 11827

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 31708

What is a 'instead of trigger'?

Eenadu, TCS,

3 12804

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are left and right joins the same?

1003

What is sql injection owasp?

1001

Why plvtab is considered as the easiest way to access the pl/sql table?

1132

Define join and name different types of joins?

960

What are different clauses used in sql?

1077

What is the difference between row level and statement level trigger?

960

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1125

can sql servers linked to other servers like oracle? : Sql dba

956

explain access control lists. : Sql dba

949

How to run sql*plus commands in sql developer?

1086

Explian rowid, rownum? What are the psoducolumns we have?

945

Does sql backup shrink transaction log?

916

What is difference between group by and partition by?

978

What is the default isolation level in sql server? : Transact sql

964

What is data definition language?

1048

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