As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?
Correct Answer: B,E
A .False. Revoking from USR1 doesn't cascade due to WITH ADMIN OPTION. B .True. Revoking from USR2 cascades to USR3 because USR2 granted it. C .False. DBA can revoke the full privilege, not just ADMIN OPTION. D .False. USR1 can't revoke from USR3 directly; only the grantor (USR2) can. E .True. WITH ADMIN OPTION breaks the revoke chain from USR1 onward.
1Z0-182 Exam Question 17
Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?
Correct Answer: C,E
A .False. Connect Time Failover doesn't need TAF; TAF is for runtime failover. B .False. Source Routing doesn't mandate encryption. C .True. Needs multiple addresses (e.g., (ADDRESS_LIST=...)) for failover. D .False. Load balancing works with tnsnames.ora, no name server required. E .True. Balances connections across shared server dispatchers.
1Z0-182 Exam Question 18
What memory structure caches the data dictionary providing access to all database user processes?
Correct Answer: D
D .True. The Shared Pool caches data dictionary metadata (e.g., table definitions) in the Library Cache and Dictionary Cache, accessible to all processes. Others serve different purposes (e.g., Large Pool for backups).
1Z0-182 Exam Question 19
Which three statements are true about roles?
Correct Answer: B,C,F
Roles in Oracle manage privileges efficiently. Let's dive into each option: A . Roles must be password protected. False. Roles can be password-protected (e.g., CREATE ROLE mgr IDENTIFIED BY secret), but it's optional. Non-protected roles (default) are enabled automatically if granted, requiring no password. Mechanics:Password-protected roles need SET ROLE mgr IDENTIFIED BY secret, enhancing security for sensitive privileges. B . Roles may be granted to other roles. True. Roles can form hierarchies (e.g., GRANT clerk TO mgr), allowing nested privilege management. Mechanics:A user with mgr inherits clerk privileges indirectly. Revoking clerk from mgr cascades appropriately. Practical Use:Simplifies complex privilege structures in large organizations. C . The SET ROLE statement can enable one or more roles for a session. True. SET ROLE role1, role2; activates specified roles for the session, assuming they're granted and not password-protected (or password is provided). Mechanics:Enabled roles grant their privileges immediately within the session scope. D . Object privileges may not be granted to roles. False. Object privileges (e.g., GRANT SELECT ON emp TO clerk) are a primary use of roles, making this statement incorrect. Why Incorrect:Roles are designed for this purpose, contradicting the option. E . All roles granted to a user are set on default when the user logs in. False. Only roles marked as DEFAULT ROLE (via ALTER USER ... DEFAULT ROLE role1) are enabled at login. Non-default roles require SET ROLE. Mechanics:Check via SELECT * FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES'. F . The SET ROLE statement can disable one or more roles for a session. True. SET ROLE NONE disables all roles, or SET ROLE role1 implicitly disables others not listed, providing granular control. Practical Use:Useful for testing or restricting privileges temporarily.
1Z0-182 Exam Question 20
Which four statements are true about the Oracle Server architecture?
Correct Answer: A,C,D,F
A .True. Multiple sessions with different users are possible. B .False. Buffer cache and redo log buffer are in SGA, not large pool. C .True. Session tracks login state. D .True. Each process has its own PGA. E .False. Connection is the network link; session is the state. F .True. Same user can have multiple sessions (e.g., via different terminals).
