Oracle database 10g:Administration I Sample Questions:

1. User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose two.)

A) null lock on the row being updated
B) a shareable table lock for the table containing the row
C) ROW EXCLUSIVE lock for the row being updated
D) shared row-exclusive lock for the row being updated
E) exclusive table-level lock for the table containing the row
F) ROW SHARE lock for the row being updated
G) null lock on the table containing the row

2. Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

A) Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
B) Reducing the value of the SGA_TARGET parameter takes away memory from both autotuned and manually sized components.
C) It can be increased up to the value of the SGA_MAX_SIZE parameter.
D) Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

3. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

A) The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
B) The database operation temporarily halts till the member becomes available.
C) Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D) The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E) The database instance aborts.

4. The HR user creates a view with this command:
SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp;
Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?

A) HR can grant the privilege to JIM but without GRANT OPTION.
B) HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
C) SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D) HR can grant the privilege to JIM because HR is the owner of the view.

5. Which two operations can be flashed back using the Flashback technology? (Choose two.)

A) ALTER TABLE SALES_REP DROP PARTITION P1;
B) DROP TABLESPACE USERS;
C) DROP USER SMITH;
D) DROP TABLE EMPLOYEES;
E) ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

Solutions: