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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

How can we overcome recursive triggers in SQL?

iFlex,

1 9421

how to create user in sql and how to set password for that?

3 10174

what eliminate duplicate without using roenum and not

Matrix,

5 10722

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

HCL,

3 11327

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 20197

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

Polaris,

5 11689

What is a REF CURSOR? Compare strong and week ref cursor types.

6 28678

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

Polaris,

7 17550

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

3046

write a qurey for finding the length of the sting.

Infosys, TCS,

6 14985

how to create a database in oracle?

3 7069

In a package if we have 10 procedures or functions,How to know which will execute first?

Sollet Soft,

1 7153

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

Oracle, TCS,

13 22479

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

IBM,

2 8879

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2486

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to check server status with 'mysqladmin'? : Sql dba

1075

Is foreign key mandatory?

1001

what is transaction? : Sql dba

1007

Is delete faster than truncate?

1002

Can we insert data in view?

962

Which is faster joins or subqueries?

989

How can you view the errors encountered in a trigger?

962

What is trigger explain with example?

1037

What is the clause we need to add in function body to return variable?

1012

Show code of a cursor for loop.

1054

tell us something about heap tables. : Sql dba

1098

What is sql not null constraint?

1035

Write the alter statement to enable all the triggers on the t.students table.

1125

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2262

What is bind reference and how can it be created?

1018

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