HCL Interview Question Paper's

paper 01

1. What is the physical and logical structure of oracle?
PHYSICAL: DATAFILES,CONTROL FILES,REDO LOG FILES
Logical: TABLESPACE, SEGMENTS,EXTENTS,DATABLOCKS

2. Difference between oracle 8i  & oracle 9i?

8i                                                         9i
NO MERGE                                       MERGE
------                                                     INSERT ALL,INSERT FIRST
SNAPSHOT                                       MATERIALIZED VIEW
            ---------                                      NATURAL JOIN,FULL OUTER JOIN,
                                                `              USING,ON-à KEYWORDS
                                                                LEFTOUTER JOIN,RIGHT OUTER JOIN
         

3. how can you open multiple files in Unix  is it possible?
 VI file1 file2 file3

4. how can you  connect from Unix to database is there any login or password ?
sqlplus
enter password : / as sysdba

5. what is the version you are using?
Oracle 9i

6. When u create a table tablespace is created what is tablespace?
 System tablespace

7. what is the syntax of procedures?
 CREATE OR REPLACE PROCEDURE procedure_name( arg  in type ……) is

8. What is overloading?
Function or procedure with same name but different no/types of parameter
Created procedure has 5 parameters if the same procedure is called with 3 parameters will it work? What is the error will it give?
NO, It will give error as -------à WRONG NUMBER OR TYPES OF ARGUMENT CALLS IN CALL TO ‘PROCEDURE’

9.how many types of cursors  are there?
2 types
implicit cursor
explicit cursor

10 what are the attributes of cursors in explicit & implicit?
For explicit                                                For implicit
Cursor_name%ISOPEN                           SQL%ISOPEN
Cursor_name%FOUND                           SQL%NOTFOUND
Cursor_name%NOTFOUND                   SQL%FOUND
Cursor_name%ROWCOUNT                  SQL%ROWCOUNT

11 How does u open loop for cursors?
OPEN  cursor_name;

12 How can u select data into variables using select command ?
SELECT  COLUMNS INTO VARIABLES  FROM TABLE_NAME;

13 if where condition is not  specified  what error it will give how do u handle that error , what is the exception  pre_defined exception u use.?
Ans: too_many_rows.

14 What is %rowtype how do you declare it in plsql block write it ?
It is used to define the data types of an entire row
Name  ename%rowtype
What is the structure of plsql block
 [DECLARE]
…
…
BEGIN
….
…
[EXCEPTION]
…
…
END;


paper 02

1.What is meant by procedures?
Ans)It is stored sub program which is used to perform some action.

2.What is mean by functions?
Ans) It is stored sub program which is used to compute an expression.

3.What is the difference between procedures and functions?
            PROCEDURE                                                            FUNCTION
It may or may not returns more than one value                it returns only one value.
We cannot use this in expressions                                   we can use it
We cannot use it in the  select stmt                            we can use but it shouldn’t contain OUT parameters

4.What is meant by packages?
Ans) Package is an object which is used to group the subprograms,variables,collections,constants,cursors

5.What is  meant by triggers?
Trigger is a stored procedure which will fire when ever an event occur.

6.What is meant by exception and what are the types of exceptions?
Exception is an error handling mechanism in pl/sql .
There are 3 types of exceptions
>oracle predefined.
>oracle non predefined.
>User defined.

7.What is meant by cursor and how many types of cursors are there?
Cursor is a name given to a private sql area.
There are 2 types of cursors.
Implicit
Explicit.


paper 03

1. Introduce your self?
2. Explain about your current project?
3. How can u rate your self in pro*c?
6/10
4. What is a cursor?
Cursor is a name given to private sql area.
5. Types of cursor?
6. What is exception?

7. What is pragma INIT_EXCEPTION?
to assign a our own exception name to predefined oracle error code.
8. What is user-defined exception?

Table A                                                      table B

a1   a2                                            b1        b2
 5    2                                              5          2
 4    3                                              1          6

8. What is the output of the queries?

Select * from a,b?
Select a. *, b. * from a, b?
Select a.* from a,b where a.a1=b.b1?
Select A.* from a ,b?

9. Materialized view?
Materiliazed is local copy of remote database.

10. difference between procedure and function?
11. what is trigger?
12. Do u know about autonomus_transaction? What is it?
Autonomous transaction is an independent transaction which is initialized by main transaction







                                                            HCL HR questions

1.Tell me about your current project?
ERP
2.Tell me about your self?
3.What are your strengths?
4.What are your weaknesses?
5.Justify about your strengths and weaknesses?
6.Why do you want to join in HCL?
7.Whar do you know about HCL?
8.What is meant by CMM level5?
CapabilityMaturityModel
9.What is meant by CMMI level5?
10.What is meant by PCMMi level5?
11.What is meant by ISO?
12.why ur leaving the company?
13. u have any queries?