SQL命令：DROP DATABASE MyDB;的功能是（）

A . stdat1 B . student1 C . stdb D . student2

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A . mydb is a service name. B . test.us.oracle.com is a database name. C . 1521 is the listener port number. D . mydb is a host name. E . test.us.oracle.com is a net service name. F . hr is a username. G . test.us.oracle.com is an instance name.

A . You cannot roll back this statement. B . All pending transactions are committed. C . All views based on the DEPT table are deleted. D . All indexes based on the DEPT table are dropped. E . All data in the table is deleted, and the table structure is also deleted. F . All data in the table is deleted, but the structure of the table is retained. G . All synonyms based on the DEPT table are deleted.

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A . The Flashback Archive FLA1 is dropped only if it is empty. B . The tablespace having Flashback Archive is dropped. C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. D . The Flashback Data Archive and historical data are dropped.

A . 正确 B . 错误

A .  The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are  already in the Recycle Bin are dropped. B .  The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped. C .  The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped. D .  The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.

A . 正确 B . 错误

A . 实例恢复是打开数据库之前执行 B . 所有的日志文件成员的路径和存在进行检查 C . 所有的在线数据文件头进行一致性检查 D . 联机重做日志文件和联机数据文件被打开

A . 每一个会话drop属于scott用户的表成功就会产生一条审计记录 B . 凡是每一个scott用户会话成功drop table操作，就会存在一条审计记录 C . 同一个scott会话中，drop一张或多张表成功就会产生一条审计记录 D . scott用户授权给其它用户drop table权限时就会生成一条审计记录

A . One audit record is created for every successful DROP TABLE command executed in the session of SCOTT. B . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

A . All data along with the table structure is deleted  B . The pending transaction in the session is committed  C . All indexes on the table will remain but they are invalidated  D . All views and synonyms will remain but they are invalidated  E . All data in the table are deleted but the table structure will remai

A . 数据查询 B . 数据操作 C . 数据定义 D . 数据控制

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A． 删除索引 B．建立索引 C．更新索引 D．修改索引

在SQL语句中，删除视图语句的是()。 A．ZAP VIEW B．ALDER VIEW C．DELETE VIEW D．DROP VIEW

是 否

A．LASHBACK B．GETBACK C．OMEBACK D．以上都不是

A．A B．B C．C D．D

A．建立索引 B．删除目录 C．删除索引 D．修改索引

A．建立索引 B．删除索引 C．修改索引 D．更新索引