网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
（）是一组Oracle进程和SGA。
- A、实例
- B、数据库
- C、表空间
- D、实体化视图
参考答案
更多 “（）是一组Oracle进程和SGA。A、实例B、数据库C、表空间D、实体化视图” 相关考题
考题
Oracle中启动数据库时，分配SGA并启动后台进程，装配数据库，但不打开数据库的命令为：A.startupB.startup openC.startup nomountD.startup mount
考题
下列关于Oracle体系结构的叙述中，哪一条是不正确的?( )A) Oracle服务器包括Oracle数据库和Oracle实例B) Oracle数据库包括日志文件和控制文件C) Oracle实例包括系统进程和所有用户进程D) Oracle数据库的表空间是物理存储单元A．B．C．D．
考题
Oracle Instance由哪两个部分组成?()
A. Shared pool和Server processB. Shared pool和Background processC. SGA和user processD. PGA和user processE. SGA和Background process
考题
Oracle Server由哪两个部分组成?()
A. INSTANCE和DATABASEB. SGA和PGAC. SGA和DATABASED. Server process和Background processE. SGA和Background process
考题
()是有自己的系统全局区和与其相关数据库文件的Oracle服务器进程集,都要用称为SID(SystemIdentifier,系统标识符)的标识符来标识。
A.Oracle数据库B.Oracle进程C.Oracle实例D.Oracle服务
考题
Oracle数据库服务器是由（）组成。（oracle数据库用于存储和检索信息，是数据的集合，包括逻辑结构和物理结构。Oracle例程是指数据库服务器的内存和相关处理程序）A、SGA和PGAB、SGA和数据库C、数据库和后台进程D、例程和数据库
考题
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
Oracle中启动数据库时，分配SGA并启动后台进程，装配数据库，但不打开数据库的命令为:A、startupB、startup openC、startup nomountD、startup mount
考题
Oracle中启动数据库时，分配SGA并启动后台进程，装配数据库，但不打开数据库的命令为:A、startupB、startupopenC、startupnomountD、startupmount
考题
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A、PMONB、SMONC、CKPTD、LGWRE、ARCn
考题
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A、Shared pool B、Control file C、SGA D、PGA
考题
For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
（）是有自己的系统全局区和与其相关数据库文件的Oracle服务器进程集，都要用称为SID（SystemIdentifier，系统标识符）的标识符来标识。A、Oracle数据库B、Oracle进程C、Oracle实例D、Oracle服务
考题
Oracle Instance由哪两个部分组成？（）A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process
考题
单选题Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A
PMONB
SMONC
CKPTD
LGWRE
ARCn
考题
单选题SGA是一块巨大的共享内存区域，被看成是Oracle数据库的一个大缓冲池，如果需要查看SGA的大小信息，可以使用如下（）语句。A
SELECT SGA FROM V$DBAB
SELECT * FROM V$DBAC
SELECT * FROM V$SGAD
SELECT size FROM V%DBA
考题
单选题You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?（）A
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC
The database instance starts, but Automatic Memory Management is disabledD
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
单选题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
热门标签
最新试卷
