Oracle Architectural Components_练习.docVIP

Oracle Application Server 应用服务器 .net(IIS) Java(tomcat,oracle Application Server,glassfish(sun) ,IBM websphere,bea weblogical ) html(apache) Oracle Applications CRM ERP HR 查看SGA的配置参数： Show sga; (推荐)Show parameter sga_max_size; 一个instance只能对应一个数据库（orcl） 但是在集群的环境下一个数据库可能有多个instance为之服务。 1 Which one of the following statements is true? a An Oracle server is a collection of data consisting of three file types. b A user establishes a connection with the database by starting an Oracle instance. c A connection is a communication pathway between the Oracle Server and the Oracle Instance. d A session starts when a user is validated by the Oracle server. 2 Which one of the following memory areas is not part of the SGA? a Database buffer cache b PGA c Redo log buffer cache d Shared Pool 3 Which two of the following statements are true about the Shared Pool? a The shared Pool consists of the Library Cache, Data Dictionary Cache, Shared SQL area, Java Pool, and Large Pool. b The Shared Pool is used to store the most recently executed SQL statements and the most recently used data. c The Shared Pool is used for object that can be shared globally. d The Library Cache consist of the Shared SQL and Shared PL/SQL areas. 4 Which one of the following memory areas is used to cache the data dictionary information? a Database Buffer Cache b PGA c Redo log buffer cache d Shared Pool 5 The primary purpose of the Redo Log Buffer Cache is to record all changes to the database data blocks. a True b False Answer: True 6 The PGA is a memory region that contains data and control information for multiple server processes or multiple background processes. a True b False 7 Which one of the following processes is available when an Oracle instance is started. a User process b Background process c Server process d System process 8 Identify the six mandatory background processes. _DBWn_______________________________________ __CKPT______________________________________ ___LGWR______________________