單項(xiàng)選擇題

Note the following functionalities of various background processes：
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process（）

A.Archiver Process （ARCn）： 1， 2， 5
B.System Monitor Process （SMON）： 1， 4， 5
C.Process Monitor Process （PMON）： 4， 5， 6
D.Database Writer Process （DBWn）： 1， 3， 4

你可能感興趣的試題

單項(xiàng)選擇題

You are using Enterprise Manager to schedule backups for your database.
Which type of script would begenerated by the backup scheduler（）

A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D.Recovery Manager （RMAN） script

單項(xiàng)選擇題

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）

A.Optimizer statistics are collected automatically.
B.Only timed operating system （OS） statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler（）

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are using Enterprise Manager to schedule backups for your database.
Which type of script would begenerated by the backup scheduler（）

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）