109.In a new installation of Oracle Database 11g, you perform these activities:
1: Organize software and data on different subdirectories to avoid poor performance.
2: Use consistent naming conventions for database files.
3: Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
答案:C
解析:
A:OMF(Oracle Managed Files)
A service that automates naming, location, creation, and deletion of database files such as control files, redo log files, data files and others,
based on a few initialization parameters. You can use Oracle managed files on top of a traditional file system supported by the host operating system,
for example, VxFS or ODM. It can simplify many aspects of the database administration by eliminating the need to devise your own policies for such details.
a.db_create_file_dest:指定数据文件位置
b.db_create_online_log_dest_n:控制文件和联机重做日志文件,最多5个
B:http://docs.oracle.com/cd/E11882_01/server.112/e40540/dist_pro.htm#CNCPT1274
C:OFA(optimal flexible architecture) 优化而弹性的体系结构,oracle推荐的
a.建立任何数据文件可以存储在任何磁盘上的目录结构
b.将不同用途的对象分别存放在不同的表空间中
c.通过将不同的数据库组件放到不同的磁盘上来最大限度地提高数据库的可靠性和改进数据库的效率
D:http://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT914
E:ASM(Automatic Storage Managemen)
自动存储管理,它是一个多路复用的方案,通过将数据文件、控制文件重做日志文件分布在多个可用的磁盘上来自动布置这些文件
1: Organize software and data on different subdirectories to avoid poor performance.
2: Use consistent naming conventions for database files.
3: Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
答案:C
解析:
A:OMF(Oracle Managed Files)
A service that automates naming, location, creation, and deletion of database files such as control files, redo log files, data files and others,
based on a few initialization parameters. You can use Oracle managed files on top of a traditional file system supported by the host operating system,
for example, VxFS or ODM. It can simplify many aspects of the database administration by eliminating the need to devise your own policies for such details.
a.db_create_file_dest:指定数据文件位置
b.db_create_online_log_dest_n:控制文件和联机重做日志文件,最多5个
B:http://docs.oracle.com/cd/E11882_01/server.112/e40540/dist_pro.htm#CNCPT1274
C:OFA(optimal flexible architecture) 优化而弹性的体系结构,oracle推荐的
a.建立任何数据文件可以存储在任何磁盘上的目录结构
b.将不同用途的对象分别存放在不同的表空间中
c.通过将不同的数据库组件放到不同的磁盘上来最大限度地提高数据库的可靠性和改进数据库的效率
D:http://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT914
E:ASM(Automatic Storage Managemen)
自动存储管理,它是一个多路复用的方案,通过将数据文件、控制文件重做日志文件分布在多个可用的磁盘上来自动布置这些文件
本文介绍在Oracle Database 11g的新安装过程中采用Optimal Flexible Architecture (OFA)进行软件和数据组织的方法。通过遵循OFA推荐的最佳实践,如使用统一的命名约定、分离不同类型的数据库文件等,可以提升数据库性能并简化管理。
9633

被折叠的 条评论
为什么被折叠?



