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 10652

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 14077

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 12027

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 17926

Types of locks in database ?

 8 74349

What is normalization ?

 9 19487

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

 4 14515

Can a table have two primary keys?

 44 84470

what is the boundary line in varrays?

 1 7310

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

 24 50216

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

 4 15611

what is indexing, searching and user interface?

 1 4512

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

 3 9922

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

 18 42443

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 3692

Post New HCL SQL PLSQL Interview Questions


HCL SQL PLSQL Interview Questions


Un-Answered Questions

Which is not a valid keyword a) public b) protected c) guarded

736

What is xsl in xml?

454

what are the important infotypes in sap personnel administration?

615

What does ctrl j mean?

125

If you buy some rtos, what are the features you look for in?

438




How to Flush binary file from disk cache to disk ?

1545

What are deadlock prevention techniques?

600

Name the examples of some companies that are using hadoop structure?

390

What is the advantages of using c band for satellite communication?

577

What is the final method?

595

Can a class extends itself in java?

527

My switch statement works differently! Why?

510

Explain what are possible implementations of distributed applications in .net?

534

Is hashmap a data structure?

528

what is procedure of measuring operating length of mechanical seal .(in case of centrifugal pump)?

1805