Essar Technical Questions: Technical Questions Part IV

Download PDF of This Page (Size: 120K)

Examrace Placement Series prepares you for the toughest placement exams to top companies.

  1. The standard source for standard input, standard output and standard error is

    1. the terminal

    2. /dev/null

    3. /usr/you/input,/usr/you/output/,/usr/you/error respectively

    4. None

    Ans (a).

  2. The redirection operators > and >>

    1. do the same function

    2. differ: > overwrites, while >> appends

    3. differ: > is used for input while >> is used for output

    4. differ: > write to any file while >> write only to standard output

    5. None of these

    Ans (b).

  3. The command grep first second third/usr/you/myfile

    1. prints lines containing the words first, second or third from the file/usr/you/myfile

    2. searches for lines containing the pattern first in the files second, third, and/usr/you/myfile and prints them

    3. searches the files/usr/you/myfiel and third for lines containing the words first or second and prints them

    4. replaces the word first with the word second in the files third and/usr/you/myfile

    5. None of the above

    Ans (b).

  4. You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

    1. CREATE INdEX emp_empno_idx ON employee, empno

    2. CREATE INdEX emp_empno_idx FOR employee, empno

    3. CREATE INdEX emp_empno_idx ON employee (empno)

    4. CREATE emp_empno_idx INdEX ON employee (empno)

    Ans. c

  5. Which program construct must return a value?

    1. Package

    2. Function

    3. Anonymous block

    4. Stored Procedure

    5. Application Procedure

    Ans. b

  6. Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints fromthe EMPLOYEE table?



    3. MOdIFY TABLE employee dROP CONSTRAINT employee_id_pk CASCAdE

    4. ALTER TABLE employee dROP PRIMARY KEY employee_id_pk CASCAdE

    5. MOdIFY TABLE employee dELETE PRIMARY KEY employee_id_pk CASCAdE

    Ans. a

  7. Which three commands cause a transaction to end (Chosse three)?

    1. ALTER

    2. GRANT

    3. DELETE

    4. INSERT

    5. UPdATE


    Ans. a, b, f

  8. Under which circumstance should you create an index on a table?

    1. The table is small.

    2. The table is updated frequently.

    3. A columns values are static and contain a narrow range of values

    4. Two columns are consistently used in the WHERE clause join condition of SELECT


    Ans. d

  9. What was the first name given to Java Programming Language.

    1. Oak-Java

    2. Small Talk

    3. Oak

    4. None

    Ans. a

  10. When a bicycle is in motion, the force of friction exerted by the ground on the two wheels is such that it acts

    1. In the backward direction on the front wheel and in the forward direction on the rear wheel.

    2. In the forward direction on the front wheel and in the backward direction on the rear wheel.

    3. In the backward direction on both the front and rear wheels.

    4. In the backward direction on both the front and rear wheels.

    Ans (d).

  11. A certain radioactive element A, has a half life = t seconds. In (t/2) seconds the fraction of the initial quantity of the element so far decayed is nearly

    1. 29%

    2. 15%

    3. 10%

    4. 45%

    Ans (a).

  12. Which of the following plots would be a straight line?

    1. Logarithm of decay rate against logarithm of time

    2. Logarithm of decay rate against logarithm of number of decaying nuclei

    3. Decay rate against time

    4. Number of decaying nuclei against time

    Ans (b).

  13. A radioactive element x has an atomic number of 100. It decays directly into an element y which decays directly into element z. In both processes a charged particle is emitted. Which of the following statements would be true?

    1. y has an atomic number of 102

    2. y has an atomic number of 101

    3. z has an atomic number of 100

    4. z has an atomic number of 101

    Ans (b).

  14. If the sum of the roots of the equation ax2 + bx + c = 0 is equal to the sum of the squares of their reciprocals then a/c, b/a, c/b are in

    1. AP

    2. GP

    3. HP

    4. None of these

    Ans (c).

  15. A man speaks the truth 3 out of 4 times. He throws a die and reports it to be a 6. What is the probability of it being a 6?

    1. ¾

    2. None of the above

    Ans (a).

  16. If cos2A + cos2B + cos2C = 1 then ABC is a

    1. Right angle triangle

    2. Equilateral triangle

    3. All the angles are acute

    4. None of these

    Ans (a).

  17. Image of point (3, 8) in the line x + 3y = 7 is

    1. (-1, 4)

    2. (-1, 4)

    3. (2, 4)

    4. (-2, 4)

    Ans (a).

  18. The mass number of a nucleus is

    1. Always less than its atomic number

    2. Always more than its atomic number

    3. Sometimes more than and sometimes equal to its atomic number

    4. None of the above

    Ans (c).

  19. The maximum KE of the photoelectron emitted from a surface is dependent on

    1. The intensity of incident radiation

    2. The potential of the collector electrode

    3. The frequency of incident radiation

    4. The angle of incidence of radiation of the surface

    Ans (c).

  20. Which of the following is not an essential condition for interference

    1. The two interfering waves must be propagated in almost the same direction or the two interfering waves must intersect at a very small angle

    2. The waves must have the same time period and wavelength

    3. Amplitude of the two waves should be the same

    4. The interfering beams of light must originate from the same source

    Ans (c).

  21. When X-Ray photons collide with electrons

    1. They slow down

    2. Their mass increases

    3. Their wave length increases

    4. Their energy decreases

    Ans (c).

  22. An electron emits energy

    1. Because its in orbit

    2. When it jumps from one energy level to another

    3. Electrons are attracted towards the nucleus

    4. The electrostatic force is insufficient to hold the electrons in orbits

    Ans (b).

  23. How many bonds are present in CO2 molecule?

    1. 1

    2. 2

    3. 0

    4. 4

Ans (d).