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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 165776

What is the difference between anonymous block and named blocks?

 3 8186

what is inline view?

 15 34335

what is the difference between implicit conversions and explicit conversions?

 2 7418

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

Oracle,

7 10329

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

Oracle,

3 6649

What is Referential Integrity?

 3 5974

can we update a view which is created from two tables

 11 28510

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

Oracle,

9 10814

Can u create a primary key with out unique index.

 8 10869

what are the demerits of sql?

 1 4044

what is the difference between binary_integer and pls_integer

TCS,

2 28523

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

Microsoft,

1742

What cursor type do you use to retrieve multiple recordsets?

Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

17 58018

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 50259

Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

What are all different types of collation sensitivity?

202

What are database links used for?

223

Can you join views in sql?

191

Can you upgrade sql express to full sql?

180

What is percent sign in sql?

180




how is myisam table stored? : Sql dba

205

What is rowtype?

181

What is data abstraction in sql?

175

what is row? : Sql dba

224

How do I run a query in pl sql developer?

189

Can we join same table in sql?

185

Is ms sql traffic encrypted?

163

What is foreign key in sql with example?

176

what is the difference between sql and t-sql? : Transact sql

227

how to use regular expression in pattern match conditions? : Sql dba

180

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