=============================================================================================================
www.sanonline.com

Questions Asked in KPIT Company (Pune) interview/Written test.

1. What are the Pseudo columns?
A) 	.      CURRVAL

	·	NEXTVAL

	·	LEVEL

	·	ROWID

	·	ROWNUM

2. What is Rollback segment?
A) One or more rollback segments are created by administrator for a database to 
        Temporarily store "undo" information. (Book: server manual page: 1-12).

3. What are Redo log files & Why they are used?
A) The Primary function of Redo Log files is to record all changes made to data. All the 
Changes made to the database are recorded in the Redolog.
The information in a Redolog file is used only to recover the database from system or media failure. 
4. What are the back ground processors?
A) SMON, PMON, RECO, LCKO, DBWR, LGWR, ARCH, CKPT.
5. What is checkpoint (ckpt)?
A) Refer page 1-18 of server manual.
6. Where you use the Pseudo column CURVAL?
A) CURRVAL returns the current value of a sequence.
7. What are the explicit cursor attributes?
A) The Explicit cursor attributes %FOUND, %ISOPEN, %NOTFOUND, and     
       %ROWCOUNT
8. How you check the implicit cursor attributes?
A) IF SQL%FOUND THEN  -- delete succeeded
     INSERT INTO new_emp VALUES (my_empno, my_ename,...);

       ...
    END IF;

IF SQL%NOTFOUND THEN  -- update failed
   INSERT INTO errors VALUES (...);
END IF;

IF SQL%ROWCOUNT > 10 THEN  -- more than 10 rows were deleted
   ...
END IF;


9. How many types of Exceptions are there & what are they?
A) 2 types, pre defined & user defined.
10. What is the Default Table space that is created when we create a Table space?
11. Give list of Pre defined Exceptions?
A) CURSOR_ALREADY_OPEN, DUP_VAL_ON_INDEX, INVALID_CURSOR, 
      INVALID_NUMBER, NO_DATA-FOUND, ROWTYPE_MISMATCH etc.,
12. What will be there in the System Table space?
A) The System Tablespace always contains the data dictionary tables for the entire
Database.
13.  What are the various column data types?
A) Char, Number,Varchar/Varchar2, Long,Raw.
14.  What you give for the column which has the data type LONG?
A) LONG columns store variable length character strings containing up to 2 gigabytes. 
     You can use LONG columns to store long text strings.
15. What is the difference between UNION & UNION ALL?
A) UNION       ----	All rows selected by either query.
     UNION ALL -----	All rows selected by either query, including all duplicates.
16.  What is the Clause that is necessary in an SQL statement when we give HAVING clause?
A) GROUP BY clause.
17.  How many types of SQL statements are there and what are they?
A) 3 types DDL, DML, DCL
18. What is the difference between Dedicated Server & Multi threaded server?
19. What is a database link?
A) Database Link is a named object that describes a "path" from database to another in 
     distributed database system.
 20.  What types of joins are there?
A) Equi join, Self join, Outer join, Cartesian join etc.,  
21.What are the phases in Two-Phase Commit?
A) Prepare Phase, Commit Phase

=============================================================================================================
www.sanonline.com