QUESTION 64 Which three statements are true about the Oracle Data Dictionary? (Choose three.)

QUESTION 66 Which two statements are true about views used for viewing tablespace and datafile information? ( Choose two. )

QUESTION 67 Examine the description of the PROMOTIONS table: You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

QUESTION 70 Which two statements are true about the rules of precedence for operators? (Choose two .)

QUESTION 72 Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

QUESTION 73 You need to calculate the number of days from 1 st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? (Choose two .)

QUESTION 74 Which two statements are true about the DUAL table? (Choose two .)

QUESTION75 Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? ( Choose four. )

QUESTION 77 What is true about non-equijoin statement performance? (Choose two .)

QUESTION 78 In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are Smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two .)

QUESTION 79 Choose two . Examine this parameter: NAME TYPE VALUE -------------------------------------------------------------------------------------------------db_create_file_dest string /u01/ app/oracle/oradata/prod/ Now examine this statement CREATE TABLESPACE data_olap; Tablespace is created. Which two are true about this tablespace and its attributes?

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

QUESTION 82 Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

QUESTION 83 Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

QUESTION 84 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two .)