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 35555

What are the usage of SAVEPOINTS?

5 17365

What is correlated sub-query?

Oracle,

7 42214

What is difference between TRUNCATE & DELETE?

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

16 44952

What is the Subquery?

4 7496

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

4 14254

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13209

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

3 13784

What are the pre requisites?

1 5432

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

Saama Tech,

6 33604

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

TCS,

5 20266

What is ROWID?

8 19332

How will you a activate/deactivate integrity constraints?

2 9009

when a procedure /package is getting invalidated?

TCS,

4 13401

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

TCS,

9 20606

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Who developed sql?

959

Which is faster union or join?

901

How to add, remove, modify users using sql?

977

What is the maximum number of rows in sql table?

955

How show all rows in sql?

973

How does sql profiler work?

964

What is the most common sql injection tool?

993

What are the different types of joins in sql?

1651

What is the largest value that can be stored in a byte data field?

956

what is sub-query? : Transact sql

1039

What is the difference between view and stored procedure?

909

What is a parameter query?

1019

What is primary key and foreign key?

915

What is database sql?

982

Does sql between include endpoints?

951

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