单选题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 - 搜考题

违法和不良信息举报联系客服

免费注册登录

题目

单选题

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.

参考答案：C

第2题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

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

正确答案:C

第3题：

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()

A. There is demand for space from the new table从

B. The undo tablespace does not have sufficient free space

C. The new table name is the same as the table name in the recycle bin

D. The temporary tablespace that is assigned to you does not have sufficient free space

参考答案：A

第4题：

Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）

A、 The statement will be executed successfully， and a new time zone will be set for the database.
B、 The statement will be executed successfully， but a new time zone will not be set for the database.
C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

正确答案:D

第5题：

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.

正确答案:D

第6题：

All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）

A、all sessions of the HR user only
B、all sessions of the HR user and the SYS user
C、the session of the HR user that executed the commands
D、all the sessions for which the database users have access privilege to the PERSONS table

正确答案:C

第7题：

You issued the following command： SQL> DROP TABLE MYTABLE； SQL> SHOW RECYCLEBIN The following output is returned： ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13：20：11：31 You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

A、 DROP TABLE MYTABLE PURGE；
B、 PURGE RECYCLEBIN；
C、 PURGE TABLE MYTABLE；
D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

正确答案:C,D

第8题：

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

参考答案：B

第9题：

You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）

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

第10题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）

A、The tablespace TBS1 is full.
B、The user is not the owner of the SYSTEM tablespace.
C、The user does not have quota on the TBS1 tablespace.
D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
E、The user does not have sufficient privileges to create table on the default permanent tablespace.

正确答案:C

更多相关问题

相关内容