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 6452

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

3 10068

What is Overloading of procedures ?

2 7540

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

Symphony,

2 9308

What are two parts of package ?

Infosys,

2 17416

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

JDA,

2 16391

How packaged procedures and functions are called from the following?

2 6282

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

3 11558

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 7400

what is sql and plsql

6 11299

what is the difference between to_char and to_date functions?

Infosys,

10 67200

what is organisational index?

1 5313

what are the advantages of cursors than procedures?

2 11994

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32430

What is a 'instead of trigger'?

Eenadu, TCS,

3 12959

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Do stored procedures prevent sql injection?

966

What is a sql select statement?

1040

explain normalization concept? : Sql dba

1045

Write a sql query to convert all character to uppercase after hypen.

1438

what are aggregate and scalar functions? : Sql dba

1057

What is a design view?

924

What is the purpose of a secondary key?

975

Is id a reserved word in sql?

1145

How can we make an if statement within a select statement?

1013

What are the constraints available in sql?

1047

What are the types of join in sql?

1103

how to create a new table by selecting rows from another table in mysql? : Sql dba

1101

what are the types of subquery? : Sql dba

1105

What is the non-clustered index in sql?

1064

How do you rename a table in sql?

1111

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