Topic : User Management

Which process is involved when a user starts a new session on the database server?


  • The Oracle login process
  • The Oracle server process
  • The system monitor (SMON) process
  • The process monitor (PMON) process

Answer :

The Oracle server process

Show Answer Discuss

Which view shows all of the objects accessible to the user in a database?


  • DB_OBJECTS
  • ALL_OBJECTS
  • DBA_OBJECTS
  • USER_OBJECTS

Answer :

ALL_OBJECTS

Show Answer Discuss

You want to retrieve information about account expiration dates from the data dictionary. Which view do you use?


  • DBA_USERS
  • DBA_PROFILES
  • DBA_EXP_DATES
  • V$ACC_EXPIRATION

Answer :

DBA_USERS

Show Answer Discuss

An Oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What is the possible solution?


  • Increase the extent size of the rollback segments.
  • Perform media recovery.
  • Increase the number of rollback segments.
  • Increase the size of the rollback segment tablespace.

Answer :

Increase the extent size of the rollback segments.

Show Answer Discuss

If a job is stopped either voluntarily or involuntarily; can I restart it?


  • No
  • Yes

Answer :

Yes

Show Answer Discuss