READ Free Dumps For Oracle- 1z0-023
| Question ID 8861 | When should a DBA back up the control file? (Choose two)
|
| Option A | After a log switch.
|
| Option B | After a checkpoint.
|
| Option C | After adding a redo log file.
|
| Option D | After dropping a tablespace.
|
| Option E | After adding a new user with SYSDBA privileges.
|
| Correct Answer | CD |
Explanation Explanation/Reference: Explanation: Answers C and D are correct. The control file is the physical structure of the Oracle database. It keeps track of all the files Oracle needs and where they are on the host machine. So a DBA should back up the control file after adding a redo log file or after dropping a tablespace. Incorrect Answers: A: DBA does not need to back up the control file after a log switch. B: DBA does not need to back up the control file after a checkpoint. E: DBA does not need to back up the control file after adding a new user, because there are no changes in physical structures happened. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 318-320 Chapter 7: Managing the Physical Database Structure
| Question ID 8862 | What are two affects of setting REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE? (Choose two)
|
| Option A | The password file can be restored remotely.
|
| Option B | Password file access is restricted to local users.
|
| Option C | Only one instance of the database can use the password file.
|
| Option D | Remote connections using the SYSDBA privilege are allowed.
|
| Option E | Remote connections using the SYSDBA privilege are prohibited.
|
| Correct Answer | CD |
Explanation Explanation/Reference: Explanation: An EXCLUSIVE password file can be used with only one database. Only an EXCLUSIVE file can contain the names of users other than SYS. Using an EXCLUSIVE password file allows you to grant SYSDBA and SYSOPER system privileges to individual users and have them connect as themselves. Setting this parameter to NONE causes Oracle to behave as if the password file does not exist. That is, no privileged connections are allowed over non-secure connections. NONE is the default value for this parameter. A SHARED password file can be used by multiple databases. However, the only user recognized by a SHARED password file is SYS. You cannot add users to a SHARED password file. All users needing SYSDBA or SYSOPER system privileges must connect using the same name, SYS, and password. Incorrect Answers: A: The password file needs to be stored on the host machine in any case. B: Password file access is restricted to remote, not local, users. E: Remote connections using SYSDBA privilege will be allowed, not prohibited. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 275-281 Chapter 6: Basics of the Oracle Database Architecture