READ Free Dumps For Oracle- 1z0-023
| Question ID 8811 | Under which condition is it possible to connect to an Oracle database without providing a password?
|
| Option A | The connecting user has the BYPASS system privilege.
|
| Option B | The connecting users username is not found in the data dictionary.
|
| Option C | The connecting user has been entered in the password file of the database.
|
| Option D | The connecting user is a member of a DBA group on the machine where the database is running.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. You can connect to an Oracle database without providing a password if you are connected as a ember of a DBA group on the machine where the database is running. The REMOTE_LOGIN_PASSWORDFILE is need to be set in NONE in initSID.ora file to allow you use OS authentication type of connection. Incorrect Answers: A: There is no BYPASS system privilege in Oracle. B: If there is no username in the data dictionary user will not connect to the database. C: Entering user in the password file of the database does not allow him/her to connect without password to the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 277-279 Chapter 6: Basics of the Oracle Database Architecture
| Question ID 8812 | Which view displays the NLS initialization parameters that have been explicitly set?
|
| Option A | NLS_SESSION_PARAMETERS
|
| Option B | NLS_INSTANCE_PARAMETERS
|
| Option C | NLS_DATABASE_PARAMETERS
|
| Option D | V$NLS_INSTANCE_PARAMETERS
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. NLS_INSTANCE_PARAMETERS shows all NLS instance-wide parameters. Incorrect Answers: A: NLS_SESSION_PARAMETERS displays all NLS parameters for the active session. C: NLS_INSTANCE_PARAMETERS shows all NLS database-wide parameters. D: There is no V$NLS_INSTANCE_PARAMETERS view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 547 Chapter 11: Data Loads and National Language Support