052-228(新增70题2018)

You decided to increase the value for the SHARED_SERVERS parameter by using the following command:
SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;
Which three values can be specified for the SCOPE clause? (Choose three.)
A. ALL
B. PFILE
C. BOTH
D. NONE
E. SPFILE
F. MEMORY
G. INSTANCE
H. DATABASE
Answer: CEF

SQL> select  issys_modifiable from v$parameter where NAME='shared_servers';
ISSYS_MODIFIABLE
----------------
IMMEDIATE
--可以在内存里修改

SHARED_SERVERS

Modifiable　　ALTER SYSTEM
If you are using shared server architecture or if the DISPATCHERSparameter is set such that the total number of dispatchers is more than 0, then the default value is 1.默认值是0或者1
0, meaning that shared server is not on.

SCOPE=SPFILE：

• Changing Initialization Parameter Values