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 6360

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

3 9923

What is Overloading of procedures ?

2 7408

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

Symphony,

2 9222

What are two parts of package ?

Infosys,

2 17297

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

JDA,

2 16251

How packaged procedures and functions are called from the following?

2 6189

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

3 11433

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 7274

what is sql and plsql

6 11012

what is the difference between to_char and to_date functions?

Infosys,

10 66837

what is organisational index?

1 5245

what are the advantages of cursors than procedures?

2 11849

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 31829

What is a 'instead of trigger'?

Eenadu, TCS,

3 12821

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is an escape character in sql?

986

What are actual parameters and formal parameters?

1048

What are the types of subqueries?

1026

What is data profiling in sql?

1024

what are aggregate and scalar functions? : Sql dba

1002

What are the parts of a sql statement?

1035

How delete all data from all tables in sql?

895

What is schema in sql example?

1106

Is mariadb a nosql database?

1011

What is the use of %rowtype?

984

What can you do with pl sql?

1044

What is synchronized subquery?

1104

How would you reference column values before and after you have inserted and deleted triggers?

1029

Can we use loop in sql?

937

Does truncate need commit?

899

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