READ Free Dumps For Oracle- 1z0-050
| Question ID 1899 | While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation? |
| Option A | A. It updates the existing SQL profiles with current statistics. |
| Option B | B. It makes the statistics information available to GATHER_STATS_JOB. |
| Option C | C. It initiates the statistics collection process by running GATHER_STATS_JOB. |
| Option D | D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually. |
| Correct Answer | B |
| Question ID 1900 | In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command: |
| Option A | A. authentication by password file |
| Option B | B. authentication by using certificates over SSL |
| Option C | C. authentication by using the Oracle Internet Directory |
| Option D | D. authentication by using the local OS of the database server |
| Correct Answer | A |