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

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