当前位置:1Z0-007题库

问题:

[单选]

Evaluate the set of SQL statements:
CREATE TABLE dept
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(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 occupied 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.

GB16163《瓶装压缩气体分类》中列出的可燃气体共()种。 32。 33。 34。 35。 Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?() Mount the container database (CDB) and restore the control file from the control file auto backup.。 Recover and open the CDB in NORMAL mode.。 Mount the CDB and then recover and open the database, with the RESETLOGS option.。 Open all the pluggable databases.。 Recover each pluggable database.。 Start the database instance in the nomount stage and restore the control file from control file auto backup.。 隋唐时期实行三省六部制,下列关于该制度的评述正确的是()。①分散相权以加强皇权②形成严密的封建官僚机构③有利于减少中央政令的失误④三省六部一直被后世历朝沿袭 ①②③。 ②③④。 ①②④。 ①③④。 简述电子签名与传统签名的功能比较。 You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?() Event Viewer gives more details on the failure.。 The alert log file gives detailed information about the failure.。 PMON rolls back the transaction and releases the locks.。 SMON rolls back the transaction and releases the locks.。 The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.。 Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.。

Evaluate the set of SQL statements:
CREATE TABLE dept
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set?()

参考答案:

  参考解析

本题暂无解析

在线 客服