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 7696

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 10416

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 8473

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 12881

Types of locks in database ?

 8 69347




What is normalization ?

 9 14862

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

 4 11746

Can a table have two primary keys?

 44 68203

what is the boundary line in varrays?

 1 5616

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

 24 37020

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

 4 13320

what is indexing, searching and user interface?

 1 3271

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

 3 8106

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

 18 29257

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 2181

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions





Un-Answered Questions

Give 10 points of differences between C & C++.

20

What are the Color reduction techniques for graphics?

878

What is your recommendation for a query running very slow? : sql server database administration

12

What do you mean by the term “percolate up”?

9

IF TVM OF TRANSFORMER SHOWS POWER FACTOR ON 33 KV SIDE AS 0.97 LAGGING AND ON 132 KV SIDE IS 0.75 LEADING.IS THIS CORRECT.WHERE IS PROBLEM.

1145




Explain about Views?

20

Assuming that the density of the solution is the same as the density of water (density of water=1.000g/ml), calculate the mass of water for both reactions using: mass of water = Volume of water Density of water. Mass of water =

1323

What are the system tools you can use?

1011

How to use Hive using the command line and Beeline?

139

Explain ibm z?

5

When u create a new record?

1

i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

923

what is the function and use of cable differential protection relay?

1773

Electrical symbol

841

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

908