网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;
A
emp表中数据处于回滚段中
B
emp表中的数据被永久删除
C
emp表中的数据没有变化
D
原来的emp表中的数据被添加到新emp表中
E
以上所述都不正确
参考答案
参考解析
解析：
暂无解析
更多 “单选题有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;A emp表中数据处于回滚段中B emp表中的数据被永久删除C emp表中的数据没有变化D 原来的emp表中的数据被添加到新emp表中E 以上所述都不正确” 相关考题
考题
● 撤销 U5 对 Emp 表的查询权限，并收回 U5 授予其它用户的该权限，SQL 语句是 （51） 。（51）A. REVOKE SELECT ON TABLE Emp FROM U5 CASCADE;B. REVOKE SELECT ON TABLE Emp FROM U5 RESTRICT;C. REVOKE QUERY ON TABLE Emp FROM U5 CASCADE;D. GRANT SELECT ON TABLE Emp TO U5 WITH GRANT OPTION;
考题
以下语句错误的是( )A. alter table emp delete column addcolumn;B. alter table emp modify column addcolumn char(10);C.alter table emp change addcolumn addcolumn int;D. alter table emp add column addcolumn int;
考题
以下删除记录正确的( )A.delete from emp where name='dony';B.Delete * from emp where name='dony';C.Drop from emp where name='dony';D.Drop * from emp where name='dony';
考题
以下能够删除一列的是( )A.alter table emp remove addcolumnB.alter table emp drop column addcolumnC.alter table emp delete column addcolumnD.alter table emp delete addcolumn
考题
某数据库系统中，假设有部门关系 Dept (部门号，部门名，负责人，电话)，其中， 部门号是该关系的主键；员工关系 Emp (员工号，姓名，部门，家庭住址)，属性家 庭住址包含省、市、街道以及门牌号，该属性是一个（ ）属性。 创建 Emp 关系的 SQL 语句如下: CREATE TABLE Emp( 员工号 CHAR(4) （ ）， 姓名 CHAR(10)， 部门 CHAR(4)， 家庭住址 CHAR(30)， （ ）; 为在员工关系 Emp 中增加一个工资字段，其数据类型为数字型并保留2 位小数， 可采用的 SQL 语句为（ ）。A. 简单 B. 复合 C.多值 D. 派生A. PRIMARY KEY B. NULL C. FOREIGN KEY D. NOT NULLA.PRIMARY KEY NOT NULLB. PRIMARY KEY UNIQUEC. FOREIGN KEY REFERENCES Dept(部门名)D. FOREIGN KEY REFERENCES Dept(部门号)A.ALTER TABLE Emp ADD 工资 CHAR(6,2);B.UPDATA TABLE Emp ADD 工资 NUMERIC(6，2);C.ALTER TABLE Emp ADD 工资 NUMERIC （6,2）;D.ALTER TABLE Emp MODIFY 工资 NUMERI C(6,2);
考题
下列哪个操作可以将表中的数据删除,并且不需要回滚删除后回收其所占有的空间,但表定义保留()
A.DELETE FROM EMP;B.TUNCATE TABLE EMP;C.TUNCATE TABLE EMP REUSE STORAGE;D.DROP TABLE EMP;E.以上所述都不正确
考题
有如下三步操作,并且均成功执行,请选择结果()delete from emp;alter table emp add(addr varchar2(40));rollback;
A. emp表中数据处于回滚段中B. emp表中的数据被永久删除C. emp表中的数据没有变化D. 原来的emp表中的数据被添加到新emp表中E. 以上所述都不正确
考题
某数据库系统中，假设有部门关系：Dept(部门号，部门名，负责人，电话)，其中，"部门号"是该关系的主键；员工关系Emp(员工号，姓名，部门，家庭住址)，属性"家庭住址"包含省、市、街道以及门牌号，该属性是一个( )属性。
创建Emp关系的SQL语句如下：
CREATE TABLE Emp(员工号CHAR59 ( ),姓名CHAR60,部门CHAR59,家庭住址CHAR62,( );
为在员工关系Emp中增加一个"工资"字段，其数据类型为数字型并保留2位小数，可采用的SQL语句为(请作答此空)。A.ALTER TABLE Emp ADD工资CHAR(6，2)；
B.UPDATA.11ABLE Emp ADD工资NUMERIC(6，2)；
C.ALTER TABLE Emp ADD工资NUMERIC(6，2)；
D.ALTER TABLE Emp MODIFY工资NUMERIC(6，2)；
考题
删除emp表中所有数据，且无法rollback，以下语句哪个命令可以实现（）A、truncate table empB、drop table empC、delete * from empD、delete from emp
考题
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）A、DROP emp_dept_uv;B、DELETE emp_dept_uv;C、REMOVE emp_dept_uv;D、DROP VIEW emp_dept_uv;E、DELETE VIEW emp_dept_uv;F、REMOVE VIEW emp_dept_uv;
考题
删除emp表的全部数据，但不提交，以下正确的语句是（）A、DELETE * FROM. EMPB、DELETE FROM EMPC、TRUNCATE TABLE EMPD、DELETE TABLE EMP"
考题
您需要从方案中的雇员表中删除EMP_FK_DEPT约束条件。应使用哪条语句（）A、DROP CONSTRAINT EMP_FK_DEPT FROM雇员B、DELETE CONSTRAINT EMP_FK_DEPT FROM雇员C、ALTER TABLE雇员DROP CONSTRAINT EMP_FK_DEPTD、ALTER TABLE雇员REMOVE CONSTRAINT EMP_FK_DEPT
考题
如下能正确执行的语句是（）A、select * from table_name where 1=2B、truncate table table_nameC、delete from table_name where null=nullD、alter table table_name add column idd int
考题
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） A、 Index-organized tableB、 Mapping TableC、 Clustered TableD、 Journal Table
考题
有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;A、emp表中数据处于回滚段中B、emp表中的数据被永久删除C、emp表中的数据没有变化D、原来的emp表中的数据被添加到新emp表中E、以上所述都不正确
考题
下列哪个操作可以将表中的数据删除，并且不需要回滚删除后回收其所占有的空间，但表定义保留（）A、DELETE FROM EMP;B、TUNCATE TABLE EMP;C、TUNCATE TABLE EMP REUSE STORAGE;D、DROP TABLE EMP;E、以上所述都不正确
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）A、LOCK TABLE emp IN SHARE MODE;B、LOCK TABLE emp IN EXCLUSIVE MODE;C、DELETE FROM emp WHERE job=’MANAGER’;D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
考题
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A
The PRIMARY KEY is created along with a new index.B
The PRIMARY KEY is created and it would use an existing unique index.C
The PRIMARY KEY would be created in a disabled state because it is using an existing index.D
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
考题
单选题下列哪个操作可以将表中的数据删除，并且不需要回滚删除后回收其所占有的空间，但表定义保留（）A
DELETE FROM EMP;B
TUNCATE TABLE EMP;C
TUNCATE TABLE EMP REUSE STORAGE;D
DROP TABLE EMP;E
以上所述都不正确
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified timeE
to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified time
考题
单选题有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;A
emp表中数据处于回滚段中B
emp表中的数据被永久删除C
emp表中的数据没有变化D
原来的emp表中的数据被添加到新emp表中E
以上所述都不正确
考题
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A
You must enable the row movement on the SCOTT.EMP table.B
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CDELETE FROM emp WHERE job=’MANAGER’;DINSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;ESELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
考题
单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）A
Exhibit AB
Exhibit BC
The query returns no rowsD
The query fails because the outer query is retrieving more than one columnE
The query fails because both the inner and outer queries are retrieving data from the same table.
热门标签
最新试卷