QUESTION 157 Which two statements are true about the Automatic Diagnostic Repository (ADR)?

QUESTION 158 Choose two . Which are two of the account management capabilities that can be configured using Oracle profiles?

QUESTION 159 Which two statements are true about SQL∗Loader Express Mode in an Oracle 12c database?

QUESTION 160 On your Oracle 19c database, you invoke SQL∗Loader to load data into the employees table in the hr schema by issuing the command : $> sqlldr hr/hr@pdb table=employees Which two statements are true about the command?

QUESTION 161 Choose three In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database ( PDB) : $ > sqlldr hr/ hr@ pdb table= employees Which three are true?

QUESTION 162 Choose two . Which two statements are true about table data storage in an Oracle Database?

QUESTION 163 Choose two . Which two statements are true about views?

QUESTION 164 Choose two Which two statements are true about views?

QUESTION 165 Choose two . Which two statements are true about date/time functions in a session where NLS_ DATE_ FORMAT is set to DD-MON-YYYY HH24: MI:SS?

QUESTION 166 Choose two . Which two statements are true about the tools used to configure Oracle Net Services?

QUESTION 167 Choose three . You currently have an active transaction in your session and have been granted SELECT access to V$TRANSACTION. Executing: SELECT xid, status FROM v$transaction; in your Session returns: XID ---------------------------0A0007000A070000 STATUS --------------ACTIVE In which Three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

QUESTION 169 Choose two . You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis . Which two are types of an alyses that can bed one using the DBMS_PRIVILEGE_CAPTURE package?

QUESTION 170 Choose two . Which two statements are true regarding indexes?

QUESTION 171 Choose two . Which two statements are true concerning logical and physical database structures?

QUESTION 172 Choose three. Which three relationships between instances and Oracle databases are possible without using Multi-tenant?