ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 219 discussion

Actual exam question from Oracle's 1z0-062
Question #: 219
Topic #: 1
[All 1z0-062 Questions]

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)

  • A. by alerting the appropriate user attributes with an ALTER USER command
  • B. by using appropriate PASSWORD parameters set in the profile assigned to the user
  • C. by implementing Database Resource Manager and assign it a profile for the user
  • D. by implementing Database Resource Manager and assign it a role for the user
  • E. by using appropriate KERNEL parameters set in the profile assigned to the user
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by rcgenilo27 at Sept. 18, 2019, 3:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
melat
Highly Voted 4 years, 10 months ago
BE: you can accomplish all 4 resource limit restrictions by changing the PASSWORD and the KERNEL parameters set in the profile assigned to the user. LOGICAL_READS_PER_CALL and SESSIONS_PER_USER are examples of KERNEL parameters in a profile.
upvoted 7 times
dfabac
2 years, 12 months ago
agree. this is correct.
upvoted 1 times
...
...
Ray520
Most Recent 3 years, 1 month ago
AD is correct. Tricky question. Resource management can be done with PROFILE and not ROLE. However, to update a PROFILE, a proper role should be assigned to the user that has the ALTER PROFILE privilege. I believe that is the reason D should be correct. If the option for D wasn't provided, then we could choose PROFILE option (C).
upvoted 1 times
...
hggz
5 years, 2 months ago
AD correct https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310 Use the CREATE PROFILE statement to create a profile, which is a set of limits on database resources. If you ASSIGN (ALTER USER) the profile to a user, then that user cannot exceed these limits. 1. FAILED_LOGIN_ATTEMPTS 2. LOGICAL_READS_PER_SESSION 3. SESSIONS_PER_USER 4. IDLE_TIME
upvoted 3 times
hggz
5 years, 2 months ago
Sorry, this solution for B and E
upvoted 2 times
...
hggz
5 years, 2 months ago
Sorry, this solution for B and C
upvoted 3 times
...
...
Havok
5 years, 3 months ago
This should be BD. You can use the profile to make sure the password parameters are enforced... and use Resource Manager to limit resource usage
upvoted 3 times
jackymak
3 years, 3 months ago
For D, assign to a role, can't the users unset the role? I think assign to a profile is better. B,C
upvoted 1 times
jackymak
3 years, 3 months ago
I am considering B,E since Resource Manager cannot handle the (1) login failure. But I also doubt Kernel can handle (2) read data?
upvoted 1 times
jackymak
3 years, 3 months ago
B and C
upvoted 1 times
jackymak
3 years, 3 months ago
B,E Resource manager will implement to all user, not the user.
upvoted 1 times
...
...
...
...
...
rcgenilo27
5 years, 8 months ago
is it role or profile?
upvoted 3 times
jackymak
3 years, 1 month ago
profile
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel