SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Regarding joins what are the differences you observed in oracle 9i and sql server?

Choice Solutions,

3 6562

What is a bitmap index?

Choice Solutions, Infosys,

4 22036

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 5838

What are Lexical Parameters.How They are used in Reports 6i

eicc,

2 30092

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

CGCI,

8 13823

What is the difference between RDBMS and DBMS?

Practical Viva Questions, Sapient, Stag Computers,

20 71579

what is purge command explain about oracle performance tuning

Accenture, eCentric Solutions,

2 24903

what is global table

iFlex,

7 12684

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

HCL,

4 14456

what is bulk bind

TCS,

4 13339

what is mean by forward declaration and where we'll use it.

TCS,

4 23463

what is the order of pre-defined exceptions.

TCS,

6 14642

Can a table have two primary keys?

HCL, MetaCube,

44 84147

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

Hexaware,

4 10686

check whether all the emp numbers are indeed unique.

6 15312


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How many types of triggers exist in pl/sql?

540


How to run sql commands in sql*plus?

559


What is the unique index?

502


Name some usages of database trigger?

537


What are the events on which a database trigger can be based?

568






what is the difference between $message and $$message? : Sql dba

522


What is nvarchar in sql?

502


Why select is used in sql?

490


Does user triggers have entry for trigger with compilation errors?

574


Explain the savepoint statement.

571


What is constant in pl sql?

493


How do you identify a primary key?

602


Can we use ddl statements in stored procedure sql server?

497


How many types of literals are available in pl sql?

491


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

526