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 7928

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 10798

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 8796

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 13384

Types of locks in database ?

 8 70110




What is normalization ?

 9 15364

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

 4 12083

Can a table have two primary keys?

 44 69935

what is the boundary line in varrays?

 1 5810

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

 24 38224

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

 4 13595

what is indexing, searching and user interface?

 1 3401

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

 3 8330

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

 18 30231

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 2288

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions





Un-Answered Questions

How does c++ structure differ from c++ class?

37

What is tooth decay?

54

What are cultural traits?

1

Explain bit masking in c?

55

What’s the best way to decide what ad wins in a test? (What’s the best metric to use?)

26




How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.

2839

Do extension methods have to be static?

23

When we are using queries instead of scripting?

75

What is the maximum length allowed for a utp cable?

1

How to map IDL to Java ?

626

Will there be windows 11?

29

What is lambda in programming?

24

What is the difference between globalization and localization?

58

What is robotic process automation?

1

Is it possible in React to call the Child method from Parent?

5