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 9499

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

3 10291

what eliminate duplicate without using roenum and not

Matrix,

5 10925

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

HCL,

3 11456

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

4 20323

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

Polaris,

5 11863

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

6 28914

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 17777

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

3100

write a qurey for finding the length of the sting.

Infosys, TCS,

6 15145

how to create a database in oracle?

3 7203

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

Sollet Soft,

1 7230

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 22833

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 8986

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

2545

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the command used to fetch first 5 characters of the string?

1460

What are the different types of dbmss?

1054

Mention what plvcmt and plvrb does in pl/sql?

1196

What is the need of a partition key?

1025

Define commit, rollback and savepoint?

1079

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2133

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1056

how to check myisam tables for errors? : Sql dba

1388

how many triggers are allowed in mysql table? : Sql dba

1102

When is a declare statement required?

1193

how can we find the number of rows in a table using mysql? : Sql dba

1123

What is pl sql in dbms?

990

Can there be more than one function with a similar name in a pl/sql block?

1040

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

2066

How to display Row Number with Records in Oracle SQL Plus?

1090

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