网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）
A
Allocates memory for RMAN backup and restore operations
B
Allocates memory for shared and private SQL areas
C
Contains a cursor area for storing runtime information about cursors
D
Contains stack space
E
Contains a hash area performing hash joins of tables
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables” 相关考题
考题
Which three statements are true about persistent configuration?() (Choose three.)
A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a large amount of metadataC. It is possible to create fully self-contained persistent lightweight jobsD. The use of a template is mandatory to create persistent lightweight jobsE. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
Which three statements are true about Oracle Data Pump export and import operations?()
A. You can detach from a data pump export job and reattach later.B. Data pump uses parallel execution server processes to implement parallel import.C. Data pump import requires the import file to be in a directory owned by the oracle owner.D. The master table is the last object to be exported by the data pump.E. You can detach from a data pump import job and reattach later.
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
考题
Which statement is true about a worm attack？（）A、Human interaction is required to facilitate the spread.B、The worm executes arbitrary code and installs copies of itself in the memory of the infected computer.C、Extremely large volumes of requests are sent over a network or over the Internet.D、Data or commands are injected into an existing stream of data. That stream is passed between a client and server application.
考题
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
考题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
考题
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
考题
Which two statements are true about Oracle ActiveCache ？（）A、 it supports very large data-sets such as the result-sets from large search queries to be held in memoryB、 it provides a set of management tools that enables automation of configurationC、 it provides enhanced visibility across the entire application infrastructureD、 it significantly increases the performance of Web-based applications with no code change
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
考题
Which three statements are true about Oracle Data Pump export and import operations?（）A、You can detach from a data pump export job and reattach later.B、Data pump uses parallel execution server processes to implement parallel import.C、Data pump import requires the import file to be in a directory owned by the oracle owner.D、The master table is the last object to be exported by the data pump.E、You can detach from a data pump import job and reattach later.
考题
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
Which three statements are true about the privileged connection options available in Oracle9i？（）A、The CONNECT INTERNAL is disallowed. B、The Server Manager tool is no longer supplied. C、The listener must be running to make a connection. D、The use of remote password login file (orapwsid) is unchanged.
考题
Which two statements about the background process of the database writer are true（）A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
考题
Which three statements are true about persistent configuration？（） A、 A user cannot set privileges on the persistent lightweight jobsB、 Persistent lightweight jobs generate a large amount of metadataC、 It is possible to create fully self-contained persistent lightweight jobsD、 The use of a template is mandatory to create persistent lightweight jobsE、 Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
Which two statements about the background process of thedatabase writerare true（） A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
考题
Which three statements are true regarding the logical structure of the Oracle database？（）A、Each segment contains one or more extents.B、Multiple tablespaces can share single data file.C、A data block is the smallest unit of I/O for data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one OS block.
考题
多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block.
考题
多选题Which three statements are true about persistent configuration?（） (Choose three.)AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
多选题Which three characteristics are true about voice traffic in the campus network？ （）ATCP retransmitsBbenignCgreedyDdrop sensitiveEsmoothFdelay insensitive
考题
多选题Which two statements are true about Shared SQL Area and Private SQL Areas（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DThe whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.EShared SQL Area and Private SQL Area will be allocated in the PGA or large pool.FThe number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
考题
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
多选题Which statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data fileCA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block
考题
多选题Which three statements are true about Oracle Data Pump export and import operations?（）AYou can detach from a data pump export job and reattach later.BData pump uses parallel execution server processes to implement parallel import.CData pump import requires the import file to be in a directory owned by the oracle owner.DThe master table is the last object to be exported by the data pump.EYou can detach from a data pump import job and reattach later.
考题
多选题Which two statements are true about Oracle ActiveCache ？（）Ait supports very large data-sets such as the result-sets from large search queries to be held in memoryBit provides a set of management tools that enables automation of configurationCit provides enhanced visibility across the entire application infrastructureDit significantly increases the performance of Web-based applications with no code change
考题
多选题Which two statements are true about Shared SQL Area and Private SQL Area（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DPrivate SQL Area will be allocated in the Program Global Area （PGA） always.EShared SQL Area and Private SQL Area will be allocated in the PGA or large pool.FThe number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
考题
多选题Which three statements are true regarding the logical structure of the Oracle database？（）AEach segment contains one or more extents.BMultiple tablespaces can share single data file.CA data block is the smallest unit of I/O for data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one OS block.
热门标签
最新试卷
