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 bond code in materialized view?

2296

what is the boundary line in varrays?

HCL,

1 6897

what is explain plan?

4 18284

When we give SELECT * FROM EMP; How does oracle respond?

Accenture, HCL, Infosys,

24 46845

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 11584

what is inline command?

2 8069

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 16414

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

Wipro,

8 33699

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

TCS,

7 8986

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

Accenture,

7 9167

Can we write create command in the plsql block?if possible how?

2 6111

What is differance unique key and primary key.

EDS,

7 8824

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then when no_data_found then when too_many_rows then end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

Satyam,

3 7076

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 7171

how to retrive only second row from table?

IBM,

31 41962


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are properties of a transaction? : Sql dba

435


How do I create a memory optimized filegroup?

369


Is it possible for a table to have more than one foreign key?

424


What is nvarchar in sql?

368


Why does sql need a server?

379






What version is sql?

394


Can we use ddl statements in stored procedure sql server?

359


How long it takes to learn pl sql?

360


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

465


what is the difference between a web-garden and a web-farm? : Sql dba

376


what are the join types in tsql? : Transact sql

427


Which is faster union or join?

343


How are sql commands classified?

389


What is sql and how does it work?

385


Can you selectively load only those records that you need? : aql loader

457