5、Which three are true about requirements for various FLASHBACK operations? (Choose three.)B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.F. FLASHBACK version quer...【阅读全文】
3、While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.Which two could improve read performance? (Choose two.)B. Disable FORCE LOGGING for the database.D. Enable asynchronous disk I/...【阅读全文】
2、Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?B) when free space in a locally managed tablespace falls below a specified percentageD) when the number of logons per second exceeds a specific valueF) when the to...【阅读全文】
1.Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.D. They are generated by SMON when a tablespace is 97% full.F. STATISTICS_LEVEL must be set to ALL to generate alerts....【阅读全文】
You have been tasked to create a table for a banking application.Be stored in a format supporting date arithmetic without using conversion functionsBe used for calculating interest for the number of days the loan remains unpaidA. INTERVAL YEAR TO MONTHC. TIMESTAMP WITH LOCAL TIMEZO...【阅读全文】
SELECT loginname,endtime FROM dailysessionpre_table where days='2020-11-16' and length(ACCTSESSIONTIME) > 30 and endtimebetween to_date('15/11/2020 23:45:00', 'dd/MM/yyyy hh24:mi:ss') and to_date...【阅读全文】