Which of the following will occur if %temp% is executed from the run command?()
You executed the following commands in a database session: What could have caused the recycle bin to clean up?()
Given: Under which three circumstances will the code on line 37 be executed?()
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?()
You executed the following command in Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME => ’JOB_A’, ATTRIBUTE => ’JOB_PRIORITY’, VALUE => 7); END; / After analyzing the above code, what conclusion will you draw?()
Under which three circumstances will the code on line 37 be executed?()
You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20) BEGIN dbms_addm.insert_finding_directive (NULL, DIR_NAME=>’Detail CPU Usage’, FINDING_NAME=>’CPU Usage’, MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90); :tname := ’database ADDM task4’; dbms_addm.analyze_db(:tname, 150, 162); END; / Then you executed the following command: SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL; The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()