black

1Z0-052

登录

单项选择题

Note the following functionalities of various background processes: 
1:Record the checkpoint information in data file headers. CKPT 
2:Perform recovery at instance startup. SMON 
3:Cleanup unused temporary segments. SMON 
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

相关考题

多项选择题 WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLArea()

单项选择题 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()

单项选择题 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()

All Rights Reserved 版权所有©易学考试网(yxkao.com)

备案号:湘ICP备2022003000号-3