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

Difference between SUBSTR and INSTR?

3 25594

What are the usage of SAVEPOINTS?

5 13558

What is correlated sub-query?

Oracle,

7 36972

What is difference between TRUNCATE & DELETE?

Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

16 33065

What is the Subquery?

4 4723

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 10427

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 11728

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 11512

What are the pre requisites?

1 4062

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

Saama Tech,

6 29452

What is the fastest way of accessing a row in a table?

TCS,

5 14751

What is ROWID?

8 15023

How will you a activate/deactivate integrity constraints?

2 6893

when a procedure /package is getting invalidated?

TCS,

4 9164

how to create a primary key with out creating an index?

TCS,

9 14281


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How do you create an update query?

114


What is the difference between function and procedure in pl/sql?

142


What is bind reference and how can it be created?

168


what is an index? : Sql dba

139


Is it possible to link two groups inside a cross products after the cross products group has been created?

160






How can a pl sql block be executed?

120


Can we use loop in sql?

116


what is unique key constraint? : Sql dba

140


What is the advantage of index in sql?

122


How to run sql*plus commands in sql developer?

148


What is sql injection owasp?

99


What is the usage of nvl function?

159


What is the difference between between and in condition operators?

141


What is recursive stored procedure?

145


Is subquery faster than join?

118