【单选题】You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.You execute the following statement: DELETE FROM Student What Is the result?
A.
All rows in the table will be deleted.;
B.
All rows containing a NULL value in the FirstName column will be deleted.;
C.
You will receive an error message.;
D.
All rows and the table definition will be deleted.
【多选题】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 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
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
【单选题】构成疾病和证候临床表现的基本要素是( )
【多选题】You work as a database administrator for Supportcenter.cn. 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 adm...
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.
【多选题】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.
【单选题】You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four row...
A.
Data View Row State.Modified Original
B.
Data View Row State.Modified Current
C.
Data View Row State.Current Rows
D.
Data View Row State.Added
【判断题】北京某公司进口10辆日本汽车,货物到达天津口岸后,应直接向天津检验检疫局办理报检手续。( )