1z1-074 試験問題を無料オンラインアクセス

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

• A.They can be created only if shared undo is enabled
• B.They can be created only for a PDB in the mount state
• C.They require a clone instance to be created when used in a PDB flashback operation
• D.They are created as guaranteed restore points
• E.They require backups to be restored when used in a PDB flashback operation
• F.They can be created for a PDB when connected to either the PDB or to the root

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

• A.It returns rows for SQL statements that contain an equijoin.
• B.For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
• C.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.
• D.The optimizer always uses the smaller of the two row sources to build a hash table on the join key.
• E.The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.

Examine these statements executed in the PROD1 database:

Which statements are audited?

• A.only the ALTER SYSTEM statements
• B.all the statements
• C.only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES
• D.only the CREATE USER statement
• E.only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.
Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

• A.Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
• B.Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.
• C.All their queries display blanks for LAST_NAME and zeroes for SALARY.
• D.All their queries display blanks for LAST_NAME and the true contents of the SALARY column.
• E.Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.

In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges.
Examine these commands:

SYS executes this command:
SQL> SELECT add_num(1,2) FROM DUAL;
What is the result?

• A.An error is returned
• B.TESTDBA is created with the SYSDBA privilege only
• C.Only "3" is displayed
• D.The message "The result is 3" only is displayed
• E.TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed