READ Free Dumps For Oracle- 1z0-023
| Question ID 8871 | You are logged on to a client. You do not have a secure connection from your client to the host where your Oracle database is running. Which authentication mechanism allows you to connect to the database using the SYSDBA privilege?
|
| Option A | Control file authentication.
|
| Option B | Password file authentication.
|
| Option C | Data dictionary authentication.
|
| Option D | Operating system authentication.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Password file authentication needs to be used because there is no secure connection from client machine. Incorrect Answers: A: There is no control file authentication in Oracle. The control file is always used to mount and open database disregarding of authentication type you use. C: There is no data dictionary file authentication in Oracle. D: Do not use operating system authentication if there is no secure connection between client machine and the host where the database is running. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 345-348 Chapter 7: Managing the Physical Database Structure
| Question ID 8872 | Profiles are created to facilitate which two management items? (Choose two)
|
| Option A | Object Management
|
| Option B | Schema Management
|
| Option C | Privilege Management
|
| Option D | Resource Management
|
| Option E | Password Management
|
| Correct Answer | DE |
Explanation Explanation/Reference: Explanation: Answers D and E are correct. Resource Management and Password Management items are used to create profiles. Profiles can be used for account locking, password aging and expiration, password history, and password complexity verification. CPU time, I/O operations, idle time, connect time, memory space, and concurrent sessions can be controlled by profiles. Password changes are accomplished using the ALTER USER command. Users, who have not been assigned a profile, automatically conform to the limits assigned to the DEFAULT profile. Profiles can only be assigned to users. Incorrect Answers: A: Profiles are not used for Object Management in Oracle. B: Schema Management is used to work with user schema objects, like tables, indexes and other logical structures, but not profiles. C: Profiles are not used for Privilege Management in Oracle, privileges are used for this purpose. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 480-484 Chapter 10: Managing Database Use