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

what is the bond code in materialized view?

 2480

what is the boundary line in varrays?

HCL,

1 7300

what is explain plan?

 4 19049

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

Accenture, HCL, Infosys,

24 50181

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

 2 11959

what is inline command?

 2 8497

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 17181

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 34697

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 9879

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 10331

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

 2 6416

What is differance unique key and primary key.

EDS,

7 9534

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 7550

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

 2 7542

how to retrive only second row from table?

IBM,

31 45118

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the non-clustered index in sql?

580

How do I tune a sql query?

502

Define implicit and explicit cursors.

620

Is it possible to include an insert statement on the same table to which the trigger is assigned?

552

What are the two types of cursors in pl sql?

525




Explain about various levels of constraint.

516

how to include character strings in sql statements? : Sql dba

544

What is microsoft t sql?

483

Which is faster union or join?

484

In pl/sql, what is bulk binding, and when/how would it help performance?

519

What is normalization? How many normalization forms are there?

544

what is try_catch block in procedure

1185

What is the difference between union and union all command?

537

What is the use of count (*) in sql?

534

what are dynamic queries in t-sql? : Transact sql

550

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