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 14066

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 12011

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 74325

What is normalization ?

 9 19466

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

 4 14499

Can a table have two primary keys?

 44 84404

what is the boundary line in varrays?

 1 7303

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

 24 50186

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

 4 15606

what is indexing, searching and user interface?

 1 4508

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

 3 9913

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

 18 42395

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 3678

Post New HCL SQL PLSQL Interview Questions


HCL SQL PLSQL Interview Questions


Un-Answered Questions

What do xml namespaces actually contain?

503

What is the best c c++ compiler for windows?

554

IF a vendors charges WCT @8.75% what is the rate of TDs to be deducted against that? & can we take the Input of it?

5065

What is the advantage of open source?

468

Is analog and digital voice supported?

560




Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

518

Explain static reports?

535

Explain what is angular expression? Explain what is key difference between angular expressions and javascript expressions?

416

Can we change load factor of hashmap?

470

Assume that an app is not in foreground but is still executing code. In which state will it be in?

448

Is apache spark a framework?

179

When a dialog is requested for the first time, which method will android call from your activity?

550

What's the difference between impact sockets and regular sockets?

466

How do you define an altindx?

556

What is the configuration of systems when using load runner?

516