Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

HCL SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is meant by DML?

 5 10641

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 14068

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 12013

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 17907

Types of locks in database ?

 8 74331

What is normalization ?

 9 19477

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

 4 14502

Can a table have two primary keys?

 44 84413

what is the boundary line in varrays?

 1 7304

When we give SELECT * FROM EMP; How does oracle respond?

 24 50191

Write one update command to update seqno field of a table on the basis of row number.

 4 15610

what is indexing, searching and user interface?

 1 4510

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

 3 9914

i want to display 1 to 10 numbers using one select statement.

 18 42397

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

 1 3680

Post New HCL SQL PLSQL Interview Questions


HCL SQL PLSQL Interview Questions


Un-Answered Questions

respected sir, I am Diptiranjan swain have already applied as IFFCO GET ONLINE FORM-2013.kindly,send me one set of previous year question paper.

1497

What is the importance of php?

517

What do you mean by dental erosion?

423

What is the difference between lookup (), lookup_ext () and lookup_seq ()?

1612

what is update statistics in sybase?

629




How do I change ctime in linux?

432

How do You Maintain a structure after getting cube test of low strength.

1821

What is phony in makefile?

534

Difference between hlaf and rlaf

1641

What is a child_process module in node.js?

232

What's the difference in using runnable and extends in threads?

526

What are drilldown reports?

84

Explain iglistkit?

445

a 230v transformer with step down ratio 19:1.it has 2000turns on primary and rated 25va calculate max primary current no of secondary turns volts/turn

943

How is declarative handling of exceptions done in struts ?

468