Hi Mercy,
It would of great help if you could send some dumps for SQL/PLSQL exam.My email id is [email protected]
lucky133
Printable View
Hi Mercy,
It would of great help if you could send some dumps for SQL/PLSQL exam.My email id is [email protected]
lucky133
Congratutions
please send me a copy pls. and tnx for sharing your success .
[email protected]
here's by recent oracle8i test results:
1)PL/SQL =44/57
2)Architecture =51/64
3)Network Admin =44/59
4)BackupRecovery =50/60
5)PerformanceTune =47/57
...wonder how does the rest fair??
junior
Hi
I dont have all papers , get it from [email protected]
he has some updated papers or purchase cheetsheets.
checkout examcram or ILT + STS for success
some backup and recovery questions
Question:
You received an insufficient privileges error message while trying to add data to another user's
table. Which type of failure has occurred?
Answer:
(C) statement
Question:
Your control file was not mirrored and it is now lost because of a media failure. Which command
will you use to recover the database?
Answer:
(A) BACKUP CONTROLFILE
Question:
You are preparing for a traditional TSPITR to replace invalid data inserted into a table when a
constraint on that table was inadvertently disabled. You have all other datafiles and you have
backed up the required control file. What must you do before you begin?
Answer:
(B) check for adequate memory and disk space
Question:
During the recovery of a user's schema that you are unfamiliar with, you import the tables in
alphabetical order. Which problem might you encounter?
Answer:
(D) A foreign key table is imported prior to its corresponding primary key table causing rows
that reference the primary key to be rejected.
Question:
The database is hanging and the current online redo log is damaged. As the DBA, you have
identified which group is current and cleared the unarchived logfile group. What is recommended
that you do next?
Answer:
(A) Perform a whole backup with the database closed.
Question:
You lost a datafile due to disk failure. You are restoring the datafile to a new location
because the disk is corrupted. After using the SWITCH command to modify the control file,
what is the next step?
Answer:
(D) Apply archives, incrementals, cumulative, and redo logs with the RECOVER command.
Question:
Which statement concerning the recovery of a NOARCHIVELOG mode database from a closed database backup is true?
Answer:
(C) Manual entry of lost transactions may be needed after recovery.
Question:
Which statement concerning a database running in ARCHIVELOG mode is true?
Answer:
(B) The database can be restored to a specific SCN or point-in-time.
Question:
Which two data dictionary views can be accessed during an opened database backup for backup
status information? (Choose two.)
Answer:
(A) V$BACKUP
(F) V$DATAFILE_HEADER
Question:
You plan to use LogMiner to reverse invalid changes made to a table by a particular user.
After modifying the init.ora file to indicate where the new dictionary file will reside, you
use the BUILD procedure to generate the file. Which procedure will you use to identify log
files to be analyzed?
Answer:
(A) ADD_LOGFILE
Question:
Which statement concerning an incomplete recovery using RMAN is true?
Answer:
(A) All datafiles must be restored.
Question:
You are using the CATALOG command to add information to a recovery catalog. Which two event's information are you recording? (Choose two.)
Answer:
(A) datafiles that were copied without using RMAN
(D) a tablespace backup that occurred before RMAN was installed
Question:
You issued this command:
RECOVER AUTOMATIC DATABASE
In which situation is this command used?
Answer:
(A) a closed database recovery
Question:
Which two statements concerning the alert.log file are true? (Choose two.)
Answer:
(A) It contains system error information.
(B) It contains recovery operations information.
Question:
Your database is running in ARCHIVELOG mode. It has suffered a media failure resulting in a
number of damaged files. As the DBA, which recovery option is available to you that would
impose the least impact on users?
Answer:
(C) an online restoration of the damaged files
Question:
You have a standby database that is kept in close synchronization with your primary database.
How are the databases' kept in synchronization efficiently?
Answer:
(D) The primary database's archive logs are applied to the standby database by placing the
database in managed recovery mode.
Question:
Place the steps required to multiplex a control file in the proper order.
Step 1 -> Shut down the database
Step 2 -> Copy existing control file to a different device
Step 3 -> Add all control file names to init.ora using the CONTROL_FILES parameter
Step 4 -> Start the database
Question:
You are temporarily using your standby database as a reporting database. Because you are only
allowing users to query information for their reports from this database, you opened the
database in ______ mode.
Answer:
read only
read-only
Question:
Examine these recovery catalog details:
username: RCATMAN
password: RCATMAN
connect string: RCVCAT
Which command will connect to this recovery catalog?
Answer:
(C) $ rman rcvcat rcatman/rcatman@RCVCAT
rman> connect target
Question:
Before executing a backup script, you need to copy a file using operating system commands.
You are logged in to Recovery Manager. Which command should you use to execute the copy command from the Recovery Manager prompt?
Answer:
(A) run
Question:
At approximately 7:00am today, the DEPARTMENT table was accidentally dropped. The database structure has not changed since last Friday and you decide to perform an incomplete database recovery through 6:45am today. Using Recovery Manager, which RUN command clause will perform this recovery?
Answer:
(C) SET UNTIL TIME = '1998-06-08:06:45:00'
Question:
You shut down the database to place the database in archivelog mode. In which state should you restart the database to alter the archive mode?
Answer:
(B) MOUNT
Question:
You removed the archived log file named arch_232.rdo located in the '/disk2/archive' directory
using an operating system utility. You are using a recovery catalog. Which Recovery Manager
command should you issue to inform the recovery catalog to no longer reference this file?
Answer:
(D) CHANGE ARCHIVELOG '/disk2/archive/arch_232.rdo' UNCATALOG;
Question:
Due to the size of your database, you are concerned with the amount of time that must be
allocated for backups. You decide to use Recovery Manager to expedite your backups for which
reason?
Answer:
(B) The use of incremental backups is available.
Question:
Saturday is the start of your weekly backup strategy and a level 0 backup is performed.
For subsequent daily backups throughout the week, you only want to back up those blocks that
have changed since the previous day's backup. Which RUN command will you use?
Answer:
(D) rman> run { allocate channel c1 type disk
format = '/disk1/backup/tue_%s_%p.bck';
backup incremental level = 1 (database); }
Question:
Using the Export/Import utility as your backup and recovery strategy, you must now recover a
table that was accidentally dropped. This table is very large and has several indexes on it.
Which Import clause could you use to help speed up this process by preventing the index
structures from being imported?
Answer:
(B) INDEXES = NO
Question:
You create a new database in NOARCHIVELOG mode. What is an implication of running a database that is not archiving log files?
Answer:
(A) You cannot perform online backups.
Question:
You set a number of tablespaces in backup mode by issuing the ALTER TABLESPACE command. You want to verify that all the files you are about to backup are indeed in "begin backup" mode. Which data dictionary view can you query to verify this information?
Answer:
(A) V$BACKUP
Question:
Recovering a database in ARCHIVELOG mode requires access to all archived log files created since the last backup. If a recovery operation required archived log files with sequence number 122 through 134 and sequence number 125 is missing, what would be the result?
Answer:
(B) The database would only be recovered through archive log file sequence number 124 in this
operation.
Question:
Datafiles for the STAT_DATA tablespace are lost due to media failure and the disk is
Unrecoverable. The database is in NOARCHIVELOG mode. After restoring the backups to a
Different locations, which action must you take before updating the control file to specify this
New location?
Answer:
(B) Mount the database.
Question:
Examine this redo log file configuration:
Member Disk
Group 1: log1a.rdo u02
log1b.rdo u02
Group 2: log2a.rdo u04
log2b.rdo u04
Group 3: log3a.rdo u04
log3b.rdo u04
Which change should you make to this configuration to minimize single-point-of-failure in
case of media corruption?
Answer:
(C) Place each member of a particular group on a separate disk.
Question:
The SALES_STAT table was dropped two days ago. You decide to perform tablespace point-in-time recovery without Recovery Manager. This option includes which task(s)?
Answer:
(B) Create, recover, and export the table from the clone database and import into the primary
database.
Question:
You are considering physical image copies as a backup solution. Which factor is likely to have
a high impact on your strategy?
Answer:
(D) Available storage space required for physical image copies must be sufficient.
Question:
The Production database experiences a media failure. The lost disk contains the datafile for
The USER01 tablespace, but not the Datafiles for the system or rollback segment tablespaces.
To perform a complete recovery, you mount the database, take the datafile offline, and open the
Database. What should you do next?
Answer:
(B) Restore the Datafiles to a new location.
Question:
An electrical storm shut down the database abnormally. Instance recovery will begin the next
Time the database is started. Which server process writes both committed and uncommitted data to the Datafiles during instance recovery?
Answer:
(C) DBWR
Question:
The SYNC_MASTER table will be loaded each day with statistics generated during that day
using SQL* Loader. You set the table in NOLOGGING mode to speed the loading of data.
Why is it advisable to take a backup of the table after this data load?
Answer:
(D) Changes resulting from the direct insert operation are not recorded in the redo log files.
Question:
Your database is in NOARCHIVELOG mode and a datafile has just been lost due to a power outage that corrupted a disk. Which steps must you perform to recover this database?
Answer:
(A) Restore the last full offline backup of the entire database.
Question:
Block corruption of a specified file has just been indicated by the error message ORA-1578.
If an index is available on the table in which the corrupted block resides, how can the
uncorrupted data be retrieved?
Answer:
(A) index scan
After an instance crash, when are the uncommitted transactions rolled back?
1) During the startup open.
2) Data is never rolled back since rollback segments are lost.
3) After the database is opened.
4) When the DBA issues a Global Rollback.
5) During the startup mount.
Due to a prolonged power failure, your database server goes down overnight. You are running the database in ARCHIVELOG mode.
Referring to the above, when the power to the database server is restored, what type of recovery must you perform in order to start the database?
1) Time-based Recovery
2) Cancel-based Recovery
3) Restore the last cold backup and perform a full database recovery.
4) You only need to recover data files with active transactions.
5) No manual recovery is required.
A disk crashes in your database. You have backups, but cannot restore all of the files to there original location. What command must you issue to inform Oracle of the new file locations prior to opening/recovering the database?
1) No command is necessary. Oracle will find the file.
2) alter database rename file
3) alter database backup controlfile to trace
4) startup nomount
5) create control file
alter database backup controlfile to trace;
When the above command is executed, where will the trace file be written?
1) The user's current directory.
2) BACKGROUND_DUMP_DEST
3) USER_DUMP_DEST
4) The user's HOME directory.
5) ARCHIVE_LOG_DEST
Which of the following is a characteristic of a cancel-based recovery?
1) Automatic application of Oracle's archive redo suggestions
2) Tablespace recovery with on-line backups
3) Use of the alter database recover database until cancel statement
4) Availability of the database during the recovery process
5) Use of the alter system recover database until cancel statement
Which tablespace cannot be recovered with the database open?
1) SYSTEM
2) USERS
3) DATA
4) TEMP
5) TOOLS
In the event that a data recovery is necessary, what must occur?
A: restoration of the data file from the backup
B: drop the corresponding tables related to the bad data file
C: application of all archive log files and the redo log files
D: a and c above
E: all of the above
Oracle jobs can be scheduled through the Enterprise Manager only.
A: true
B: false
A replicated system requires
A: a master site
B: a snapshot site
C: a replication server
D: a and b above
E: none of the above
When this Oracle object is lost, the database is nearly impossible to recover the database and should be protected by some type of data mirroring.
A: redo log
B: control file
C: rollback segment
D: all of the above
E: none of the above
If ARCHIVELOG mode is turned on, a redo log group must be archived before it is used.
A: true
B: false
Under what condition will a point-in-time recovery be necessary?
A: power loss
B: user error
C: hardware failure
D: disk drive failure
A log file is just like any other data file and may be recovered.
A: true
B: false
In order for a transaction to be eligible for recovery,
A: a checkpoint must occur
B: the data must be backed up
C: the data must be written to the archive log
D: the redo log entry must be written out to disk
The Oracle Export/Import Utilities can be used for the following functions.
A: backing up the database
B: rebuilding the database
C: reorganizing the database
D: a and b above
E: all of the above
If no hardware or operating system mirroring is available and recoverability is required, the redo log files within the same redo log file group
A: must be stored on the same disk
B: must be stored on separate disks
C: must be stored on a separate disk from the rollback segments
D: can be stored anywhere, because the redo logs are not needed for recoverability
When recovering from a lost datafile, it is only necessary to recover
A: the instance
B: the entire database
C: the datafile that was lost
D: the tablespace that was lost
Instance recovery is automatic.
A: true
B: false
What Oracle objects are used for recovery operations?
A: redo log files, query
B: rollback segments, query
C: redo log files, rollback segments
D: all of the above
E: none of the above
In the event of a power loss, what recovery method is required?
A: media recovery
B: instance recovery
C: database recovery
D: point in time recovery
When recovering from a lost datafile, it is only necessary to recover
A: the instance
B: the entire database
C: the datafile that was lost
D: the tablespace that was lost
The Oracle Export utility stores Oracle data and table definitions externally in an Oracle-specific log file.
A: true
B: false
Question:
You issue these commands:
$rman target system/manager@prod8db \
> rcvcat system/manager@prod8rcat
rman> report need backup days 5 database;
Which type of list is generated by the second command?
Answer:
(D) all the datafiles that have not been backed up in the last 5 days
Question:
Which statement about RMAN is true?
Answer:
(D) Recovery Manager allows backups of changed blocks, but does not support point-in-time
recovery of the SYSTEM tablespace.
if anybody has 8ibackup and recovery papers, please publish it....
All the best
Bye
mercy
Hello Mercy
Thanks for your question. can you send me one copy of all
question to my email-id [email protected]
Rakesh Sanghvi
dang!
anyone notice that there are a good number of questions with innacurate or wrong answers/questions?
example:
one questions/answer stated you cannot delete/remove table data when using SQL*Loader. That is not correct.
- Magnus
Hi
passed Sqlplus
Thanks to dbasupport.com and other friends
check oracle documentation for sucess.
Byw
For clarification when you say "oracle documentation" you mean the topics listed by Oracle as being on the test correct?
Thanks
L-Carvone
Hi
oracle documentation is good.
download candidate guide
from education.oracle.com and check out
all chapters and prepare for the exams.
Bye
Hello Nikky,
I am also studying for my OCP-DBA-(for Oracle8i) here in Australia.
I haven't done any exams yet and have little computer experience. I am therefore looking for any help that I can get!!
If you or anyone else out there do have any Oracle Dumps or anything that can help me pass then please forward them to my email address which is:-
[email protected]
Cheers and thanks heaps in advance!
Tom.