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 33956

What are the usage of SAVEPOINTS?

 5 15591

What is correlated sub-query?

Oracle,

7 39663

What is difference between TRUNCATE & DELETE?

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

16 39568

What is the Subquery?

 4 6160

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

 4 13028

Explain UNION,MINUS,UNION ALL, INTERSECT?

 1 12478

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

 3 12704

What are the pre requisites?

 1 4758

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

Saama Tech,

6 31848

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

TCS,

5 18471

What is ROWID?

 8 17405

How will you a activate/deactivate integrity constraints?

 2 7935

when a procedure /package is getting invalidated?

TCS,

4 11840

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

TCS,

9 18184

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are date and time functions in mysql? : Sql dba

524

What is a primary key? Explain

528

Is it possible for a table to have more than one foreign key?

568

Can we edit a view in sql?

535

What are database links used for?

580




Is primary key always clustered index?

525

What is trigger explain it?

537

What is AUTH_ID and AUTH_USER in pl/sql ?

1674

What are pl/sql cursor exceptions?

559

Can procedure in package be overloaded?

597

what are the disadvantages of mysql? : Sql dba

557

what is a composite primary key ? : Sql dba

572

What is mdb stand for?

544

Do prepared statements prevent sql injection?

517

Does sqlite need a server?

530

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