当前位置:1Z0-007题库

问题:

[单选]

CREATE TABLE dept
(deptno NUMBER(2),
dname VARCNAR2(14),
1oc VARCNAR2 (13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set? ()

A . The DESCRIBE DEPT statement displays the structure of the DEPT table.
B . The ROLLBACK statement frees the storage space occupies by the DEPT table.
C . The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D . The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

Which files can be used together to allow remote command execution on a server?()   /etc/.rhosts and $HOME/hosts.equiv。 /etc/hosts.equiv and $HOME/.rhosts。 /etc/rhosts.equiv and $HOST/.rhosts。 /etc/hosts.equiv and $HOME/.hosts.equiv。 封堵作业中,若管线内介质为液体时,管件焊接时的流速不应大于()米/秒。 5。 7。 9。 10。 You created the DEPT table by using the following command:   CREATE TABLE scott.dept   (deptno NUMBER(3),   dname VARCHAR2(15),   loc VARCHAR2(15) )   STORAGE (INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()  Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.。  Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.。  Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.。  You cannot shrink the SCOTT.EMP table.。 You are speaking to an IT manager with 350 small servers. The IT manager is looking to reduce and consolidate systems.  What strategy would you follow?() Tell the customer that IBM has the best scale-out server strategy.。 Show the benefit of server consolidation with IBM and the return on investment.。 Find out the mixture of server processor and application type.。 Tell the customer to buy smaller servers.。 锅炉灰渣的灰熔点与()有关,锅炉运行过程中()要低于灰渣的灰熔点。

CREATE TABLE dept
(deptno NUMBER(2),
dname VARCNAR2(14),
1oc VARCNAR2 (13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set? ()

参考答案:

  参考解析

本题暂无解析

在线 客服