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 8057

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 11028

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 9003

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 13664

Types of locks in database ?

 8 70489




What is normalization ?

 9 15624

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

 4 12258

Can a table have two primary keys?

 44 70976

what is the boundary line in varrays?

 1 5894

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

 24 38891

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

 4 13715

what is indexing, searching and user interface?

 1 3477

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

 3 8457

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

 18 30819

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 2349

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions


Un-Answered Questions

What is accountable marketing?

113

Explain the differences between vb.net and c#, related to oops concepts?

87

What is firmware? Why may I want to change it?

781

what happens when two consigitive ports of switch are connacted using one cross cabel with each other?(how the whole network gets down)

1685

Q.Explain ERMS? Q. What is coupning?

1424




What are all the important protocols that load runner supports?

89

why 15 kw motor winding resistance is low then 5 kw motor winding resistance?

1296

What are the different departments in RBI?

121

What is the shortcut key to insert row in excel?

1

What are the components in sap application server?

111

what does complexity means in an algorithim?? how it is calcutaed?

1418

What are the types of biases that can occur during sampling?

25

What are the advantages and disadvantages of using selenium as testing tool?

91

What are the capabilities of selenium webdriver or google webdriver or selenium 2.0?

102

What is discounting accounting and why depriciation of assets are mention in dicounting accounting?

944