Oracle OCP 9i to 11g Security: New Features

Card Set Information

Author:
Tralala
ID:
192077
Filename:
Oracle OCP 9i to 11g Security: New Features
Updated:
2014-05-19 08:39:12
Tags:
Oracle OCP 9i 11g Security New Features
Folders:

Description:
Oracle OCP 9i to 11g Security: New Features
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. Which init parameter controls case sensitive passwords, what are the options?
    • SEC_CASE_SENSITIVE_LOGON
    • TRUE/FALSE
  2. How is a password stored?
    Case sensitve, SEC_CASE_SENSITIVE_LOGON just ignores the case
  3. How can one tell what version of a password is being used?
    PASSWORD_VERSIONS column in DBA_USERS
  4. How is orapwd set to ignore the case of the password?
    ignorecase=y
  5. What is the default ignorecase parameter in orapwd?
    ignorecase=n
  6. Which view can help find accounts that user defaul passwords?
    DBA_USERS_WITH_DEFPWD
  7. If an account is imported into 11G from a previous release, what happens to the password?
    It remains case insensitive
  8. What is the syntax to create an Encrypted Tablespace?
    • CREATE TABLESPACE tbs_name
    • DATAFILE '/path/filename' SIZE xx
    • ENCRYPTION [USING 'EncMethod']
    • DEFAULT STORAGE(ENCRYPT);
  9. What is the default encryption method in Encrypted Tablespace?
    AE128
  10. Where is the master encryption key stored for Encrypted Tablespace?
    Oracle Wallet
  11. When the Oracle Wallet is opened, how lond does it say open for?
    Until the database is shutdown or it's explicitly closed.
  12. What are the restictions in Encrypted Tablespace?
    • Cannot encrypt a tablespace using ALTER TABLESPACE
    • Subject to restrictions in tablespace transporting
    • When recovering, the Oracle Wallet must be opened after database mount and before database open.
  13. Where is the Oracle Wallet location defined?
    ENCRYPTION_WALLET_LOCATION in sqlnet.ora
  14. What is the default location for the Oracle Wallet?
    $ORACLE_BASE/admin/$ORACLE_SID/wallet
  15. What is the command to open the Oracle Wallet?
    ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "myPassword";
  16. Which view shows if a tablespace is encrypted?
    ENCRYPT column in DBA|USER_TABLESPACES
  17. Which common PL/ SQL utility packages are designed to enable database users to access network services from within the database?
    UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, UTL_INADDR
  18. Which Packages control the ACLs?
    DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY
  19. What is used to create an ACL?
    DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
  20. What is PRINCIPLE in DBMS_NETWORK_ACL_ADMIN.CREATE_ACL?
    The first user account or role being granted or denied permissions
  21. What is PIVILEGE in DBMS_NETWORK_ACL_ADMIN.CREATE_ACL?
    • CONNECT - UTL_TCP, UTL_SMTP, UTL_MAIL and UTL_HTTP
    • RESOLVE - UTL_INADDR (name/IP resolution)
  22. How is a user/role added to an ACL?
    DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
  23. How is a user/role removed from an ACL?
    DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE
  24. How is an ACL dropped?
    DBMS_NETWORK_ACL_ADMIN.DROP_ACL
  25. How is a host assigned to an ACL?
    • DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
    • ( acl = > 'file_name.xml',
    • host = > 'network_host',
    • lower_port = > null | port_number,
    • upper_port = > null | port_number);
  26. In a Oracle Password, which special characters do not have to be encapsulated in quotes?
    • $
    • _
    • #
  27. What are the options for SEC_PROTOCOL_ERROR_TRACE_ACTION?
    • NONE
    • TRACE
    • LOG
    • ALERT
  28. What are the options for SEC_PROTOCOL_ERROR_FURTHER_ACTION?
    • CONTINUE (Default)
    • DROP
    • DELAY, n (secs)
  29. Which parameter limits logon attempts for a client session?
    SEC_MAX_FAILED_LOGIN_ATTEMPTS
  30. What is the default for parameter AUDIT_TRAIL? To where are entries written?
    • DB
    • SYS.AUD$

What would you like to do?

Home > Flashcards > Print Preview