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 35774

What are the usage of SAVEPOINTS?

5 17602

What is correlated sub-query?

Oracle,

7 42496

What is difference between TRUNCATE & DELETE?

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

16 45678

What is the Subquery?

4 7652

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

4 14425

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 13297

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

3 13951

What are the pre requisites?

1 5519

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

Saama Tech,

6 33861

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

TCS,

5 20496

What is ROWID?

8 19619

How will you a activate/deactivate integrity constraints?

2 9175

when a procedure /package is getting invalidated?

TCS,

4 13613

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

TCS,

9 20941

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is snowflake sql?

1065

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1054

Write a sql query to find the names of employees that begin with ‘a’?

1000

What is the primary key?

945

How many row comparison operators are used while working with a subquery?

1027

Which certification is best for sql?

981

How can you fetch first 5 characters of the string?

1007

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1048

How to place comments in pl/sql?

1148

How do I make my sql query run faster?

934

What are the sql commands?

1160

What is rownum in sql?

1032

How can I see all tables in sql?

1062

What is a rank in sql?

952

Is left join inner or outer by default?

1014

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