Free Oracle 1Z1-060 Exam Dumps Questions & Answers

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

• A.  The ORACLE_BASE base parameter is not set.
• B.  The operating system group that is specified must have permission to write to the inventory directory.
• C.  The installation is being performed by the root user.
• D.  The operating system group that is specified should have the root user as its member.

Which two statements are true about Oracle Managed Files (OMF)?

• A.  OMF may affect the location of the redo log files and archived log files.
• B.  The file system directions that are specified by OMF parameters are created automatically.
• C.  OMF cannot be used in a database that already has data files created with user-specified directions.
• D.  OMF automatically creates unique file names for table spaces and control files.
• E.  OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

Which three statements are true about SQL plan directives?

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

On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)

• A.  Only the ORD_CUSTOMER_IX2 index is created.
• B.  Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.
• C.  Only the ORD_CUSTOMER_IX1 index is created.
• D.  The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.
• E.  Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.

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