black

1z0-043

登录

单项选择题

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?()

A. William used the Flashback Version Query feature.
B. William issued the CROSSCHECK command at the RMAN prompt.
C. William viewed the alert log file.
D. William used the Flashback Table feature.

相关考题

单项选择题 YouareemployedasaDBAinanorganization.YouareinformedthattherecordofEMP_NO1000ismissingfromtheSCOTT.EMPtable.Youarerequiredtoidentifytheuserwhodeletedtherecord,theSQLstatementthatwillundothedeletion,andthetransactionIDofthetransactionthatdeletedtheemployeerecord.Whichfeaturewillyouusetoperformthetasks?()

单项选择题 InwhichscenariowillyouusetheFlashbackTransactionQueryfeature?()

单项选择题 YouquerytheORDERStableanddiscoverthatordernumber1101ismissing.Oneofyourreports,generatedat5:00A.M.onApril23,2005usingOracleReports,includesthisordernumberintheoutput.Youhaveinserted100newordersintotheORDERStablesincegeneratingthisreport.Whichflashbacktechnologywouldyouusetorecoverordernumber1101intotheORDERStablewithoutlosingthe100ordersthatyouaddedafterthereportwasgenerated?()

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号:湘ICP备2020024380号-3