ஏதாவது உருப்படியாய் செய்யலாம்னு,...........

Sample Test for Oracle: It may be useful for the time of Online certificatation. (SQL Part 1)
Oracle 9i

1. The following select statement executes successfully:

Select last_name, job_id, salary AS sal from employee;

True / False

2. Which two group functions can be used for both numeric as well as string?
a. AVG
b. SUM
c. Variance
d. MIN
e. MAX

3. You want to calculate how many rows in the table. What is the keyword to retrieve the same?a. Sum
b. Min
c. Max
d. Count
e. Cal

4. Which one is the correct syntax for dropping the Constraints?
a. > drop constraint ;
b. > alter table drop Constraints;
c. > alter table drop Constraints
d. > alter constraint from
e. None of the above

5. We are granting role to A to create, delete, update with Admin option. A is granting delete, update with admin option to B, C and E. Now we are revoking Admin option from A? What will be the result?

a. A can create / delete/ update on existing table
b. B only can enjoy the option
c. A, B, C, E can avail the privileges
d. B, C, E only avail the privileges
e. None of the above

6. If you are dropping a table,
a. all data is deleted from the table
b. Any views and synonyms remain but are invalid
c. Any pending transactions are committed
d. Only the creator of the table or a user with drop any table privilege can remove a table.
e. Table only dropped, all above are not possible.

1. a and b are correct
2. c only correct
3. d and e only correct
4. a,b,c,d are correct
5. None of the above.

7. A unique index is automatically created for a primary key column.

True / False

8. What is wrong with this statement?

Select employee_id, last_name from employee where salary = ( select MIN(salary) from employee GROUP BY department_id);

a. returns rows
b. will through an error
c. no rows selected
d. none of the above

9. Naming rules of columns:
a. Must begin with a letter
b. Must be 1-30 characters long
c. Must contain only a-z, A-Z, 0-9, _, $, and #
d. Must not be an oracle server reserved word
e. Must not duplicate the name another object owned by the same user

1. a is correct
2. b and c and d are correct
3. d only correct
4. all above are correct
5. a and e only correct

10. If you are truncating a table
a. it removes all rows from a table
b. Releases the storage space used by that table
c. You cannot roll back row removal when using truncate

1. a is correct
2. b is correct
3. a and c are correct
4. b and c are correct
5. all are correct