Topic : User Management

How to kill session of connected user;


Answer :

"SQL>alter system kill 'sid,serial#';
To get serial no and sid parameter is v$session"

Show Answer Discuss

What is Parameter for user?


Answer :

Dba_users;

Show Answer Discuss

How do sessions communicate with database?


  • Server processes use oracle net to connect to the instance
  • Background processes use oracle net to connect to the database
  • User processes read from the database and write to the instance
  • Server processes execute SQL received from user processes.

Answer :

Server processes execute SQL received from user processes.

Show Answer Discuss

When a session changes data; where does the change get written?


  • To the data block in the cache; and the redo log buffer
  • To the data block on disk; and the current online redo log file
  • The session writes to the database buffer cache; and the log writer writes to the current online redo logfile
  • Nothing is written until the change is committed

Answer :

To the data block in the cache; and the redo log buffer

Show Answer Discuss

Which two tasks occur as a database transitions from the mount stage to the open stage?


  • The online data files & Redo log files are opened.
  • Memory for the SGA is allocated.
  • The Oracle password file is opened.
  • Stored procedures are pinned in the library cache

Answer :

The online data files & Redo log files are opened.

Show Answer Discuss