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 11454

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 15000

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 13007

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 19220

Types of locks in database ?

8 75278

What is normalization ?

9 20611

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

4 15288

Can a table have two primary keys?

44 89411

what is the boundary line in varrays?

1 7731

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

24 53635

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

4 16269

what is indexing, searching and user interface?

1 4884

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

3 10523

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

18 44837

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 4387

Post New HCL SQL PLSQL Interview Questions


HCL SQL PLSQL Interview Questions


Un-Answered Questions

What is catalog profile?

660


why athanol-water mixtuere have maximum viscocity in wt% 40?

1470


Why do we use class in c#?

667


What's new in sql management studio for sql server? : sql server management studio

766


Explain the difference between int and int32?

674






How do i write a test condition to test the following simple program with the intention of 100% statement coverage Print “Hello World” If Date $ = ‘01-01-2000’ then Print “Happy New Year” END IF PRINT “The date is = “Date $ PRINT “The time is = “Time $ END Could anyone please clarify in detail. Would really appreciate it....

1811


Why is it called c sharp?

684


How can we work with error tags?

724


Give me the asset revaluation (at the time of asset value increase & decrease) journal entrys?

1867


Discuss the potential biases that AI might introduce in legal applications.

41


can u please explain what is the exact difference between qtp8.2 and 9.0

1873


what is the command to see the error log?

5


Actinium is part of the actinide series. Could you explain the significance of this series and its placement in the periodic table?

320


What is the origin of CSS ?

567


Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.

2149