Free Oracle 1z0-074 Exam Dumps Questions & Answers

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

• A.  CUST_RECORDS table in Murdok's schema
• B.  CUST_RECORDS table in the schema of Bixby and Rlayton
• C.  CUST_RECORDS table in Rlayton's schema
• D.  CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok
• E.  CUST_RECORDS table in Bixby's schema

In which situation can the optimizer choose a hash join?

• A.  when a non-equijoin is used and the join column for both tables is a primary key
• B.  when any self-join is done
• C.  when an equality operator is used
• D.  when a non-equijoin is used between a table and a sorted hash cluster
• E.  when a non-equijoin is used and the join column in at least one of the tables is a primary key

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.  All indexes on T1 remain valid
• B.  The primary key constraints on T1 are dropped
• C.  T1 is in the TBS_CMP tablespace
• D.  T1 is in the TBS_UNCMP tablespace
• E.  T1 is in compressed format
• F.  T1 is in uncompressed format

In a database on an Oracle Exadata Database machine, a DBA executes this command:
SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs');
What is the result?

• A.  Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.
• B.  Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.
• C.  Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.
• D.  All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?

• A.  Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
• B.  Grant SYSRAC to user1.
• C.  Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
• D.  Grant SYSRAC to ops$user1.
• E.  Grant SYSDBA to ops$user1