1Z0-025 经典考试回忆
添加时间: 2008-4-21 21:10:37 作者: Oracle指导 阅读次数:12 来源: http://www.d9soft.com
覆盖率可以，不过答案不是很准确。
1. What are two benefits of making recovery operations parallel? (Choose two)
Answer: Recovering more than one data file.
2. With the instance down, how would you recover a lost control file?
Answer: Use the CREATE CONTROLFILE command.
3. You are restoring a backup data file to a different location. To recover
successfully, what must you do?
Answer: Use the ALTER DATABASE command to rename the data file.
4. Which two benefits does the command ALTER DATABASE MOUNT
CLOSE DATABASE offer for the tablespace point-in-time recovery?
(Choose two)
Answer: It prevents accidental corruption of the primary database.
It allows you to remove a data file that has been added to the wrong tablespace.
5. Which statement about ‘cancel-based recovery’ is true?
Answer: Recovery is stopped by entering CANCEL at the recovery prompt.
6. A media management layer is always used when Recovery Manager
________.
Answer: Performs media recovery.
7. Why would you set a data file offline when the database is in MOUNT state?
Answer: To allow for automatic data file recovery.
8. When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which three options can be used to do this? (Choose Three)
Answer: SHUTDOWN NORMAL AND STARTUP MOUNT
SHUTDOWN IMMEDIATE AND STARTUP MOUNT
SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT
9. When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which two options should not be used to do this? (Choose two)
Answer: STARTUP FORCE MOUNT
SHUTDOWN ABORT and STARTUP MOUNT
10. What is the correct procedure for multiplexing existing online redo logs?
Answer: Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.
11. In the view V$DATAFILE_HEADER, what does value ‘YES’ in the ‘FUZZY’ column as specified?
Answer: The data file is in backup mode.
12. During an opened database backup, a power failure occurs. Which SQL statement do you issue to resolve this situation after mounting the database?
Answer: ALTER DATABASE DATAFILE n END BACKUP
13. You perform an incomplete recovery using RMAN. You write the following
script:
RUN{
SET UNTIL TIME = ‘yyyy-nm-dd:hh:mi:ss’;
RESTORE DATABASE;
RECOVER DATABASE;
SQL “alter database open resetlogs”;}
Which command is missing?
Answer: RELEASE CHANNEL.
14. Which statement regarding Recovery Manager with a database operating in
NOARCHIVELOG mode is true?
Answer: Recovery Manager supports multi-level incremental backups.
15. After rebuilding the recovery catalog by resynchronizing it with a copy of the backup control file, you notice references to files that no longer exist. Which CRETAE command clause should you use to remove these references?
Answer: UNCATALOG.
16. When configuring a database for ARCHIVELOG mode, you use initialization parameter to specify which two actions? (Choose two)
Answer: Where log files will be archived. The names that will be given to archived log files.
17. A tablespace becomes unavailable because of a failure. The database is
running in NOARCIVELOG mode? What should the DBA do to make the database available?
Answer: Restore the data files, redo log files, and control files from an earlier copy of a full database backup.
18. In which situation would you need to create a new control file for an existing
database?
Answer: When MAXLOGMEMBERS needs to be changed.
19. Why would a DBA load a table using the NOLOGGING options?
Answer: To reduce redo during a direct loaded operation.
20. Which technique does Oracle use to perform full backups of data files?
Answer: The server process reads the entire file and skips blocks that have never
been used.
21. Which statement regarding the allocation of processes to Recovery Manager is true?
Answer: Setting BACKUP_TAPE_IO_SLAVES=TRUE will enable a dedicated
slave to write to a tape device.
22. What is the effect of issuing an ALTER DATABASE OPEN RESETLOGS command on the primary database?
Answer: It invalidates the standby database.
23. In order to keep a standby database up-to-date, archived redo-log files need
to be transferred from the primary to the standby server. What are two ways
to do this? (Choose two)
Answer: Specify LOG_SARCHIVE_DEST_n on the standby database.
24. When configuring a database for ARCHIVELOPG mode, you use an initialisation parameter to specify which action?
Answer: That the database is in ARCHIVELOG mode.
25. You have just created a script in Recovery Manager. After noticing an error
in the script, you decide to recreate it. Which command replaces the stored script in the recovery catalog?
Answer: REPLACE_SCRIPT
26. When two or more databases are backed up using RMAN, is it appropriate
to use each database as the other’s recovery catalog? Why?
Answer: No. A database that contains a catalog cannot be target database.
27. What is the advantage of managed recovery mode?
Answer: The standby database automatically applies the archived redo log when the
files become available.
28. Which import option do you use to create tables without data?
Answer: ROWS.
29. Which statement is true when using the LogMiner utility?
Answer: The dictionary file is created in a directory as defined as defined by
UTL_FILE_DIR.
30. The developers have implemented parallel DML operations. How can a DBA
make sure that the archiving process is able to keep up with archiving the redo-log files?
Answer: Spawn multiple database writers.
31. Which action does Oracle recommend after a DBA recovers from the loss of
the current online redo-log?
Answer: Back up the instance.
Back up the control file.
32. What is the last step when setting up a recovery catalog?
Answer: Run the REGISTER DATABASE command.
33. What is the difference between using NOLOGGING operations in a single
database environment and a standby database environment?
Answer: NOLOGGING operations can be used on the standby database, but not on the primary database.
34. What is the function of SMON in instance recovery?
Answer: It roles forward by applying changes in the redo log.
35. What are two causes of user errors? (Choose two)
Answer: Incorrect data is committed.
A table is accidentally truncated.
36. Which statement is true when using the DELIVERY utility to detect corruptions in an Oracle data block?
Answer: The utility can be used to verify the data files of a backup database.
37. The alert log can contain specific information about which database backup activity?
Answer: Placing tablespace in begin and end backup mode.
38. In which two situations would you have to apply redo information to a read-only
tablespace? (Choose two)
Answer: When the tablespace being recovered is writeable, but was read-only when the last backup occurred.
When the tablespace being recovered is read-only, but was writeable when the last backup occurred.
39. Your database is configured in ARCHIVELOG mode. Which three types of
backups can be performed? (Choose three)
Answer: Open database backups.
Operating system backups when the database is closed.
Online control file backups using the ALTER DATABASE BACKUP
CONTROLFILE command.
40. Which two actions must you take to stop automatic archiving of redo-log
files? (Choose two)
Answer: Issue the ALTER SYSTEM ARCHIVE LOGSTOP; command.
Set LOG_ARCHIVE_STOP=TRUE parameter file and restart the database.
41. When using Recovery Manager without a catalog, the connection to the
target database ______?
Answer: Can be a local or a remote connection.
42. Work is done by Recovery Manager through ____?
Answer: Operating system commands.
43. Click on the task button.
The steps required to recover a tablespace with Recovery Manager are listed below. Place them in correct order.
TASK Drag And Drop Steps to recover a tablespace Proper order Run RAMN to restore/recover Step 1
Check on recovery completion Step 2
Check status of the database Step 3
Take a backup Step 4
List data files that need to be restored Step 5
Answer: 3, 4, 1, 5, 2
44. Before you can restore data files to a new location using RMAN, what should
you do?
Answer: Copy the data files to the new location using an operating system tool.
45. When starting up the database finds that an inactive, unachieved redo-log
group is corrupted?
Answer: ALTER DATABASE CLEAR UNARCGHIVED LOGFILE GROUP 1.
46. Which RECOVER command is appropriate when, while recovering a lost data file, a DBA discovers that a required, archived redo-log is corrupted?
Answer: RECOVER DATABASE UNTIL CANCEL.
47. Given the RMAN script:
run(
allocation channel t2 type ‘SET_TAPE’
backup filesperset 3
format ‘/disk1/backup/ar_%t_%s_%p’
(Archivelog from logseq*1056 until logseq*1056
thread*1 delete input):
)
What does this script do?
Answer: Backup three archived logs into one backup set.
48. The RAMN script is run every Sunday:
Run (
Allocate channel c1 type disk
Format= ‘/home/disk1/user4/BACKUP/run_is_ip.bus’;
Backup incremental level= 0 (database);
)
This RMAN script is run everyday of the week, except Sunday
Run (
Allocate channel c1 type disk
Format+ ‘/home/disk1/user4/BACKUP/inc_is_ip.bus’
Backup incremental level= 1 emulative (database);
) What do these scripts do?
Answer: On Sunday, they backup the entire database. On other days of the week,
they backup all blocks changed since the previous backup.
49. Which statement about an open database backup is NOT true?
Answer: All the database files copied are consistent to a point-in-time.
50. Which activity would not cause an additional generation of redo?
Answer: Closed database backup.
51. Which type of tablespace point-in time recovery method needs to be performed if the recreated database is on a separate machine?
Answer: Use of transportable tablespaces.
52. Which two tasks can a DBA perform using the export/import facility?
(Choose two)
Answer: Archive historical data. Transport tablespaces between databases.
53. Which statement about ‘time-based recovery’ is true?
Answer: Recovery is stopped after the database has committed all changes up to the specified point of time.
54. To successfully recover when restoring a backup control file to a differential
location what must you do?
Answer: Use the ALTER DATABASE command to rename the control file.
55. While performing a database recovery, you want the redo-log files to be
applied automatically. What are three ways to do that? (Choose three)
Answer: Enter the word AUTO when prompted for a log.
Use the AUTOMATIC clauses of the RECOVER command.
Within SQL*Plus, issue SET AUTORECOVERY ON command.
56. In which situation would you need to create a new control file for an existing
database?
Answer: When MAXLOGMEMBERS needs to be changed.
57. When would a DBA need to perform a media recovery?
Answer: When a data file is not synchronized with the other data files, redo logs,
and control files.
58. What is the correct procedure for multiplexing control files?
Answer: Shut down the database, rename the control file, edit the
CONTROL_FILES parameter, and start up the database.
59. Your database is configured in ARCHIVELOG mode. Which three types of
backups can be performed? (Choose Three)
Answer: Opened database backups.
Operating system backups when the database is closed.
Online control file backups the ALTER DATABASE BACKUP
CONTROLFILE command.
60. What are two ways to transfer archived redo-log files from the primary to
the standby server? (Choose two)
Answer: The primary database can be set up in a way that it automatically copies
archived redo-log files to the standby site.
The standby database automatically copies archived redo-log files from
the primary server when it is in a managed recovery mode.
61. When creating a standby database, which files must be transferred to the standby server?
Answer: The standby control file, the database backup, and the archived redo-log files.
62. Which process controls the RMAN channel?
Answer: A server process.
63. Which two statements about the LogMiner utility are true? (Choose two)
Answer: The results of the LogMiner analysis are stored in a dynamic view that can
be queries.
It translates the contents of the redo-log files into SQL statements representing the original operations.
64. The alert log will never contain specific information about which database backup activity?
Answer: Performing an operating system backup of the database files.
65. Which statement is true when using the DELIVERY utility to detect corruptions in an Oracle data block?
Answer: The utility can be used to verify the redo-log files for corruption.
66. Before executing a script, you decide to switch the current log file. You are
already logged in to Recovery Manager and want to execute this command from the Recovery Manager prompt? Which command should you use?
Answer: rman> run (sql ‘alter system switch logfile’.)
67. You need to create a recovery catalog. Before you issue the CREATE CATALOG command, what do you need to do first?
Answer: Create a tablespace for the catalog and a Recovery Manager user.
68. A backup file named user01_2.dbf in the ‘/disk3/backup’ directory is no longer needed and must be deleted. You are using the recovery catalog.
Which set of command must you issue to delete this entry from the recovery catalog?
Answer: rman> allocate channel for delete type * disk
rman> change datafilecopy ‘/disk3/backup/user01_2.dbf’ delete
rman> release channel;
69. When setting up a recovery catalog, what are two storage considerations to
remember? (Choose two)
Answer: Include the recovery catalog in your backup strategy.
Do not create the recovery catalog in the target database.
70. You have determined that one of the data files belonging to the SYSTEM
tablespace is corrupt. Which complete media recovery scenario do you choose?
Answer: Complete recovery – mounted database.
71. Why does this command cause an error?
Exp system/manager inctype=full file=expdat.dnp
Answer: The full=y parameter needs to be specified.
72. When using Recovery Manager without a catalog, the connection to the
target database should be made as _____.
Answer: A user with SYSDBA privilege.
73. Where should a recovery catalog be created?
Answer: In the target database.
74. Which two statements regarding the use of Recovery Manager with a
database in NOARCHIVELOG mode are true? (Choose two)
Answer: The target database must be in MOUNT mode for restriction of data files.
A DBA can only restore using RMAN if the backups were taken or
registered with Recovery Manager.
75. The alert log will never contain information about which database activity?
Answer: Altering the database to take a data file offline.
76. Which two statements about the LogMiner utility are true? (Choose two)
Answer: The results of the LogMiner analysis are stored in a operating system text
file.
It translates the contents of the redo-log files into SQL undo commands to roll back the original operations.
77. When using the DBVERIFY tool to detect corruption in an Oracle data block, which statement is true?
Answer: The utility cannot verify data files for a database with any
DB_BLOCK_SIZE greater than 2K bytes
78. What are benefits of putting the database in ARCHIVELOG mode? (Choose
two)
Answer: It guarantees recovery to the time of failure The database can be backed up while online
78. What are benefits of putting the database in ARCHIVELOG mode? (Choose
two)
Answer: It guarantees recovery to the time of failure The database can be backed up while online
79. The Export utility must be used to transfer certain object to another database. You have determined that these objects include all table triggers, snapshots, tables, and views for a particular user. Which Export mode should you use to export these objects?
Answer: Table.
80. Your daily report indicating which data files need to be backed up has been
misplaced. Which Recovery Manager command returns a report containing
the files in the USER_DATA tablespace that have not been backed up within the last three days?
Answer: rman> report need backup days 3 tablespace user_data
81. Which statement concerning archiving is true?
Answer: Archive logs can be written to multiple destinations.
82. What are two purposes for using the Recovery Manager command
CATALOG? (Choose two)
Answer: Updating recovery catalog about operating systems backup.
Updating recovery catalog about files created before Oracle 8.
83. Which command creates a text backup of the control file?
Answer: ALTER DATABASE BACKUP CONTROLFILE TO TRACE
84. Which option is used in the parameter file to detect corruptions in an Oracle
data block?
Answer: DB_BLOCK_CHECKING
85. What are two causes of media failures? (Choose Two)
Answer: A database file is accidentally deleted.
There is a head crash on the disk containing a database file.
86. Which command is used to allow RMAN to store a group of commands in the
recovery catalog?
Answer: CREATE SCRIPT
87. When performing an open database backup, which statement is NOT true?
Answer: The database can be open but only in READ ONLY mode.
88. You perform an incomplete database recovery using RMAN. Which state of
target database is needed?
Answer: Mount.
89. Why is manual archiving not recommended?
Answer: A DBA must issue at SQL command to archive the online redo-log files.
90. How can a DBA disable one of the current archive destructions?
Answer: Issue the command ALTER SESSION SET LOG_ARCHIVE_DEST+DEFER.
91. In which mode is ‘Closed database backups’ the only backup option available?
Answer: NOARCHIVELOG mode.
92. The command ALTER DATABASE CREATE STANDBY CONTROLFILE
AS standby.ct creates a standby control file. What needs to be done next to
create a standby database?
Answer: The standby control file needs to be copied to the standby server.
93. Your database is in ARCHIVELOG mode, and you want to recover from a
media failure taken up to the time of failure. Which files do you need to restore?
Answer: The damaged files form a backup taken after the database was set in
ARCHIVELOG mode.
94. Before performing a closed database backup, which three commands can be used to shut down the database? (Choose three)
Answer: SHUTDOWN NORMAL.
SHUTDOWN IMMEDIATE.
SHUTDOWN TRANSACTIONAL.
95. Why can you not apply archive logs to not forward after an import?
Answer: Because no synchronizing information is stored in the archived logs or export file.
96. What is the difference between using NOLOGGING operations in a single
database environment and a standby database environment?
Answer: NOLOGGING operations can be used on the standby database, but not on the primary database.
97. Which action does a DBA take when using a backup control file?
Answer: Includes UNTIL BACKUP CONTROLFILE in the RECOVER command.
98. Which three files should be backed up for a closed database backup? (Choose two)
Answer: Data. Control.
99. The instance crashed after the current online redo-log becomes corrupt.
Which action can the DBA take to open the database?
Answer: Skip recovery and open the database with the RESETLOGS option.
100. You have been informed that he ORDER table was dropped two days ago. It
is unwise to perform an incomplete recovery of this database; therefore, your
only option is to perform tablespace point-in-time recovery. What are two
ways this can be done in Oracle8i? (Choose two)
Answer: Create and recover the database on another machine and use the transportable tablespace option Create and recover a clone database, export the table from the clone database, then import it into the primary database
101. Which two records does the Recovery Manager RESYC CATALOG
command update? (Choose two)
Answer: Log switch records.
102. When the status of the tablespace moves form read-only to read write, which
two events occur? (Choose two)
Answer: Redo-log switch must take place.
Normal checkpoints on the file now occur.
103. What are two causes of a user process failure?(Choose two)
Answer: The user issues an abnormal interrupt.
104. Which two types of data files do not require synchronization during media
recovery? (Choose two)
Answer: Offline data files.
Data files in read-only tablespace.
105. Which three statements about Recovery Manager backups are true? (Choose
Three)
Answer: Incremental backups are noncumulative by default.
Each file in a backup set must have the same block size. With multilevel incremental backups, you can have no more than three levels.
106. When copying the init.ora file from the primary database server to the standby database server, which two parameters do you need to change?
(Choose two)
Answer: DB_NAMECONTROL_FILES
DB_FILE_NAME_CONVERT
107. If a DBA restores a read-only tablespace from a backup taken before the tablespace was made read-only, what must the DBA do next?
Answer: Complete media recovery.
108. Which two items can be assigned an RMAN tag? (Choose two)
Answer: A backup set. An image copy.
109. What kind of destination can DBA choose when specifying the
LOG_ARCHIVE_DEST_n parameter?
Answer: A local dictionary or Net8 atlas for a remote database.
110. What two actions occur during a checkpoint? (Choose Two)
Answer: Oracle performs a log switch.
Oracle flushes the dirty blocks in the database buffer cache to disk.
111. Your recovery catalog user account is RECMAN with a password of RECMAN. Which command will connect to Recovery Manager through the
user SMITH with a password of DNAGER if the database containing the recovery catalog is identified by the TNS ailas.RCVCAT?
Answer: $ target smith/danger rcvcat recman/recman@RCVCAT
112. What is the effect of activating a standby database?
Answer: The standby database becomes the primary database.
113. What is recommended initial size for a tablespace containing an RMAN
recovery catalog?
Answer: 20M
114. Which three types of files does RMAN include in its backups? (Choose Three)
Answer: Data files.
Control files.
Archived redo-logs.
115. What must a DBA do after using NOLOGGING operations on a primary database?
Answer: Copy all affected data files to the standby server.
116. What are two benefits of using RMAN with a catalog? (Choose two)
Answer: You can store scripts for backup and recovery operations.
You can maintain records of backup and recovery operations.
117. Which command should you use to issue to find all backup sets containing
the data file query1.dbt?
Answer: rman> list backupset of datafile ‘query1.dbt’
118. What is the function of ARCn in instance recovery?
Answer: The archive process does not take part in instance recovery.
119. Which two types of data files can be considered non-essential? (Choose two)
Answer: Data files belonging to an index tablespace.
Data files belonging to a temporary tablespace.
120. Consider the following scenario using incremental backups. A level 1 backup
is taken on the first of the month. A level 2 backup is taken in every Sunday,
and a level 3 backup is taken daily. If the database gets corrupted on the second Wednesday of the month and is lost, which scenario would restore the database completely?
Answer: A base level backup (level 0) is missing and nothing can be recovered.
121. Your database is in NOARCHIVELOG mode, and a media failure occurs.
Which files do you need to restore to minimize data log?
Answer: The damaged files only if no log switch has occurred once the last backup.
122. Your archive logs are not restored to the ARCHIVE_LOG_DEST directory.
What are three ways to notify Oracle server of their location? (Choose three)
Answer: Specify the location and name when prompted for a log.
Use the RECOVER FROM command to indicate the new location.
Use the ALTER SYSTEM ARCHIVE command to indicate the new
location.
123. Which statement about disabling archival destinations is true?
Answer: You can disable any archival destination as long as you have enough enabled archival destinations left to meet the LOG_ARCHIVE_MIN_SUCCESS threshold value.
124. You are configuring a database for ARCHIVELOG mode. Which two initialization parameters should you use? (Choose two)
Answer: ARCHIVELOG_MODE
LOG_ARCHIVE_DEST
125. How often does a read-only tablespace need to be backed up?
Answer: Only once after the tablespace becomes read-only.
126. You should issue a backup of the control file after issuing which command?
Answer: CREATE TABLESPACE.
127. Which initialization parameter’s must a DBA specify to define three archive locations?
Answer: LOG_ARCHIVE_DEST, LOG_ARCHIVE_DEST_1, and
LOG_ARCHIVE_DEST_2
128. How would you recover from a datafile corruption that affects the EMPLOYEE table if the index on the table is still available?
Answer: Use an index scan to retrieve the data in the corrupt blocks.
129. Which type of failure would occur if a CPU fails on the system?
Answer: Instance failure.
130. The PROD database is running in NOARCHIVELOG mode and a media failure occurs. The disk drive holding one of the datafiles cannot be replaced immediately and you have moved the datafile to another drive. Which command would you issue to reflect this physical change in the database?
Answer: ALTER DATABASE RENAME FILE.
131. Why would you query V$ARCHIVED_LOG?
Answer: To display the archives that have been backed up.
132. How does a logical copy differ from a physical copy when used as a backup?
Answer: Logical copies are taken while the database is being accessed by users.
133. Which Recovery Manager command will identify all the datafiles that have
not been backed up in the last two days?
Answer: rman> report need backup days 2
134. You need to perform an online complete recovery. Which tablespace cannot
be included in the recovery operation?
Answer: SYSTEM.
135. Which two files are not part of the physical database files, but should be
included in the backup? (Choose two)
Answer: Password file. Parameter file
136. When would you need to resynch the recovery catalog with its target database?
Answer: When you add a tablespace to the target database.
137. You are developing a backup and recovery strategy for your company’s data.
What should be one of your primary considerations?
Answer: Database activity level.
138. Which two processes reclaim database resources that are no longer needed
by a user? (Choose two)
Answer: PMON
SMON
139. Why does a database in ARCHIVELOG mode require more system resources than a database in NOARCHIVELOG mode?
Answer: More disk space is required to hold archived redo logs.
140. Which RUN command option would you use in RMAN to execute an operating system command?
Answer: HOST.
141. Which is a feature of Recovery Manger?
Answer: Detects corrupted blocks.
142. Which utility is used to interact with RMAN in a Windows interface?
Answer: Backup Manager.
143. Your company has relatively static data and the database is refreshed each quarter. How often should you back up the database?
Answer: Less frequently than a company with volatile data.
144. What can you do to prevent recreating the control file due to a media
failure?
Answer: Place several copies across several disks.
145. To recover the PROD database, you need to apply a large number of archived logs. Which command would you issue to automatically apply the archived logs when the recovery process is started?
Answer: SET AUTORECOVERY ON.
146. You renamed and moved a datafile to another physical location due to media failure. Which file must you manually update to reflect this cdhange in the database?
Answer: None.
147. The database will not open because one of the redo log files is missing. The
current sequence is 58 and the missing file is 57. Which command would you
issue to recover?
Answer: RECOVER DATABASE UNTIL CANCEL.
148. Which three types of files must be synchronized for recovery to take place?
(Choose three)
Answer: Data files.
Control files.
Redo log files.
149. Which format value would you use in a backup set command to include the backup set number in the name of the backup file?
Answer: %s
150. To back up the PROD database to disk, you performed offline physical
backups. How will using a physical copy as a backup impact your database?
Answer: It will require more disk space.
151. Which Export parameter would you use to specify the names of the tables to export?
Answer: TABLES.
152. The PROD database has 10 datafiles stored on 2 disk drives. You need to perform a full database backup. How many files will be multiplexed per set if
the FILESPERSET option is set to 3?
Answer: 3.
153. Why would you query V$BACKUP_REDOLOG?
Answer: To list the backup sets that include the archived logs.
154. A user updated the Payroll application tables with information that should
have been applied to an earlier payroll period. You have to recover the database to the point prior to this update. Which type of recovery can you perform?
Answer: Incomplete recovery in ARCHIVELOG mode.
155. Evaluate this command:
rman> list backupset to datafile ‘/disk1/data/user02.dbf;
Why would you issue this command?
Answer: To display all backup sets that contain user02.dbf.
156. Which export mode would you use to export specified tables in a user’s schema?
Answer: Table.
157. You are performing an incomplete recovery because an archived redo log file
is missing. What will be the result of this incomplete recovery?
Answer: All transactions after the point of recovery will be lost.
上一篇文章: ORACLE常见错误代码的分析与解决 下一篇文章: 拿到了OCP证书，贡献OCP学习经验
相关文章:
相关软件: