Oracle9i Database Fundamentals Set 5

While starting up the database on a Monday morning, you get the following error after the database is mounted:
ORA-01157: cannot identify/lock data file 9-see DBWR trace file ORA-01110: data file 9:'/u01/oracle/app/
oradata/orcl/users01.dbf' While investigating, you realize that a backup of the data file (users01.dbf) exists.
Which data dictionary view would you use to locate the archived redo log files that are required for recovery?

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING
parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by
'safe literals only'?

Which is a restriction on a list partitioned table?

Which of the following commands must be issued to remove a stored script from the recovery catalog?

You are using Recovery Manager (RMAN) to back up your database at regular intervals. You are using
recovery catalog to maintain the RMAN repository. On a Monday, while trying to back up a data file you realize
that the recovery catalog database is down and you decide to back up the data file by using an operating
system command.
On Tuesday, after the recovery catalog database is functional you execute the following command to register
the previous day's backup in the RMAN repository: