admin 管理员组文章数量: 1087139
2024年3月19日发(作者：家属辟谣因隔离自杀)
更多考题请点击这里
OCM考试真题
1. 创建数据库
a) Create a database，the sid name is PROD
b) Don’t run the script and
2. 配置数据库
a) Database setup and unod management
i. Run the minimum required scripts to complete the basic configuration of the PROD
database
ii. Set up automatic undo management in the PROD database to support the following
requirements:
1. avoid ORA-01555 snapshot too old errors for queries running up to 90 minues
on average
2. the number or concurrent OLTP users will be approximately 120 during
normal business hours.
3. the number or concurrent tatch processes that will run in the evenings and
weekends will approximately 12 to 15;
b) server-side network configuration
i. create a listener using the default listener name
1. the TCP/IP protocol will be used for all the machine
name(not the IP address) for host.
2. this listener will listener on the default port
3. databases:PROD and EMREP(created later) will be serviced by this listener.
ii. add a second listener, named LSNR2, which will listener on prot 1526. Configure
this listener to support only automatic instance registrations.
1. set up the PROD instance to automatically register with the LSNR2.
iii. start both listeners.
c) shared server configuration
i. configure the PROD database to support up to 300 sessions , reserving 100 for
dedicated connections
ii. configure the PROD database to support
1. default of 3 TCP dispatchers
2. maximum of 10 dispatchers
iii. configure the PROD database to support:
1. minimum of 10 shared server processes
2. maximum of 30 shared server processed
d) Client-side network configuration
i. create the client-side network configuration files providing connect descriptors to
your database using local naming and easy connect methods
1. the prod alias should connect to the PROD instance using the default listener
and always use a dedicated server connection
2. the prod_s alias should connect to PROD instance using LSNR2 and use a
shared server connection
ii. the racdb alias should connect to the RACDB service (create later) with a dedicated
server connectionthe
1. theRACDB service will be running on your RAC cluster
iii. the emrep alias should connect to the EMREP instance (create later) with a
dedicated server connection
e) tablespace creation and configuration note:tablespace must be named as specified in
each task to receive credit.
i. create a temporary tablespace group that contains two(2) temporary tablespace to
support batch processing, the creation of large indexes, and analyzing tables, use
the following specifications:
1. temporary tablespace group named TEMP_GRP containing temporary
tablespaces TEMP1 and TEMP2
2. make TEMP_GRP the default temporary tablespace for all new users;
ii. create a permanent tablespace to store sample test the following
specifications:
1. tablespace name of EXAMPLE
2. initial datafile size of 400MB with the file expectd to grow to 4TB
3. initial extent size of 1MB
4. next extent size of 1MB
iii. create a permanent tablespace to store indexes,use the following specifications:
1. tablespace name of indx
2. file size of 40MB
iv. create a permanent tablespace to store data collected from various Oracle tools. Use
the following specifications:
1. tablespace name of TOOLS
2. file size of 10MB
v. create a default permanent tablespace using the following specifications:
1. tablespace name of users
2. file size of 48MB
3. initial extent size of 4MB
4. next extent size of 4MB
vi. create a permanent tablespace for storing segments associated with online
transaction processing with high insert to the potential high volume of
concurrent inserts, every effort should be taken to reduce contention for each of the
tables that will be stored in this the following specifications:
1. tablespace name of OLTP
2. file size of 48MB
3. initial extent size of 2MB
4. next extent size of 2MB
vii. log file management
1. Due to the expected high volume of database should have the
following configuration:
a) A minimum of 5 redo log groups
版权声明：本文标题：2012年7月oracle 10g ocm 认证考试真题题库 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1710827433a575105.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论