网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
A
DBA_PENDING_TRANSACTIONS
B
DBA_AUDIT_STATEMENT
C
V$FLASHBACK_DATABASE_STATS
D
FLASHBACK_TRANSACTION_QUERY
参考答案
参考解析
解析：
暂无解析
更多 “单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A DBA_PENDING_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY” 相关考题
考题
单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A
The index tablespace contains bitmap indexes.B
The index tablespace contains more than one data file.C
The index tablespace supports only complete recovery.D
The index tablespace is not a dictionary-managed tablespace.E
There is a dependency relationship between a table and its indexes.
考题
单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A
recycle buffer cacheB
large poolC
streams poolD
keep buffer cacheE
redo log buffer
考题
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A
V$LOGB
V$LOGFILEC
DBA_LOG_GROUPSD
V$LOG_HISTORY
考题
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A
loss of one of the tablespacesB
loss of a system data fileC
loss of one of the control filesD
loss of a tempfileE
loss of the only member of an unarchived redo log groupF
loss of a member from each redo log group
考题
单选题You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D
Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until last Sunday’s backupC
until Wednesday eveningD
until that point in time when the database is openedE
until that point in time when the recovery is performedF
until that point in time when the table is dropped and purged
热门标签
最新试卷