1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Difference between SUBSTR and INSTR?

 3 34002

What are the usage of SAVEPOINTS?

 5 15643

What is correlated sub-query?

Oracle,

7 39753

What is difference between TRUNCATE & DELETE?

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

16 39775

What is the Subquery?

 4 6196

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

 4 13074

Explain UNION,MINUS,UNION ALL, INTERSECT?

 1 12505

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

 3 12731

What are the pre requisites?

 1 4772

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

Saama Tech,

6 31907

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

TCS,

5 18563

What is ROWID?

 8 17467

How will you a activate/deactivate integrity constraints?

 2 7973

when a procedure /package is getting invalidated?

TCS,

4 11914

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

TCS,

9 18300

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the purpose of design view?

527

What is function and procedure?

569

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

578

Inline the values in PL/SQL, what does it mean.?

633

what is clause? : Sql dba

592




Can we create index on primary key?

524

Can we group by two columns in sql?

507

What is user defined functions?

580

Which certification is best for sql?

542

explain about mysql and its features. : Sql dba

554

Can a table have no primary key?

557

What are the triggers associated with image items?

621

Can I learn sql in a week?

554

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

623

What is substitution variable in pl sql?

505

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