96.Which two operations can be performed on an external table? (Choose two.) A.Create a view on the
来源:互联网 发布:淘宝兼职广告语大全集 编辑:程序博客网 时间:2024/04/28 07:22
96.Which two operations can be performed on an external table? (Choose two.)
A.Create a view on the table.
B.Create an index on the table.
C.Create a synonym on the table.
D.Add a virtual column to the table.
E.Update the table using the UPDATE statement.
F.Delete rows in the table using the DELETE command.
答案:AC
由于外部表,是外部的文件,所以只能进行select,不可以进行delete和update
--我们每个选项测试一下
1.首先查看当前哪个是外部表
SQL> select TABLE_NAME from user_external_tables;
TABLE_NAME
------------------------------
TEST_DELTA
SQL> desc TEST_DELTA ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(100)
SQL> select * from test_delta;
ID
--------------------------------------------------------------------------------
1
2
3
4
5
6
7
8
8 rows selected.
SQL>
2.测试创建一个视图(A选项正确)
SQL> create view v_test as select * from test_delta;
View created.
3.测试创建一个索引(B选项错误)
SQL> create index i_text on test_delta(id);
create index i_text on test_delta(id) *
ERROR at line 1:
ORA-30657: operation not supported on external organized table
4.测试一个同义词(C选项正确)
SQL> create synonym s_test for test_delta;
Synonym created.
5.测试虚拟列(D选项错误)
SQL> alter table test_delta add(id2 as (id*2));
alter table test_delta add(id2 as (id*2))
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
6.测试update(E选项错误)
SQL> update test_delta set id=10;
update test_delta set id=10
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
7.测试delete(F选项错误)
SQL> delete from test_delta;
delete from test_delta
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
A.Create a view on the table.
B.Create an index on the table.
C.Create a synonym on the table.
D.Add a virtual column to the table.
E.Update the table using the UPDATE statement.
F.Delete rows in the table using the DELETE command.
答案:AC
由于外部表,是外部的文件,所以只能进行select,不可以进行delete和update
--我们每个选项测试一下
1.首先查看当前哪个是外部表
SQL> select TABLE_NAME from user_external_tables;
TABLE_NAME
------------------------------
TEST_DELTA
SQL> desc TEST_DELTA ;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(100)
SQL> select * from test_delta;
ID
--------------------------------------------------------------------------------
1
2
3
4
5
6
7
8
8 rows selected.
SQL>
2.测试创建一个视图(A选项正确)
SQL> create view v_test as select * from test_delta;
View created.
3.测试创建一个索引(B选项错误)
SQL> create index i_text on test_delta(id);
create index i_text on test_delta(id) *
ERROR at line 1:
ORA-30657: operation not supported on external organized table
4.测试一个同义词(C选项正确)
SQL> create synonym s_test for test_delta;
Synonym created.
5.测试虚拟列(D选项错误)
SQL> alter table test_delta add(id2 as (id*2));
alter table test_delta add(id2 as (id*2))
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
6.测试update(E选项错误)
SQL> update test_delta set id=10;
update test_delta set id=10
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
7.测试delete(F选项错误)
SQL> delete from test_delta;
delete from test_delta
*
ERROR at line 1:
ORA-30657: operation not supported on external organized table
0 0
- 96.Which two operations can be performed on an external table? (Choose two.) A.Create a view on the
- 71.Which arithmetic operations can be performed on a column by using a SQL function that is built in
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert
- golang:An operation on a socket could not be performed because the system lacked sufficient buffer s
- 128 Which two statements are true about a job chain? (Choose two.) A. A job chain can contain a nest
- 73 Which two are the prerequisites to enable Flashback Data Archive? (Choose two.) A. Database must
- 108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A.
- 142 Which two statements are true about encrypting RMAN backup? (Choose two.) A. The transparent enc
- 140.Identify two situations in which the block header grows in a data block. (Choose two.)
- svn报错can only be performed on a version resource [at this time].
- CHECKOUT can only be performed on a version resource [at this time].
- svn报错can only be performed on a version resource [at this time].
- 重装Eclipse提交时遇到CHECKOUT can only be performed on a version resource的问题
- 34 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A.
- Identify two situations in which the block header grows in a data block. (Choose two.) 选项 A.when ro
- 156.Examine the following steps performed on a database instance: 1: The DBA grants the CREATE TABL
- Getting “CHECKOUT can only be performed on a version resource” when trying to commit using Eclipse s
- windows 10 Bitlocker新特性及破解方法简介
- Selenium源码分析之WebDriver
- POJ 2386 Lake Counting(水淹菜地,DFS,八连通,连通分量)
- 记一次工作中的不愉快
- [bzoj3236][Ahoi2013]作业(莫队+树状数组)
- 96.Which two operations can be performed on an external table? (Choose two.) A.Create a view on the
- Oracle登陆问题
- 配置网络文件系统
- 【Android笔记】Service的生命周期
- Neutron-server初始化 — Neutron L2 Agent服务初始化
- 深入理解Java:注解(Annotation)自定义注解入门
- 分享:孟岩的《理解矩阵》一文
- 学习TOGAF企业架构的必要性——上海信息化培训中心
- eclipse插件OpenExplorer快速打开文件目录