Free Oracle 1z1-074 Exam Dumps Questions & Answers

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

• A.It always executes triggers that are fired recursively in FULLDML mode.
• B.It generates execution plans for each SQL statement in an STS.
• C.It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
• D.It recommends the use of SQL Tuning Advisor for regressed SQL statements.
• E.It recommends the creation of indexes for regressed SQL statements.

Which two statements are true about a band join? (Choose two.)

• A.It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.
• B.For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
• C.The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
• D.It returns rows for SQL statements that contain an equijoin.
• E.The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

• A.An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.
• B.PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• C.PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.
• D.An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.
• E.PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

• A.T1 is in the TBS_CMP tablespace
• B.T1 is in the TBS_UNCMP tablespace
• C.T1 is in uncompressed format
• D.All indexes on T1 remain valid
• E.The primary key constraints on T1 are dropped
• F.T1 is in compressed format

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A.number of database instances
• B.number of network interface cards (NICs)
• C.number of CPUs
• D.amount of RAM
• E.number of storage LUNs