下列符号中能够作为C++标识符的是A．constB．2aC．_shapeD．-connt

Bymistake，youranthebatchjob（forupdatingtheBILL_DETAILStable）twice.YouarenotsurewhichrowsintheBILL_DETAILStablewereaffected.Youneedtoidentify：a）alistofchangesmadealongwiththetransactionidentifierofeachchangeb）thenecessarySQLstatementstoundotheerroneouschangesWhichoptionwouldyouchoose？（）

A.RMANonly

B.FlashbackTableonly

C.FlashbackVersionsQueryonly

D.FlashbackDatabaseandFlashbackTransactionQuery

E.FlashbackVersionsQueryandFlashbackTransactionQuery

A. An error is generated.

B. You will have two identical tables in the HR schema with different names.

C. You create a table called employees in the HR schema based on you EMP table.

D. You create an alternative name for the employees table in the HR schema in your own schema.

A.A

B.B

C.C

D.D

A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

failures:RMAN> LIST FAILURE;After some time, you executed the following command in the same session:RMAN> ADVISE FAILURE;But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）

A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

Inyourproductiondatabase，datamanipulationlanguage（DML）operationsareexecutedontheSALEStable.YouhavenoticedsomedubiousvaluesintheSALEStableduringthelastfewdays.Youareabletotrackusers，actionstaken，andthetimeoftheactionforthisparticularperiodbutthechangesindataarenottracked.Youdecidetokeeptrackofboththeolddataandnewdatainthetablealongwiththeuserinformation.Whatactionwouldyoutaketoachievethistask（）

A.Applyfine-grainedauditing.

B.Implementvalue-basedauditing.

C.Imposestandarddatabaseauditingtoauditobjectprivileges.

D.ImposestandarddatabaseauditingtoauditSQLstatements.

databaseinstance.Atacertainpointoftime，themaintenancewindowclosesbeforethestatisticsaregatheredforallobjects.Whichstatementistrueinthisscenario（）

A.Thestatisticscollectioncontinuesuntilallobjectsareprocessed.

B.Thejobisterminatedandthestatisticscollectedarerestoredtoatimebeforethejobstarted.

C.Thisproducesanerrorandthestatisticscollectedarelockeduntilthenexttimethatthemaintenancewindowisopened.

D.Thejobisterminatedandthestatisticsfortheremainingobjectsarecollectedthenexttimethatthemaintenancewindowisopened

YouhavejustperformedaFLASHBACKTABLEoperationusingthefollowingcommand：flashbacktableemployeestoscn123456；Theemployeestablehastriggersassociatedwithit.WhichofthefollowingstatementsistrueregardingthestateofthetriggersduringtheFlashbackTableoperation？（）

A.Allthetriggersaredisabled.

B.Allthetriggersareenabledbydefault.

C.Enabledtriggersremainenabledanddisabledtriggersremaindisabled.

D.TriggersaredeletedwhenaFlashbackTableoperationisperformed.

TMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?（）

A. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu

B. CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);

C. CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;

D. CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;

E. CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu

F. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

A.AnSCNisneverusedtoperformaFlashbackTablerecovery.

B.Ifasignificantnumberofchangeshavebeenmadetothetable，rowmovementmustbeenabled.

C.ThetablespacemustbeofflinebeforeperformingaFlashbackTablerecovery.

D.FlashbackTablerecoveryiscompletelydependentontheavailabilityofundodataintheundo tablespace.