Which of the following description about best practices of the Oracle database is correct? (Multiple choice)
A . OLAP business query output result is usually a statistical value (using the group by and order by to get), so can set up a large sga_targe value (in terms of relative OLTP).
B . In the Linux environment to configure the Oracle database, it is recommended to use UDEV strategy to bind UUID and drive, in order to avoid subsequent maintenance process changes resulting database cannot be started.
C . under database OLTP business, if the logs write very frequently, it is recommended that the online log file appropriately adjust large, but it is recommended not to exceed 128M
E . Under the enviroment of Windows2008 or Windows2012 system, in order to improve I/O efficiency, when create an MBR partition, it is recommended to use diskpart command, set the partition alignment.
Answer: ABC
Leave a Reply