Question 46

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
  • Question 47

    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?
  • Question 48

    You executed this command to create a password file:
    $ orapwd file = orapworcl entries = 10 ignorecase = N
    Which two statements are true about the password file? (Choose two.)
  • Question 49

    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.)
  • Question 50

    You want to import the schema objects of the HRuser from the development database DEVDBto the production database PRODDBby using Oracle Data Pump. A database link devdb.us.oracle.comis created between PRODDBand DEVDB.
    You execute the following command on the PRODDBdatabase server:

    What should you do to resolve the error?