Motorola Placement Paper -: .Net Questions With Answers

Motorola Previous Years Solved Sample Placement Papers

1. Select the query through which you can display the records within a given range?

   A: select row from emp where rowname <=&rangeend

   B: select row from emp where rowname <&rangeend

   C: select column from emp where rowname &rangeend

   D: select column from emp where rowname <=&rangeend

   Ans: A

2. Select the query which allows you to select rownum and employee name (empname) from a record(emp)?

   A: select rownum, enum from emp;

   B: select colnum, ename from emp;

   C: select colname, enum from emp;

   D: select rownum, ename from emp;

   Ans: D

3. What does a one-to-one relationship indicate?

   A: More entities are needed.

   B: The model should be denormalized.

   C: The tables are not properly indexed.

   D: The model cannot be implemented physically.

   Ans: B

4. What clause do you use in the query to help avoid a table scan?

   A: GROUP BY clause

   B: HAVING clause

   C: FROM clause

   D: WHERE clause

   Ans: D