NIITJob Interview Placement Paper Pattern

July 21, 2008 · Filed Under NIIT Placement Papers, Placement Papers

Don't want to miss a single bit? Subscribe By Email for Daily Jobs

Company Name : NIIT

Type : Experienced Job Interview, Question Paper

1) Query to find nth highest salary

2) Query to delete duplicate rows

3) Instead of Trigger

4) How many trigger can be applied to a table

5) Trigger syntax

6) Union/intersection/minus operators difference b/w union and union all

7) Row to column queries

Packages and usage

9) Index (clustered/non-clustered indexes)

10) Exception Handling

11) Master/Detail block default triggers

12) Execution sequence in D2K trigger(Item level/Block level/Form level)

13)Procedure function package defination and difference

14) Fine Tuning how to minimize the cost of the queries and performance

15) Outer joins

16) which clause is executed first Select, Group By, Where, ORder by, Having in a select statment

17) SELECT X, Y FROM A UNION SELECT E, F FROM B ORDER BY E WHAT IS THE OUTPUT OF ABOVE QUERY

18) CALLING FUNCTION AND PROCDDURE FROM SQL PROMPT

19) SELECT ROWNUM,EMPID,NAME FROM EMP ORDER BY ROWID WHAT IS EFFECT OF ORDER BY CLAUSE IN ABOVE QUERY

20) SYNONYMS CREATION/USAGE/BENIFITS

21) CONVERT A NUMBER TO ITS WORD EQUAVALENT I.E., 12900 TWELVE THOUSAND NINE HUNDREDS

Subscribe