Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:ALTER DATABASE MOUNT;Which two actions are performed? (Choose two.) A. The online redo logs are opened B. The online data files are opened C. The alert log records the execution details D. The Oracle background processes are started E. The initialization… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:ALTER DATABASE MOUNT;Which two actions are performed? (Choose two.) A. The online redo logs are opened B. The online data files are opened C. The alert log records the execution details D. The Oracle background processes are started E. The initialization… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
The “Activity has not been started X minutes after ETA” display warning is set to 10 minutes. An activity’s ETA is 9:00, the current time is 9:20 and the activity has not yet been started. Which warning will take place as a result of that configuration setting? A. The activity turns red and a Resource Tree warning appears.… Read More »
Refer to the exhibit. An engineer has started to configure a router for OSPF, as shown Which configuration must an engineer apply on the network so that area 15 traffic from R5 to R1 will prefer the route through R4? A. Place the link between R3 and R5 in a stub area to force traffic to use the… Read More »