Multiple choice technology databases

Which of the following SQL statements results in a disconnection after a session is idle for 30 minutes?

  1. alter session set idle_timeout=30;

  2. alter session set idle_timeout=1800;

  3. alter profile limit idle_time 30;

  4. alter profile set idle_timout 30;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To disconnect idle sessions, use ALTER PROFILE with IDLE_TIME parameter (measured in minutes). Options A and B use non-existent IDLE_TIMEOUT parameter. Option D incorrectly uses SET instead of LIMIT and has typo (IDLE_TIMOUT). Option C correctly uses ALTER PROFILE LIMIT IDLE_TIME 30.

Keep practicing — related questions