Oracle9i Database Fundamentals Set 2

You want to perform in incomplete recovery of your database. You plan to use these commands to recover your
database: How should the commands be executed?

A client/server application has been configured to use local naming. The client and server run on separate
machines. When the client tries to connect, it receives a TNS error. By carefully examining the environment, a
tnsnames.ora is found only on the Oracle server machine, among other things. After copying this tnsnames.ora
onto the client machine, the client is able to connect to the server.
Which statement is true?

You configured automatic archive logging for the database. On the next startup the database runs for a while,
but then hangs. After checking the alert log, you determine that all the online redo logs need archiving.
Which step was skipped when you set up automatic archive log?

The client connected to the database turns off his or her machine without exiting from a connection to the
database. Which type of failure is this?

Your company decided to start using RMAN in its backup strategy. Previously your company used operating
system file copies. Which command is used to make RMAN aware of existing backups made by copying files at
the operating system?

Two data files have been deleted at the operating system level by accident. Your database is running in
ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs
to the USERS tablespace on the other belongs to the SYSTEM tablespace.
How can you recover from this situation?

The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN
block or at the RMAN prompt, overrides the configured autobackup in the session only. What is the order of
precedence?
1. SET within RUN
2. SET at RMAN prompt
3. CONFIGURE

You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of
the data files and the control files taken when the current log sequence number was 45. You experience disk
failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure, the
current log sequence number is 98.
Which files should you restore to recover from the loss of the SYSTEM tablespace data files?

Which are required initialization parameters in an Oracle Shared Server environment?

You want to create a copy of the DEPARTMENTS table. When that is complete, you want to truncate the new
DEPARTMENTS table, then restore the data with a directload insert from the old DEPARTMENTS table.
Which CREATE statement should you use?