7 、Which three statements are true about initialization parameters and files?
A) Session modifiable initialization parameters can only be changed by a user with the DBA role.
B) An idle instance must start with a pfile .
The ALTER SYSTEM command can be used to change parameter values for an instance started using a PFILE.
An SPFILE can be created from an idle instance.
System modifiable initialization parameters can only be changed by the SYS user.
The ALTER SYSTEM command can be used to change parameter values for an instance started using an SPFILE.
G) Session modifiable initialization parameters can only be changed once per session.
Answer: CDF
--====================== SQL> show user USER 为 "XYS" SQL> alter system set processes=200 scope=spfile; 系统已更改。 SQL> show user USER 为 "XYS" 下面操作是用SYS开了另外一个session： SQL> show parameter pga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 90M SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> alter system set pga_aggregate_target=100m; 系统已更改。 SQL> shutdown immediate 数据库已经关闭。 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> create spfile from pfile; 文件已创建。 SQL>
