131、
131.You execute a command to resize a data file, sales.dbf, of size 200 MB in your database: ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M; Which statement is true about this command? A. The command must be issued in MOUNT state. B. The command succeeds only if the data file is offline. C. The command must be issued when the database is in the archivelog mode. D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
Answer: D
132、
132.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAMETER BACKGROUND_DUMP_DEST NAME TYPE VALUE -------------------- -------- ------------------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/orcl/orcl/trace SQL> SHOW PARAMETER DIAGNOSTIC_DEST NAME TYPE VALUE ---------------- ----------- ---------------- diagnostic_dest string /u01/app/oracle Where is the alert log file stored? (Choose all that apply.) A. in the BACKGROUND_DUMP_DEST location; in text format B. in the BACKGROUND_DUMP_DEST location; in XML format C. in the BACKGROUND_DUMP_DEST location; in both text and XML format D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
Answer: AE
133、
133.You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile. This command is used to drop the profile: SQL> DROP PROFILE app_user; Which statement describes the result? A. The command produces an error. B. The profile is dropped and current user sessions use the DEFAULT profile immediately. C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile. D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.
Answer: A
134、View the Exhibits and examine lock waits.
Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response. Which action would you take to release the lock and enable users HR and SH to continue with their transactions? A. Kill the session of the user SCOTT with session ID118. B. Issue manual checkpoint using the ALTER SYSTEM command. C. Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit. D. Flush the Shared Pool to remove the SQL statement causing "wait" in memory.
Answer: A
135、
135.Note the functionalities of various background processes: 1: Perform recovery at instance startup. 2: Free the resources used by a user process when it fails. 3: Cleanup the database buffer cache when a process fails. 4: Dynamically register database services with listeners. 5: Monitor sessions for idle session timeout. 6: Cleanup unused temporary segments. 7: Record the checkpoint information in control file. Which option has the correct functionalities listed for a background process? A. Checkpoint (CKPT): 1, 2, 5 B. System Monitor (SMON): 1, 6 C. Process Monitor (PMON): 4, 6, 7 D. Database Writer (DBWR): 1, 3, 4
Answer: B 实例启动时如有需要，系统监控进程（system monitor process，SMON）将负责进行恢复（recovery）工作。此外，SMON 还负责清除系统中不再使用的临时段（temporary segment），以及为数据字典管理的表空间（dictionary managed tablespace）合并相邻的可用数据扩展（extent）。