Password Files   «Prev  Next»

SysDBA - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. How do you specify the internal password for a database?
Please select the best answer.
  A. Place an INTERNAL_PASSWORD entry in the initialization file
  B. Issue an ALTER USER INTERNAL command
  C. Edit the password file with a text editor
  D. Place the password after the password parameter of the orapwd command

2. Which CONNECT command is valid to connect a user to the coin service as the INTERNAL user?
Please select the best answer.
  A. CONNECT INTERNAL AT coin AS SYSDBA
  B. CONNECT system/manager@coin AS INTERNAL
  C. CONNECT INTERNAL/herman@coin
  D. CONNECT TO coin AS INTERNAL

3. Which set of tasks is a user with SYSOPER privileges allowed to perform?
Please select the best answer.
  A. Create a new database and manually archive a log file
  B. Shut down a database and manually archive a log file
  C. Shut down a database and perform a time-based recovery
  D. Create a new database and perform a time-based recovery
4. In order to grant someone SYSDBA privileges, how must you be connected to the database?
Please select the best answer.
  A. You must be connected in RESTRICTED SESSION mode.
  B. You must be connected as SYSOPER.
  C. You must be connected as either SYSDBA or INTERNAL.
  D. You must be connected directly from the server console.

5. Which command will log the SYSTEM user on in the SYSDBA role?
Please select the best answer.
  A. CONNECT SYSTEM/MANAGER
  B. CONNECT SYSTEM/MANAGER AS SYSDBA
  C. CONNECT SYSTEM/SYSDBA
  D. CONNECT SYSDBA/MANAGER AS SYSTEM

Correct answers:

Your Score: 0