Oracle database 10g:Administration I Sample Questions:

1. Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
Table dropped.
What happens in this scenario?

A) The table is renamed and remains in the TBSFD tablespace.
B) The table is moved to the SYSAUX tablespace.
C) The table is moved to the SYSTEM tablespace.
D) The table is removed from the database permanently.

2. Your database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)

A) The backups need not be restored during recovery in case of a media failure.
B) The backups would be possible only if the database is running in NOARCHIVELOG mode.
C) The backups would be consistent.
D) The backups would be inconsistent.
E) The backups would be possible only if the database is running in ARCHIVELOG mode.
F) The backups need to be restored and database has to be recovered in case of a media failure.

3. Your database is started with SPFILE. You want the database instance to be dynamically registered with a listener L2 with the following details:
Protocol: TCP Host: indl151e Port: 1525
Which is the correct order of the steps that you would follow to achieve this?
1.Set the LOCAL_LISTENER parameter to L2 dynamically.
2.Make an entry for L2 in tnsnames.ora on the database server.
3.Restart L2.
4.Modify the listener.ora file to add the instance name in SID_LIST of L2.

A) 2, 1; 3 and 4 are not required.
B) 1, 2, 3; 4 is not required.
C) 1, 2; 3 and 4 are not required.
D) 1, 2, 4, 3

4. You plan to use static database registration for a new listener when you create it. What could be the two reasons for this? (Choose two.)

A) The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
B) The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
C) The database that is to be registered with the listener is configured in shared server mode.
D) More than one database is to be registered with the listener.
E) The users will connect the database by using the host naming method.

5. User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:
SQL> SELECT job FROM emp
2 WHERE job='CLERK' FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT's second session? (Choose three.)

A) LOCK TABLE emp IN EXCLUSIVE MODE;
B) DELETE FROM emp WHERE job='MANAGER';
C) SELECT job FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
D) INSERT INTO emp(empno,ename) VALUES (1289,'Dick');
E) LOCK TABLE emp IN SHARE MODE;

Solutions: