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 7863

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 10627

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 8705

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 13244

Types of locks in database ?

 8 69906




What is normalization ?

 9 15207

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

 4 11986

Can a table have two primary keys?

 44 69462

what is the boundary line in varrays?

 1 5740

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

 24 37929

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

 4 13508

what is indexing, searching and user interface?

 1 3363

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

 3 8266

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

 18 29960

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 2259

Post New HCL SQL PLSQL Interview Questions




HCL SQL PLSQL Interview Questions





Un-Answered Questions

What is the ANSI C Standard?

89

Define a constructor?

50

What does this () mean in java?

14

Does anybody know anything about BirlaSoft? I got a job offer, they sent me a contract to sign and return, but thank God they didn't ask for any money! But, they said they would send me a check in the mail. And as my first "task" I would have to use that check to order a bunch of accounting software, and I would need to purchase this software ONLY from the vendors that THEY provide. Is this a scam to just get money? I'm wondering if they "own" the vendor they "work" with and launder money that way. I asked the person who was getting my information, as far as my name and address to send the check to, Why would I have to buy software to install in my home computer anyway? Couldn't they just send me a link for the software to download? I'm afraid of the check being fake. Because, if I deposit the check into my checking account and it turns out to be fake, then I'll owe the bank all that money! Hope to hear from someone soon. Thanks.

2146

What makes scientific data?

11




Describe primary index in teradata. And what are the available primary index types?

48

What are the key activities under sap grc access control?

9

How to create custom table using drupal module?

3

i want to know the genral questions in interviews if any body knows pls help me

1106

What is difference between mysql and mysql server?

7

Which join condition can be specified using on clause?

1

What is the meaning of testrunner class in cucumber?

1

plz send me the website of dmrc for previous questions papers

1073

How do I create a view in drupal 7?

1

Explain could I give you some feedback? I would change x, y, and z. Now could you try again? : insurance cold calling

24