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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Difference between SUBSTR and INSTR?

3 35810

What are the usage of SAVEPOINTS?

5 17630

What is correlated sub-query?

Oracle,

7 42520

What is difference between TRUNCATE & DELETE?

Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

16 45795

What is the Subquery?

4 7677

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 14451

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13312

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 13971

What are the pre requisites?

1 5531

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

Saama Tech,

6 33904

What is the fastest way of accessing a row in a table?

TCS,

5 20534

What is ROWID?

8 19672

How will you a activate/deactivate integrity constraints?

2 9190

when a procedure /package is getting invalidated?

TCS,

4 13637

how to create a primary key with out creating an index?

TCS,

9 21004

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is oracle sql called?

922

What does (+) mean in sql joins?

1059

what are the properties and different types of sub-queries? : Sql dba

1034

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

how to check myisam tables for errors? : Sql dba

1321

How to start oracle sql developer?

1034

how to include numeric values in sql statements? : Sql dba

1098

Explain clause in sql?

1029

Can ddl statements be used in pl/sql?

1142

what are date and time data types? : Sql dba

983

Explian rowid, rownum? What are the psoducolumns we have?

1000

How do you update a table in sql?

987

Why is sql better than hql?

991

Which are the different case manipulation functions in sql?

1023

What is a function in oracle pl sql?

1037

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