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 35814

What are the usage of SAVEPOINTS?

5 17633

What is correlated sub-query?

Oracle,

7 42521

What is difference between TRUNCATE & DELETE?

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

16 45802

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 14452

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13313

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

3 13972

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 33907

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

TCS,

5 20538

What is ROWID?

8 19673

How will you a activate/deactivate integrity constraints?

2 9192

when a procedure /package is getting invalidated?

TCS,

4 13640

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 a parameter query?

1083

Explain the purpose of %type and %rowtype data types?

928

How delete all data from table in sql?

1016

Does a primary key have to be a number?

963

What is sharding in sql?

984

How to use sql*plus built-in timers?

1200

How do you use collections in procedure to return the resultset?

2238

Explain the commit statement.

1159

What is constant in pl sql?

1022

What is sql entity?

1105

What is substitution variable in pl sql?

1044

Explain the difference between triggers and constraints?

975

How sql query is executed?

1129

What is rownum and rowid?

1032

Explain the the delete statements in sql?

1062

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