多項選擇題

Which two statements are true about Shared SQL Area and Private SQL Area（）

A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.Private SQL Area will be allocated in the Program Global Area （PGA） always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

你可能感興趣的試題

單項選擇題

These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction
Which of these will be stored in theShared Poolif the necessary configurations are done（）

A.1 and 2
B.2 and 5
C.1，3，and 4
D.3，4，and 5
E.1，2，3，and 4

單項選擇題

You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered.
To verify the change in size， you executed this command： SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE
------------------- ----------- ------------------
db_cache_size big integer 4194304 （4M）
Why is the value set to 4194304 and not to 2516582（）

A.because 4194304 is the granule size
B.because 4194304 is the standard block size
C.because 4194304 is the largest nonstandard block size defined in the database
D.because 4194304 is the total size of data already available in the database buffer cache

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

Which two statements are true about Shared SQL Area and Private SQL Area（）

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精