1z1-062 무료 덤프문제 온라인 액세스

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

• A.The granter of system privileges must possess the set container privilege.
• B.Local users cannot use local system privileges on the schema of a common user.
• C.System privileges apply only to the PDB in which they are used.
• D.Common users connected to a PDB can exercise privileges across other PDBs.
• E.System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)

• A.Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• B.Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• C.Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
• D.Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• E.Data is never redacted for the EMP_V.SAL column.

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

• A.Each Oracle process runs an SCMN thread.
• B.The local listener may pass the request to an existing process which in turn will create a thread.
• C.The local listener may spawn a now process and have that new process create a thread
• D.Each multithreaded Oracle process has an SCMN thread.
• E.Thread creation must be routed through a dispatcher process

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

• A.SYSTEM
• B.UNDO
• C.USERS
• D.EXAMPLE
• E.TEMP
• F.SYSAUX

Examine the parameters:

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)

• A.Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
• B.Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
• C.Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
• D.Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.
• E.Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.