150.The user HR receives the following error while inserting data into the TTK table: ERROR at line
来源:互联网 发布:udp端口扫描器报告 编辑:程序博客网 时间:2024/05/16 14:06
150.The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user
to insert data? (Choose three.)
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic n segments is managed through free lists.
答案:ACD
解析:
重置表空间大小
1.这个只是用于字典管理的表空间,如果是本地管理的是无法修改大小的
alter tablespace 表空间名
[minimum extent 正整数[K|M]
|default 存储子句]
2.如果是本地管理的表空间,可以通过如下方法增加大小
a.改变数据文件的大小
i.创建的时候使用autoextend on 自动改变数据文件的大小
ii.创建完后使用autoextend on 选项的alter database命令手动开启自动扩展数据文件大小
alter database datafile '/u01/wahaha.dbf' autoextent on next 1m;
iii.改变数据文件的大小
alter database datafile '/u01/wahaha.dbf' resize 10m;
b.增加数据文件
alter tablespace wahaha add datafile '/u01/wahaha.dbf' size 80M;
A:正确,属于增加数据文件
B:错误,与临时表空间没啥关系
c:正确,属于改变数据文件的大小
D:正确,属于自动改变数据文件的大小
E:错误,没关系,这个是段空间管理,并不是总大小
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user
to insert data? (Choose three.)
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic n segments is managed through free lists.
答案:ACD
解析:
重置表空间大小
1.这个只是用于字典管理的表空间,如果是本地管理的是无法修改大小的
alter tablespace 表空间名
[minimum extent 正整数[K|M]
|default 存储子句]
2.如果是本地管理的表空间,可以通过如下方法增加大小
a.改变数据文件的大小
i.创建的时候使用autoextend on 自动改变数据文件的大小
ii.创建完后使用autoextend on 选项的alter database命令手动开启自动扩展数据文件大小
alter database datafile '/u01/wahaha.dbf' autoextent on next 1m;
iii.改变数据文件的大小
alter database datafile '/u01/wahaha.dbf' resize 10m;
b.增加数据文件
alter tablespace wahaha add datafile '/u01/wahaha.dbf' size 80M;
A:正确,属于增加数据文件
B:错误,与临时表空间没啥关系
c:正确,属于改变数据文件的大小
D:正确,属于自动改变数据文件的大小
E:错误,没关系,这个是段空间管理,并不是总大小
0 0
- 150.The user HR receives the following error while inserting data into the TTK table: ERROR at line
- The session of user SCOTT receives the following error after executing an UPDATE command on the EMP
- 172.The session of user SCOTT receives the following error after executing an UPDATE command on the
- RuntimeError: ('The following error happened while compiling the node
- This page contains the following errors: error on line 1 at column 1: Extra content at the end of t
- Ant BUILD FAILED The following error occurred while executing this line: xxx 解决方案
- Ant BUILD FAILED The following error occurred while executing this line: xxx 解决方案
- Ant打包报错 build.xml:601: The following error occurred while executing this line
- org.dom4j.DocumentException: Error on line 1 of document : The markup in the document following the
- This page contains the following errors: error on line 1 at column 1: Document is empty Below is a
- Laravel Predis Error while reading line from the server.
- Finding and fixing the stack overflow at line 0 error
- Unable to compile class for JSP: An error occurred at line: 192 in the jsp file: /admin/user/userMan
- 75.The following data exists in the PRODUCTS table:
- Error while commiting the transaction
- Output error file to the following location
- SMTP Error: The following recipients failed
- 180.User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the fol
- 【杭电1596】find the safest road
- 将dBm转换为W的方法
- JMeter学习(六)集合点
- android 3D效果的饼状图实现销售漏斗
- IntelliJ IDEA让你脱键盘,全键盘操作
- 150.The user HR receives the following error while inserting data into the TTK table: ERROR at line
- Java远程调试
- tensorflow的基本用法
- 151.View the Exhibit1, which shows the options that are selected to create the user SL_REP.
- 为什么说跨页复选不可行
- awk命令实现求和、求平均值、求最大值、求最小值
- 【40】数组中只出现一次的数字
- javaweb --form表单提交显示bad request
- 机器学习(周志华) 参考答案 第六章 支持向量机 6.9