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 10565

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 13958

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 11899

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 17797

Types of locks in database ?

8 74236

What is normalization ?

9 19380

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

4 14439

Can a table have two primary keys?

44 83953

what is the boundary line in varrays?

1 7259

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

24 49972

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

4 15549

what is indexing, searching and user interface?

1 4481

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

3 9860

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

18 42166

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 3634

Post New HCL SQL PLSQL Interview Questions


HCL SQL PLSQL Interview Questions


Un-Answered Questions

In job processing, what happens in conversion stage?

697


What is the default session timeout duration and how can it be set?

408


How many rows can mysql hold?

447


Name the numeric constants representing max, min values?

492


Explain a few methods of overloading best practices in java?

478






How many postgresql users are there, worldwide?

538


What is hierarchical relationship in SFDC?

203


What does ls stand for linux?

432


What is Flow Switch in UiPath?

450


How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

666


Is outlook 365 the same as outlook 2019?

1


Hai iam a VAT Registered dealer am a manufacturer and am going to sell my products to unregistered dealers i can pay d 4% vat.. how can i make my bill format for this sgrc.gy@gmail.com. anybdy kno means pls mail me.

1568


What are match types?

309


When should you use a reducer?

342


Define joiner transformation?

565