You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

• A.by granting a secure application role to the users
• B.by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to
  FALSE
• C.By creating and assigning a profile to the users and setting the
  SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D.By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE
  parameter to NONE.
• E.By implementing the database resource Manager plan and setting the
  SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Comment: *

Name: *

Email: *

Verification: *

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

• A.RMAN CONVERT command
• B.Data Pump Export and import
• C.Conventional Export and Import
• D.The BACKUP AS COPY DATABASE . . . command of RMAN
• E.DBMS_FILE_TRANSFER with transportable tablespace

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about SQL plan directives?

• A.They are tied to a specific statement or SQL ID.
• B.They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C.They are used to gather only missing statistics.
• D.They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• E.They instruct the optimizer to create only column group statistics.
• F.Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Comment: *

Name: *

Email: *

Verification: *

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1 . The user account must be locked after five consecutive unsuccessful login attempts.
2 . Data read per session must be limited for the user.
3 . The user cannot have more than three simultaneous sessions.
4 . The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this?

• A.by implementing Database Resource Manager and assign it a role for the user
• B.by alerting the appropriate user attributes with anALTER USERcommand
• C.by implementing DatabaseResource Manager and assign it a profile for the user
• D.by using appropriatePASSWORDparameters set in the profile assigned to the user
• E.by using appropriateKERNELparameters set in the profile assigned to the user

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Oracle Data Pump export and import operations?

• A.You can detach from a data pump export job and reattach later.
• B.Data pump uses parallel execution server processes to implement parallel import.
• C.Data pump import requires the import file to be in adirectory owned by the oracle owner.
• D.The master table is the last object to be exported by the data pump.
• E.You can detach from a data pump import job and reattach later.

Comment: *

Name: *

Email: *

Verification: *