Which three statements are true about using SQL*Plus?
Correct Answer: A,E,F
A .True. sqlplus @script.sql works from shell scripts. B .False. RMAN uses its own client, not SQL*Plus. C .False. Bundled with Oracle DB software. D .False. Command-line only; no GUI in 23ai. E .True. @script runs scripts interactively. F .True. Commands like SHOW PARAMETER are unique.
1Z1-182 Exam Question 7
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.
1Z1-182 Exam Question 8
Which three relationships between instances and Oracle databases are possible without using Multi-tenant?
Correct Answer: B,D,E
A .False. One instance can't mount multiple DBs without multitenant. B .True. RAC allows multiple instances to share one DB. C .False. Same as A; not possible without CDB. D .True. An instance can start in NOMOUNT with no DB. E .True. Standard single-instance configuration.
1Z1-182 Exam Question 9
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?
Correct Answer: A,D
A .True. Local checkpoints are allowed in PDBs. B .False. Buffer cache is CDB-level. C .False. Log switching is CDB-level. D .True. Restricted session can be toggled per PDB.
1Z1-182 Exam Question 10
Which three statements are true about Enterprise Manager Cloud Control?
Correct Answer: A,B,C
A .True. Integrates with MOS for patches and support. B .True. Manages Exadata, etc. C .True. Covers WebLogic and other middleware. D .False. Web-based, but not built into the DB. E .False. Can manage stopped instances via agents.
