程序全局区（PGA）由哪几个部分组成？各部分存放信息的类型是什么？ -题库考试答案搜索网

程序全局区（PGA）由哪几个部分组成？各部分存放信息的类型是什么？

问答题

2022-03-31 22:54

查看答案

正确答案

程序全局区可以分为四个部分：排序区、会话区、游标区和堆栈区。
1、排序区：用于存放排序操作所产生的临时数据。
2、会话区：保存会话所具有的权限、角色、性能统计信息。
3、游标区：由于存放游标的相关信息。
4、堆栈区：存放会话中的绑定变量、会话变量以及SQL语句运行时的内存结构等信息。

试题解析

标签： CMS专题 Oracle认证考试 Oracle认证综合练习

感兴趣题目

程序全局区（PGA）由哪几个部分组成？各部分存放信息的类型是什么？

一个Oracle Server包含一个Oracle Instance和一个Oracle Database。

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

Vessels must be（）valid certificate of nationality or certificated of registry or license.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

Oracle体系结构通常由（）组成。

下面（）不是oracle程序设计中的循环语句。

在oracle程序中处理语句时发生的逻辑错误导致（）故障。

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

相关题目: boost的意思是:help or encourage to increase or improve; eloquent的意思是:fluent or persuasive in speaking or writing; A campus emergency ______ occur at any time of the day or night, weekend, or holiday, with little or no warning.; 国家对目录产品实行强制性认证，统一认证标准、技术规则和实施程序，统一认证标志、收费标准。认证标志的名称为（　　）。; our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）; Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）; You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?（）; （）any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local quarantine officer must be notified immediately．; Should any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local Quarantine Officer must be（）immediately.; Oracle提供了多种身份认证方式，包括（）。; Masters are（）solely responsible for all damages or accidents of whatever kind resulting from the navigating or handling of their vessels by day or by night.; 在Oracle中，用于显示PL/SQL程序输出调试信息的内置程序包是（）。; 系统中雷达状态包括Unknown、Operational（or ON）、Failed（or OFF）、Detached。; The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.; 以下ORACLE认证的级别由低到高排列正确的是（）; 执行下列程序段后 MOV AL，87 MOV CL， 4 MOV AH， AL AND AL，0FH OR AL， 30H SHR AH，CL OR AH，30H 则AX=( )H; Shutdown price（or point，or rule）停业价格（或停业点、停业原则）; Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）; Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressed mode foran installation？（）; 翻译：With Average or With Particular Average（WA or WPA）（）

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧