1z0-060 Free Practice Test

On your Oracle 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?

1. A. Only the ORD_CUSTOMER_IX1 index create
2. B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
3. C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
4. D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
5. E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
6. F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Correct Answer: BF

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

1. A. SYSTEM
2. B. SYSAUX
3. C. EXAMPLE
4. D. UNDO
5. E. TEMP
6. F. USERS

Correct Answer: ABE

To implement Automatic Management (AMM), you set the following parameters:
<>> > >>

1. A. The PGA_AGGREGATE_TARGET parameter is set to zero.
2. B. The STATISTICS_LEVEL parameter is set to BASI
3. C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
4. D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Correct Answer: B

Examine these two statements:
<>

1. A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
2. B. The MRKT tablespace may be dropped if it has no contents.
3. C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
4. D. No more data files can be added to the tablespace.
5. E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Correct Answer: CDE

A redaction policy was added to the SAL column of the SCOTT.EMP table:
<>>

1. A. SYS sessions, regardless of the roles that are set in the session
2. B. SYSTEM sessions, regardless of the roles that are set in the session
3. C. SCOTT sessions, only if the MGR role is set in the session
4. D. SCOTT sessions, only if the MGR role is granted to SCOTT
5. E. SCOTT sessions, because he is the owner of the table
6. F. SYSTEM session, only if the MGR role is set in the session

Correct Answer: ABD