SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is the bond code in materialized view?

3002

what is the boundary line in varrays?

HCL,

1 8429

what is explain plan?

4 21322

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

Accenture, HCL, Infosys,

24 57875

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

2 13063

what is inline command?

2 9677

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 19348

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 37261

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 12228

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 12919

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

2 7373

What is differance unique key and primary key.

EDS,

7 11619

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 8890

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

2 8800

how to retrive only second row from table?

IBM,

31 53177

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is the bond code in materialized view?

3002

what are local and global variables and their differences? : Sql dba

1070

What are the different sql commands?

1073

Explain the advantages and disadvantages of stored procedure?

1148

How to handle bulk data?

1310

what are the limitations of identity column? : Transact sql

1108

What is trigger explain it?

1016

What is difference between inner join and cross join?

969

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1158

How to use sql statements in pl/sql?

1120

How can we debug in PL/SQL?

1135

What is user defined functions?

982

How to run pl sql program in mysql?

1020

What is oracle sql developer?

1048

How do I view a sql trace file?

1028

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