Oracle Sys DBA[CONNECT INTERNAL] - Quiz Explanation

[Password for Authenticating]

The answers you selected are indicated below, along with text that explains the correct answers.
 
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
  The correct answer is D.
The internal password is set when you create the password file by using the orapwd command. This is the value that you specify for the password parameter.

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
  The correct answer is C.
To connect internally, specify INTERNAL followed by the user name and service when you issue the CONNECT command.

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
  The correct answer is B.
Shutting down a database and manually archiving a log file are two routine administrative tasks that users with SYSOPER privileges are allowed to perform.

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.
  The correct answer is C.
In order to grant the SYSDBA role, you must be connected as SYSDBA or as the INTERNAL user.

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
  The correct answer is B.
To enable the SYSDBA role when you connect to a database, you must include AS SYSDBA at the end of the CONNECT command.