【多选题】You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database admi...
A.
Use a flashback query to retrieve the rows that were deleted
B.
Useconventialincremental export and then import the affected object
C.
Shutdown the database inNORMALmode and restart the database instance
D.
Use DBMS_META package to reconstruct the object using undo segments
E.
UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
F.
Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
【判断题】北京某公司进口10辆日本汽车,货物到达天津口岸后,应直接向天津检验检疫局办理报检手续。( )
【单选题】ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table t...
A.
The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B.
The table definition on the slave -litters from the master
C.
Multi-threaded replication slaves can have temporary errors occurring for cross database updates
D.
The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
【判断题】唐山万达电器公司进口10辆韩国汽车,货物到达天津口岸后,应直接向天津检验检疫局办理报检手续。( )
【单选题】预订取消 后, 客人 状态(Status)为( )。
【多选题】You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index is then created o...
A.
It stores only the temporary table but not its indexes.
B.
It stores both the temporary table as well as its indexes.
C.
It must be a nondefault temporary tablespace for the database.
D.
It can be a default or nondefault temporary tablespace for the database.
E.
It must be the default temporary tablespace of the user who issues the command.
【判断题】北京某公司进口10辆日本汽车,货物到达天津口岸后,应直接向天津检验检疫局办理报检手续。( )
【多选题】来自美国的卡尔先生并未预订客房,直接来到酒店前台办理入住手续,前台接待员为卡尔办理入住手续后,卡尔先生的客人状态status错误的是( )