In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose
two.)

• A.In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the
  DEFAULT profile.
• B.These users can never reuse a password
• C.The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of
  PASSWORD_REUSE_MAX.
• D.The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of
  CPU_PER_CALL

Comment: *

Name: *

Email: *

Verification: *

What is the outcome of the SHUTDOWN ABORT command?

• A.Uncommitted transactions are rolled back
• B.Dirty buffers in the buffer cache andunwritten redo are not written to the data files and redo log files respectively.
• C.Instance recovery must be requested by the DBA at the next startup
• D.Pending transactions are committed and the database is closed.

Comment: *

Name: *

Email: *

Verification: *

Which three factors influence the optimizer's choice of an execution plan?

• A.fixed baselines
• B.object statistics in the data dictionary
• C.the optimizer_mode initialization parameter
• D.type of connection used to connect to database instance
• E.cardinality estimates

Comment: *

Name: *

Email: *

Verification: *

You are connected using SQL* Plus to a multitenant container database (CDB) with
SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A.It fails because common users are unable to use the SET CONTAINER statement.
• B.It succeeds because the PDB_ADMIN user has the required privileges.
• C.If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
• D.Itfails because local users are unable to use the SET CONTAINER statement.

Comment: *

Name: *

Email: *

Verification: *

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A.It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• B.It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• C.It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
• D.It generates an error when creating the table because the wallet is closed.

Comment: *

Name: *

Email: *

Verification: *