READ Free Dumps For Oracle- 1z0-060

Question ID 2187	You are administering a database and you receive a requirement to apply the following restrictions: 1.    A connection must be terminated after four unsuccessful login attempts by user. 2.    A user should not be able to create more than four simultaneous sessions. 3.    User session must be terminated after 15 minutes of inactivity. 4.    Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?
Option A	A.    by granting a secure application role to the users
Option B	B.    by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
Option C	C.    By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
Option D	D.    By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
Option E	E.    By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
Correct Answer	C

Explanation

Question ID 2188	A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?
Option A	A.    The keep pool is not configured.
Option B	B.    Automatic Workarea Management is not configured.
Option C	C.    Automatic Shared Memory Management is not enabled.
Option D	D.    The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
Option E	E.    All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
Correct Answer	D

Explanation

Previous-Page 1 2. . . 41 42 43 44 45 46 47. . . 100 101 Next-Page

Send email to admin@getfreedumps for new dumps request!!!