没有合适的资源?快使用搜索试试~ 我知道了~
首页快速获取Oracle 1Z0-031认证:实践指南
快速获取Oracle 1Z0-031认证:实践指南
需积分: 1 0 下载量 51 浏览量
更新于2024-07-18
收藏 1012KB PDF 举报
Oracle 1Z0-031考试是Oracle9i数据库基础知识的重要认证考试,旨在帮助考生深入理解和掌握核心概念,而不仅仅是记忆特定题目。Correctexams.com提供了一套精心编写的《快速获得Oracle9i DBA Fundamentals认证实战练习题指南》,该版本为1-2003版,于2003年1月4日进行了最后的验证和更新。 该学习指南的独特之处在于其注重理论教育,鼓励通过反复阅读提高对知识的理解,而非单纯依赖死记硬背。这意味着它不仅包含了考试所需的基本概念,还可能包含最新的实践问题和案例分析,帮助考生在真实考试环境中检验自己的准备程度。每份PDF文件均采用加密技术,每个文件与用户的Correctexams账户信息关联,确保了内容的安全性和唯一性。 正确使用此学习资料的方法是在考试前检查是否有最新版本,因为Correctexams会不断更新题库,以适应考试内容的变化。此外,版权法律要求用户在使用过程中尊重版权,不得将PDF文件分享给他人,否则可能会引发法律纠纷。作者欢迎用户给出反馈,无论是正面评价还是建设性的批评,都对改进未来版本的学习材料大有裨益。 参加Oracle 1Z0-031考试的考生应该充分利用这份学习资源,通过实际操作和理解深入掌握Oracle数据库管理的基础知识,以便在认证考试中表现出色。在备考过程中,持续学习、实践和反思都是关键步骤,这将有助于巩固所学,提升应对复杂问题的能力。
资源详情
资源推荐
![](https://csdnimg.cn/release/download_crawler_static/10510608/bg10.jpg)
- 16 -
2) Parameters on the client side to specify locale-dependent behavior overriding the
defaults set for the server
3) Parameters override the default set for the session or the server
C. 1) Parameters on the server side to specify the default server environment
2) Parameters override the default set for the session or the server
3) Parameters on the client side to specify locale-dependent behavior overriding the
defaults set for the server
D. 1) Parameters on the client side to specify locale-dependent behavior overriding the
defaults set for the server
2) Parameters override the default set for the session or the server
3) Parameters on the server side to specify the default server environment
Answer: B
Initialization parameters on the server side specify the default server environment. Environment
parameters on the client side are used to set locale-dependent behavior overriding the defaults set
for the server. Also it is possible to override the default set for the session or the server by using
ALTER SESSION command.
Incorrect Answers
A: There are no initialization parameters on the client to specify locale-dependent behavior
overriding the defaults set for the server. You can do that only with environment variables.
C: Environment variables cannot override the default set for the session or the server.
D: Environment variables cannot override the default set for the session or the server.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 980-985
Appendix A: Globalization Support
QUESTION NO: 15
More stringent user access requirements have been issued. You need to do these tasks for
the user pward:
1. Change user authentication to external authentication.
2. Revoke the user's ability to create objects in the TEST TS tablespace.
3. Add a new default and temporary tablespace and set a quota of unlimited.
4. Assign the user to the CLERK profile.
Which statement meets the requirements?
A. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
www.correctexams.com
Fast Way to get your Certification
![](https://csdnimg.cn/release/download_crawler_static/10510608/bg11.jpg)
- 17 -
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
GRANT clerk TO pward;
B. ALTER USER pward
IDENTIFIED by pward
DEFAULT TABLESPACE dsta_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
PROFILE clerk;
C. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
PROFILE clerk;
D. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test ts;
GRANT clerk to pward;
Answer: C
Only statement in this answer meets all requirements of the question.
Incorrect Answers
A: This statement misses PROFILE clause to assign the user to the CLERK profile. Also
command GRANT cannot be used as part of ALTER USER command.
B: This statement misses IDENTIFIED EXTERNALLY clause to change user authentication to
external authentication.
D: This statement misses PROFILE clause to assign the user to the CLERK profile. You cannot
set profile to the user with GRANT command. It used to set role for user.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 810-817
Chapter 15: Managing Database Users
QUESTION NO: 16
www.correctexams.com
Fast Way to get your Certification
![](https://csdnimg.cn/release/download_crawler_static/10510608/bg12.jpg)
- 18 -
A new user, psmith, has just joined the organization. You need to create psmith as a valid
user in the database. You have the following requirements:
1. Create a user who is authenticated externally.
2. Make sure the user has CONNECT and RESOURCE privileges.
3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges.
4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary
tablespace.
5. Assign the user to the DATA_TS default tablespace and the TEMP_TS temporary
tablespace.
Which statement would you use to create the user?
A. CREATE USER psmith
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 100M ON data_ts
QUOTA 500K ON temp_ts
TEMPORARY TABLESPACE temp_ts;
REVOKE DROP TABLE, CREATE USER from psmith;
B. CREATE USER psmith
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 500K ON temp_ts
QUOTA 100M ON data_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect, resource TO psmith;
C. CREATE USER psmith
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 100M ON data_ts
QUOTA 500K ON temp_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect TO psmith;
D. CREATE USER psmith
INDENTIFIED GLOBALLY AS ‘’
DEFAULT TABLESPACE data_ts
QUOTA 500K ON temp_ts
QUOTA 100M ON data_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect, resource TO psmith;
REVOKE DROP TABLE, CREATE USER from psmith;
www.correctexams.com
Fast Way to get your Certification
![](https://csdnimg.cn/release/download_crawler_static/10510608/bg13.jpg)
- 19 -
Answer: B
Only statement in this answer meets all requirements of the question.
Incorrect Answers
A: This statement does not give user CONNECT and RESOURCE privileges.
C: This statement does not give user RESOURCE privilege.
D: This statement does not define user externally.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 804-810
Chapter 15: Managing Database Users
QUESTION NO: 17
You issue these queries to obtain information about the REGIONS table:
SQL> SELECT segment_name, tablespace_name
2> FROM user_segments
3> WHERE segment_name = 'REGIONS';
SEGMENT_NAME TABLESPACE_NAME
--------------- -------------------
REGIONS SAMPLE
SQL> SELECT constraint_name, constraint_type
2> FROM user constraints
3> WHERE table_name = ‘REGIONS’;
CONSTRAINT_NAME C
----------------------------- -
REGION_ID_NN C
REG_ID P
SQL> SELECT index_named
2> FROM user indexes
3> WHERE table_name = ‘REGIONS’;
INDEX_NAME
----------------------------
REG_ID_PK
You then issue this command to move the REGIONS table:
www.correctexams.com
Fast Way to get your Certification
![](https://csdnimg.cn/release/download_crawler_static/10510608/bg14.jpg)
- 20 -
ALTER TABLE regions
MOVE TABLESPACE user_data;
What else must you do to complete the move of the REGIONS table?
A. You must rebuild the REG_ID_PK index.
B. You must re-create the REGION_ID_NN and REG_ID_PK constraints.
C. You must drop the REGIONS table that is in the SAMPLE tablespace.
D. You must grant all privileges that were on the REGIONS table in the SAMPLE
tablespace to the REGIONS table in the USER_DATA tablespace.
Answer: A
To complete the move of the REGIONS table you must rebuild the REG_ID_PK index. Oracle
preserves the table’s associated constraints, object privileges, and triggers when the table is
moved from the one tablespace to another, but the ALTER TABLE table_name MOVE
TABLESPACE tablespace_name command does not move any index associated with the table.
Incorrect Answers
B: You don’t need to recreate constraints: Oracle will take care about them.
C: The main reason to use the ALTER TABLE table_name MOVE TABLESPACE
tablespace_name command is possibility NOT to drop table to re-create it later in the another
tablespace.
D: You don’t need to grant all privileges on the REGIONS table in this case, because we did not
drop a table.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 744-747
Chapter 14: Managing Database Objects
QUESTION NO: 18
You need to create an index on the CUSTOMER_ID column of the CUSTOMERS table.
The index has these requirements:
1. The index will be called CUST_PK.
2. The index should be sorted in ascending order.
3. The index should be created in the INDEX01 tablespace, which is a dictionary
4. All extents of the index should be 1 MB in size.
5. The index should be unique.
6. No redo information should be generated when the index is created.
7. 20% of each data block should be left free for future index entries.
www.correctexams.com
Fast Way to get your Certification
剩余115页未读,继续阅读
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://profile-avatar.csdnimg.cn/default.jpg!1)
zd1207
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![](https://csdnimg.cn/release/wenkucmsfe/public/img/voice.245cc511.png)
最新资源
- Hadoop生态系统与MapReduce详解
- MDS系列三相整流桥模块技术规格与特性
- MFC编程:指针与句柄获取全面解析
- LM06:多模4G高速数据模块,支持GSM至TD-LTE
- 使用Gradle与Nexus构建私有仓库
- JAVA编程规范指南:命名规则与文件样式
- EMC VNX5500 存储系统日常维护指南
- 大数据驱动的互联网用户体验深度管理策略
- 改进型Booth算法:32位浮点阵列乘法器的高速设计与算法比较
- H3CNE网络认证重点知识整理
- Linux环境下MongoDB的详细安装教程
- 压缩文法的等价变换与多余规则删除
- BRMS入门指南:JBOSS安装与基础操作详解
- Win7环境下Android开发环境配置全攻略
- SHT10 C语言程序与LCD1602显示实例及精度校准
- 反垃圾邮件技术:现状与前景
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![](https://img-home.csdnimg.cn/images/20220527035711.png)
![](https://img-home.csdnimg.cn/images/20220527035711.png)
![](https://img-home.csdnimg.cn/images/20220527035111.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![](https://csdnimg.cn/release/wenkucmsfe/public/img/green-success.6a4acb44.png)