You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this?()
Arun a procedure to check the tablespace space usage
Bdefine the warning threshold for the tablespace at 75% in Database Control
Ccreate a trigger to be executed when tablespace space usage reaches 75%
Dsubmit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
Edefine the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
正确答案
答案解析
相似试题
(单选题)
You want to perform a backup of your database to tape. Which backup format can you use?()
(多选题)
You want to create a WebLogic domain in a production environment. Which three actions should you perform?()
(单选题)
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task?()
(单选题)
You want the size of the tablespace to increase when it is full. Which option would you use?()
(单选题)
You want to check the EMP table in the user, Scott’s schema for block corruption. You also want to fix the corrupted blocks, if any. How will you accomplish the required task?()
(单选题)
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()
(单选题)
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
(单选题)
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? ()
(单选题)
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
(单选题)
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()