Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?

• A.A scheduler window can control resource allocation by itself.
• B.A job class specifies a scheduler window that will be open when that job class becomes active.
• C.Ascheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
• D.A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
• E.A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.

Comment: *

Name: *

Email: *

Verification: *

A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

• A.SYS sessions, regardless of the roles that are set in the session
• B.SYSTEM sessions,regardless of the roles that are set in the session
• C.SCOTT sessions, only if the MGR role is set in the session
• D.SCOTT sessions, only if the MGR role is granted to SCOTT
• E.SCOTT sessions, because he is the owner of the table
• F.SYSTEM session, only ifthe MGR role is set in the session

Comment: *

Name: *

Email: *

Verification: *

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

• A.Execute the command as SYS in both databases.
• B.Change the command to create a public database link in BOSTON.
• C.Execute the command as HR in BOSTON and SYS in DENVER.
• D.Execute the command as SYS in DENVER.
• E.Execute the command as SYS in BOSTON.
• F.Change the command to create a public database link in DENVER.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning the multitenant architecture?

• A.Each pluggable database (PDB) has its own set of background processes.
• B.A PDB can have a private temp tablespace.
• C.PDBs can share the sysaux tablespace.
• D.Log switches occur only at the multitenant container database (CDB) level.
• E.Different PDBs can have different default block sizes.
• F.PDBs share a common system tablespace.
• G.Instance recovery is always performed at the CDB level.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Database Configuration Assistant (DBCA)?
(Choose two.)

• A.It can be used to create a database template from an existing database.
• B.It can be used to add a new tablespace.
• C.It can generate SQL database creation scripts.
• D.It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
• E.It can configure Automatic Storage Management (ASM) diskgroups.

Comment: *

Name: *

Email: *

Verification: *