Sign Up Login


  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 34687

What are the usage of SAVEPOINTS?

 5 16331

What is correlated sub-query?

Oracle,

7 40896

What is difference between TRUNCATE & DELETE?

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

16 41786

What is the Subquery?

 4 6814

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

 4 13638

Explain UNION,MINUS,UNION ALL, INTERSECT?

 1 12794

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

 3 13233

What are the pre requisites?

 1 5031

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

Saama Tech,

6 32621

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

TCS,

5 19295

What is ROWID?

 8 18320

How will you a activate/deactivate integrity constraints?

 2 8384

when a procedure /package is getting invalidated?

TCS,

4 12549

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

TCS,

9 19300

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is dialect in sql?

700

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

700

What does := mean in pl sql?

753

Enlist the characteristics of pl/sql?

1487

Enlist the data types that can be used in pl/sql?

744




which command using query analyzer will give you the version of sql server and operating system? : Sql dba

700

Can we use ddl commands in pl sql?

763

What is delimiter sql?

701

What are triggers and its uses?

783

how can we know the number of days between two given dates using mysql? : Sql dba

742

What schema means?

674

Can sql function call stored procedure?

734

Why do we use sql constraints?

852

What are inner and outer joins examples of both?

691

What is the purpose of using pl/sql?

825

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