William used the Flashback Version Query feature.
William issued the CROSSCHECK command at the RMAN prompt.
William viewed the alert log file.
William used the Flashback Table feature.
第1题：
William______to bed until 12 o’clock last night.
A、didn’t go
B、hadn’t gone
C、went
D、has gone
第2题：
A. show ip ospf [process - id] interface
B. show ip ospf neighbor
C. show ip ospf [process - id]
D. show ip ospf [process - id area - id] database
第3题：
A
June Calendar for After-school Activities in St. Peter High School
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Satur
day
1
Football
3:00-6:00 pm
2
Movie
4:00 pm
3
Book Club
3:00-6:00 pm
4
5
6
Movie
6:00pm
7
Singing Class
4:00-6:00 pm
8
High Jump
4:00-6:00 pm
9
Sewing Class
3:00-5:00pm
10
Dance Class
4:00-6:00
pm
11
12
13
Camera Club
2:30-5:30 pm
14
Singing Class
2:30-4:30 pm
15
Swimming
3:30-4:30 pm
16
Travel Lecture
2:00-5:00pm
17
Exercise Class
9:00-12:00 am
18
19
20
Basketball
3:00-6:00
pm
21
Fashion Show
2:00-5:00
pm
22
Tennis
4:00-6:00
pm
23
Movie
7:00 pm
24
Picnic
1:00-7:00
pm
25
26
27
Dance Class
4:00-6:00 pm
28
Painting
3:00-5:00 pm
29
Volleyball
3:00-6:00 pm
30
Piano Class
3:00-4:00
pm
( )56.What time does the movie start on 23rd ?
A. At 2:00
B. At 3:00
C. At 6:00
D. At 7:00
第4题：
At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion： SELECT operation， undo_sql， logon_user FROM FLASHBACK_TRANSACTION_QUERY WHERE xid= HEXTORAW（’0100043E23456’）； where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）
第5题：
An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）
第6题：
At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：
SELECToperation，undo_sql，logon_user
FROMFLASHBACK_TRANSACTION_QUERYWHERExid=
HEXTORAW（’0100043E23456’）；
where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）
第7题：
William,Duke of Normandy,is now known as（）.
第8题：
Which of the following is not responsibility of DBA(Data Base Administrator)?
A．Database management system design
B．Database schema definition
C．Database schema modification
D．Integrity constraint specification
第9题：
A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution？（）
第10题：
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）