网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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” 相关考题
考题
第二节（共6小题，每小题1分，满分6分）听下面6段对话。每段对话后有一个小题， 从题中所给的A、B、C三个选项中选出最佳选项。听完每段对话后，你有10秒钟的时间来回答有关小题和阅读下一小题。每段对话仅读一遍。7.At what time does the shop open on Wednesday？A.10 a.m B.9 a.m. C.8 a.m.
考题
We offer firm CIF, Lagos shipment()30 days, subject to your reply here ()10 a.m., our time.A、within,withinB、for,byC、during,byD、in,untill
考题
Deaths were _________ less in Los Angeles because the accident happened at 4:31 a.m. on a holiday, when traffic(交通) was not busy.
A、relativelyB、airplaneC、fenceD、annual
考题
【通用】根据定向溢价规则，定向核心城市、定向重点城市、定向iOS分别溢价加收多少？（）A、10%；10%；10%B、10%；10%；30%C、30%；30%；10%D、30%；10%；30%
考题
Bob, a technician, wants to run antivirus scans on every machine on a daily basis. To minimize the impact to all system resources, which of the following is the BEST time to schedule the scans to run?（）A、5:00 p.m. - 7:00 p.m.B、7:30 a.m. - 9:30 a.m.C、11:00 p.m. - 1:00 a.m.D、12:00 p.m. - 2:00 p.m.
考题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
考题
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
考题
问答题Femi，Martin and James catch trains to go to the same destination. Femi catches the 8∶15 a.m. train. Martin’s train journey takes twice as long as James’. Martin leaves 15 minutes before Femi and arrives at noon. James catches the 11∶30 a.m. trains. What time does James arrive at the destination?
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题ou can visit Galloway Wildlife Conservation Park ______A
at 9:00 a. m. on 7th DecemberB
at 11:00 a.m. on 7th DecemberC
at 9:00 a.m. on 7th SeptemberD
at 11:00 a. m. on 7th September
考题
问答题Femi, martin and James catch trains to go to the same destination. Femi catches the 8:15 a.m. train. Martin’s train journey takes twice as long as James’. Martin leaves 15 minutes before Femi and arrives at noon. James catches the 11:30 am trains. What time does James arrive at the destination?
考题
单选题You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）A
Create a manual incremental online database backup.B
Back up all the archived redo logs generated since the 8 a.m. backup.C
Create a brand-new backup after all the changes have been applied.D
There is no way to make the changes recoverable based on the 8 a.m. backup.E
Perform an online backup of the tablespace（s） that contained changed data.
考题
单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A
by using the SQL access advisorB
by using the Automatic Workload Repository reportC
by running the Automatic Database Diagnostic Monitor （ADDM）D
by using the Automatic Workload Repository Compare Period reportE
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
单选题Bob, a technician, wants to run antivirus scans on every machine on a daily basis. To minimize the impact to all system resources, which of the following is the BEST time to schedule the scans to run?（）A
5:00 p.m. - 7:00 p.m.B
7:30 a.m. - 9:30 a.m.C
11:00 p.m. - 1:00 a.m.D
12:00 p.m. - 2:00 p.m.
考题
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A
time-based recoveryB
log sequence recoveryC
cancel-based recoveryD
change-based recovery
考题
单选题You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A
Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B
Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C
Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
考题
单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）A
restore all the data files from last Sunday’s backup， and then perform a timebased recoveryB
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryC
restore all the data files from last Sunday’s backup， and then perform a changebased recoveryD
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
考题
问答题Practice 5 ● Photos used on staff passes will be taken from 9 a.m. to 11 a.m. next Thursday. ● write a memo to all staff telling: ● The time slot when the photographer will be working; ● What they should look like and wear. ● Write about 30—40 words.
考题
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A
timebased recoveryB
log sequence recoveryC
cancelbased recoveryD
changebased recovery
考题
单选题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 took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A
all the datafiles in the databaseB
the datafiles associated with the SYSTEM tablespaceC
the datafiles associated with the DATA1 tablespaceD
all the datafiles in the database except those associated with the DATA1 tablespace
考题
单选题A.m.的含义是（）A
饭前B
饭后C
睡前D
上午E
下午
热门标签
最新试卷