单项选择题
A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
多项选择题 Youstartedalongtransaction.Beforecommitting,youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror:ORA-01555:snapshottoooldHowwouldyoupreventsuchanerrorinthefuture?()
单项选择题 When you try to open your database, you receive the following error: ORA-00205: error in identifying control file Where would you find the details required to resolve this error?()
单项选择题 OneoftheusersinthePRODdatabase,Adams,complainsthathisupdateonthetable,TRANS,istakinganunusuallylongtimetocomplete.YoufindthatthetablegetslockedbyanotherdatabaseuserbeforeAdamsstartshistransactions,andyouareunabletocontacttheuserholdingthetablelock.AsAdamsisupdatingsomecrucialrowsinthetable,heshouldgetthehighestpriority.Whichmethodwouldyouusetoovercomethisproblem?()