Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Give the structure of the function ?

2 4699

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

3 7572

What is Overloading of procedures ?

2 4877

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

Symphony,

2 7339

What are two parts of package ?

Infosys,

2 10889

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

JDA,

2 13388

How packaged procedures and functions are called from the following?

2 4479

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

3 8650

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 4684

what is sql and plsql

6 7943

what is the difference between to_char and to_date functions?

Infosys,

10 54164

what is organisational index?

1 3313

what are the advantages of cursors than procedures?

2 9903

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 22491

What is a 'instead of trigger'?

Eenadu, TCS,

3 9550


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

how many sql dml commands are supported by 'mysql'? : Sql dba

175


Why do we use partitions in sql?

139


What are the constraints available in sql?

191


Where the sql database files are stored?

153


what is check constraint? : Sql dba

155






how do you know if your mysql server is alive? : Sql dba

163


List out the acid properties and explain?

193


What are three advantages to using sql?

153


Why indexing is needed?

151


what is auto increment? : Sql dba

199


How do I count records in sql?

138


Explain constraints in sql?

190


What is an exception in pl/sql?

166


what is a composite primary key ? : Sql dba

187


Could you please provide oca (oracle 10g) dumps for my certification ?

3877