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.