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 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

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