单项选择题
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?()
A. FREQ = MONTHLY; BYDAY = 2FRI;
B. FREQ = MONTHLY; BYDAY = FRI(2);
C. FREQ = MONTHLY; BYDAY = FRI2;
D. FREQ = MONTHLY; BYDAY = -2FRI;
相关考题
-
多项选择题
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? ()
A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE -
单项选择题
Verysoonyouwillbeperformingmaintenanceoperations.Youwouldhaveseveraljobstorunassoonasthemaintenanceperiodstarts.Whichmethodwouldyouusetocreatejobswithoutspecifyingthetimeperiodwhenthejobshouldberun?()
A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import -
单项选择题
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?()
A. The database allows only queries; no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
