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 170038

What is the difference between anonymous block and named blocks?

3 8862

what is inline view?

15 36412

what is the difference between implicit conversions and explicit conversions?

2 7823

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 11295

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 7259

What is Referential Integrity?

3 6479

can we update a view which is created from two tables

11 29873

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 12084

Can u create a primary key with out unique index.

8 11836

what are the demerits of sql?

1 4376

what is the difference between binary_integer and pls_integer

TCS,

2 30446

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

Microsoft,

1957

What cursor type do you use to retrieve multiple recordsets?

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

17 62262

Two Methods of retrieving SQL?

Atiric Software, Microsoft, Oracle, TCS, Wipro,

7 52757


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a data manipulation language?

389


What is the difference between mdf and ndf files?

394


What is the difference between left and left outer join?

355


How can you tell the difference between an index and a view?

335


How do I view output in sql developer?

407






What is the full form of sql?

392


What is normalization in sql?

370


What is a mutating table and a constraining table?

413


What is sql query optimization?

381


Write the alter statement to enable all the triggers on the t.students table.

501


Show code of a cursor for loop.

431


What is Histogram?

922


What is Difference Between Unique and Primary Key Constraints?

414


How do I create a sql script?

383


What is the difference between sql and mysql?

405