Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 8399

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 11413

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 9391

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 14145

Types of locks in database ?

8 71176





What is normalization ?

9 16124

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

4 12606

Can a table have two primary keys?

44 72891

what is the boundary line in varrays?

1 6100

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

24 40320

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

4 13959

what is indexing, searching and user interface?

1 3617

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

3 8672

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

18 32052

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 2515

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions


Un-Answered Questions

What are the tools for process improvement?

133


Explain what is tableau data extract?

70


Is a hash table an array?

127


Can we create users in blue prism?

1


Explain how are 16- and 32-bit numbers stored?

198






What is Metrics designer?

162


what is the reason of hat and work is not conserved energy?

989


Can we create dynamic classes in objective c?

1


Name the types of motors used in vacuum cleaners, phonographic appliances, vending machines,refrigerators, rolling mills, lathes, power factor improvement and cranes.

194


What are the advantages of the code-behind feature?

146


Explain how to create prt master records?

204


what is difference between set screen and call screen ?

172


What are the uses of API's in cloud services?

192


What is ioc container in spring?

19


How many types of normalization are there?

115