CMS专题
单选题Note the output of the following query； SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： A
题目
The table uses the default Flashback Data Archive.
The Flashback Data Archive Is created In the SYSAUX tablespace.
The Flashback Data Archive is created in the same tablespace where the tables are stored.
The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
相似问题和答案
第1题：
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.
第2题：
A. GRANT select ON dept TO ALL_ USER;
B. GRANT select ON dept TO ALL;
C. GRANT QUERY ON dept TO ALL_USERS
D. GRANT select ON dept TO PUBLIC;
第3题：
用SQL命令生成含有字段职工号、姓名的视图，下列语句正确的是______。
A．CREATE VIEW ZG w AS SELECT职工号，姓名FROM职工
B．CREATE QUERY ZG w AS SELECT职工号，姓名FROM职工
C．CREATE VIEW ZG w AS SELECT职工号，姓名
D．CREATE QUERY ZG w AS SELECT职工号，姓名
解析：视图是根据对表的查询 来定义的，可以用命令方式来建立查询，具体格式如下：
CREATEVIEWview_name[(column_nameLcolumn_nameL…)]
ASselect statement
说明：view_name指定要创建的视图的名称；当没有为视图指定字段名(column_name)时，视图的字段名将与select statement中指定的字段名或表中的字段名同名；select_statement是任意的SELECT查询语句。本题利用SELECT语句来指定职工表的字段职工号，姓名为查询字段。
第4题：
SQL是哪几个英语单词的缩写（）
- A、Standard Query Language
- B、Structured Query Language
- C、Select Query Language
- D、其他三项都不是
正确答案:B
第5题：
SQL是 ______的缩写。
A．Standard Query Language
B．Structured Query Language
C．Select Query Language
D．以上都不是
解析：SQL是结构化查询语言Structured Query Language的缩写。
第6题：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第7题：
用SQL命令生成含有字段职工号、姓名的视图，下列语句正确的是 ______。
A．CREATE VIEW ZG_w AS SELECT职工号，姓名FROM职工
B．CREATE QUERY ZG_w AS SELECT职工号，姓名FROM职工
C．CREATE VIEW ZG w AS SELECT职工号，姓名
D．CREATE QUERY ZG_w AS SELECT职工号，姓名
解析：视图是根据对表的查询来定义的，可以用命令方式来建立查询，具体格式如下：CREATEVIEWview_name[(column_name[，column_name]...)]ASselect_statement说明：viewname指定要创建的视图的名称；当没有为视图指定字段名(columnname)时，视图的字段名将与selectstatement中指定的字段名或表中的字段名同名；selectstatement是任意的SELECT查询语句。本题利用SELECT语句来指定职工表的字段职工号，姓名为查询字段。
第8题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）
A.
B.
C.
D.
第9题：
SQL是哪几个英文单词的缩写?
A．Standard Query Language
B．Structured Query Language
C．Select QueryL anguage
D．以上都不是
解析：SQL是结构化查询语言(Structured Query Language)的缩写。
第10题：
Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
- A、It is ignored by the query optimizer.
- B、It is not used while the index is being rebuilt.
- C、The index cannot be rebuilt， and has to be re-created.
- D、The index is automatically rebuilt when used the next time
正确答案:A,B