Hub for All Education Needs
You configured the fast recovery area for one of your databases but it is now running out of space.Which two could make space available in the flash recovery area? (Choose two.)Reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint009.htm Question: Which two could make space available in the flash recovery area? Options: Use OS commands to remove files from the fast recovery … Read more
The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) … Read more
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace onlyfor these user sessions and you do not want these … Read more
Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)The Scheduler objects include:ProgramsSchedulesJobsDestinationsChainsFile WatchersCredentialsJob ClassesWindowsGroups Question: Which three components does the Scheduler use for managing tasks within the Oracle environment? Options: a job a program a schedule a PL/SQL procedure Correct Answer The Correct Answer for this Question is … Read more
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command? Question: Sales details are being stored on … Read more
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os.Which statement describes a solution to the above? Question: Which statement describes a solution to the above? Options: Set a threshold for the default system-defined moving window baseline. … Read more
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task? Question: How would you accomplish this task? Options: Set metric threshold Implement Database Resource Manager Enable resumable … Read more
Which statement is true about a Scheduler-generated event?Consuming Job State Events with your ApplicationTo consume job state events, your application must subscribe to the Scheduler event queueSYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following:1.Log in to the database … Read more
Which of the following describes how a distributed resumable transaction behaves? Question: Which of the following describes how a distributed resumable transaction behaves? Options: The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed … Read more
In which cases is reference partitioning effective in enhancing performance? Question: Which cases is reference partitioning effective in enhancing performance? Options: It is effective only in partition pruning. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key. It is effective in both partition pruning as well … Read more