Database Interview Questions - Motorola

1. Write a query to display row number with records?

2. What is replication?

3. 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

4. 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;

5. What one to one relationship indicates?

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.

6. What clause do you use in the query to help avoid a tablescan?

a) GROUP BY clause
b) HAVING clause
c) FROM clause
d) WHERE clause

7. How to view version information in Oracle?