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 9423

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

3 10179

what eliminate duplicate without using roenum and not

Matrix,

5 10728

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

HCL,

3 11329

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

4 20200

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

Polaris,

5 11693

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

6 28687

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 17561

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

3050

write a qurey for finding the length of the sting.

Infosys, TCS,

6 14995

how to create a database in oracle?

3 7076

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

Sollet Soft,

1 7157

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 22489

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 8881

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

2490

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the use of double ampersand (&&) in sql queries? Give an example

1139

What is the use of non clustered index?

996

What is a left inner join?

1015

What is an oracle stored procedure?

1053

Explain about various levels of constraint.

949

How do I start sql profiler?

997

What is out parameter used for eventhough return statement can also be used in pl/sql?

1078

What is a pl/sql block?

1230

How delete all data from table in sql?

1019

Why coalesce is used in sql?

1012

What is sql deadlock?

1145

How do you identify a primary key?

1063

What is a memo field?

969

what is denormalization. : Sql dba

1113

what is the difference between char_length and length? : Sql dba

1045

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