HCL Placement Paper - Aptitude and Technical Questions with Answers

Previous Years Solved Sample Placement Papers

1. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
   (A) Supertype entity
   (B) Subtype entity
   (C) Archetype entity
   (D) Instance entity
   Ans: C
   


2. You have a bucket of jelly beans. Some are red, some are blue, and some green. With your eyes closed, pick out 2 of a like color. How many do you have to grab to be sure you have 2 of the same?
   (A) 2
   (B) 4
   (C) 5
   (D) 6
   Ans: B
   


3. There is an escalator, and 2 persons move down it. A takes 50 steps and B takes 75 steps while the escalator is moving down. Given that the time taken by A to take 1 step is equal to the time taken by B to take 3 steps, find the number of steps in the escalator while stationary.
   Ans: Solve using relative speed and time.
   


4. If I walk with 30 miles/hr, I reach 1 hour early, and if I walk with 20 miles/hr, I reach 1 hour late. Find the distance between two points and the speed needed to reach exactly at 11 am.
   Ans: 120 miles and 24 miles/hr
   


5. At a certain moment, a watch shows a 2-minute lag, although it is fast. If it showed a 3-minute lag at that moment but gained 1/2 minute more a day than it does, it would show the true time one day sooner than it usually does. How many minutes does the watch gain per day?
   (A) 2
   (B) 5
   (C) 6
   (D) 4
   (E) 7.5
   Ans: E
   


6. What is an advantage of placing computations in SQL views?
   (A) To save users from having to write an expression.
   (B) To ensure that the results are consistent.
   (C) To accomplish both of the above.
   (D) None of the above is correct - computations cannot be placed in a view.
   Ans: C
   


7. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:
   (A) SELECT ... FROM ... WHERE.
   (B) {item, action}.
   (C) {for-each select}.
   (D) ...<\HTML>.
   Ans: B
   


8. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
   (A) VARCHAR2
   (B) CHAR
   (C) LONG
   (D) NUMBER
   Ans: A
   


9. The entity integrity rule states that:
   (A) No primary key attribute may be null.
   (B) No primary key can be composite.
   (C) No primary key may be unique.
   (D) No primary key may be equal to a value in a foreign key.
   Ans: A
   


10. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
    (A) First normal form
    (B) Second normal form
    (C) Third normal form
    (D) Fourth normal form
    Ans: B