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 7788

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 10543

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 8589

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 13085

Types of locks in database ?

 8 69674




What is normalization ?

 9 15037

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

 4 11844

Can a table have two primary keys?

 44 68856

what is the boundary line in varrays?

 1 5668

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

 24 37498

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

 4 13404

what is indexing, searching and user interface?

 1 3318

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

 3 8176

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

 18 29615

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 2214

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions





Un-Answered Questions

How can heat be applied to acrylic?

19

Write a program using linq to find the sum of first 5 prime numbers?

1

What are the events in abap/4 language? : abap hr

25

Determine ootb functionality in siebel.

19

How to jump to a particular line in a file using vim editor?

5




What is a 'bucket field'?

3

What are the standard profiles in salesforce?

3

Your project was just completed. Due to some unfortunate circumstances, the project was delayed causing cost overruns at the end of the project. Which of the following is true? A. You document the circumstances as lessons learned. B. You pay particular attention to archiving the financial records for this project. C. Your project ended due to starvation because of the cost overruns. D. You document the circumstances surrounding the project completion during the Scope Verification process.

23

tell about your family, education etc.

19

hi friend i have selected in ssc cgle as accountant in audit department. can anyone tell about the work of accountant in audit department?

1156

Why to use nested classes in java? (Or) what is the purpose of nested class in java?

11

why is service tax set off is consider while calculating wct tds

872

Is the ajaxcontroltoolkit.dll file installed in the global assembly cache? : asp.net ajax

16

Explain mutable storage class specifier.

14

What is the difference between the distributed database and the traditional database?

1