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 8232

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 11226

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 9180

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 13921

Types of locks in database ?

 8 70870




What is normalization ?

 9 15845

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

 4 12455

Can a table have two primary keys?

 44 71948

what is the boundary line in varrays?

 1 5994

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

 24 39661

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

 4 13836

what is indexing, searching and user interface?

 1 3538

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

 3 8561

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

 18 31491

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 2433

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions


Un-Answered Questions

Define angle modulation?

104

How to remove the directory in unix?

131

what is the relationship between soil pH and base saturation capacity?

1410

What is php variable?

107

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

108




Explain lock contention?

146

What is observer in laravel?

71

What is a closure javascript? Explain

101

What Maximam Gap Taibaar & Bush

1283

How does combination of functions reduce memory reuirement in embedded system?

110

What is current CRR and SLR?

168

How can users add to label the values of individual chart elements?

66

What are the reasons for the parallel operation of transformers?

134

How to add csrf protection in laravel?

95

How do I get rid of the blue screen on windows 10?

80