SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is mutating table?

Saama Tech,

11 51070

How to call DDL statements from pl/sql?

4 25788

How to perform a loop through all tables in pl/sql?

MBT, Evosys,

4 8991




How to maintain the history of code changes of pl/sql?

2 9153

what are Dynamic SQL statements?

9 15402

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 7747

What is pl/sql and what is it used for?

4 10274

what is constraining table?

2 8709




How pl/sql source code can be protected?

2 6832

What is the result, when NULL is compared with NULL?

TCS,

21 30054

What can be a size of a pl/sql block? Is there any limit?

2 8446

what are %TYPE and %ROWTYPE? what is the difference?

Sail, ICICI, Saama Tech,

7 35376

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 4355

What are the advantages of VIEW?

5 26657

How many LONG columns are allowed in a table?

CTS,

6 15108


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Whis is not false in primary key?

155


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

771


i have some prob lem to tell me about my self in interview first round ...

709


when MSQL8.0 is in market

790


What is Materialized View? In What Scenario we Use Materialized View?

6379






what is the difference difference between procedure and packages

5275


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

1340


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

803


What is Temp Table and type of temp table?

536


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1684


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

729


Difference between global and parameter variables?

590


What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1082


C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

1171


What is your daily office routine?

1019