READ Free Dumps For Oracle- 1z0-060
| Question ID 20787 | On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
|
| Option A | It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
|
| Option B | It fails because no SQL *Loader data file location is specified.
|
| Option C | It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
|
| Option D | It fails because no SQL *Loader control file location is specified.
|
| Correct Answer | A,C |
Explanation Note: * SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.
| Question ID 20788 | After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
|
| Option A | Re-enable redaction policies that use FULL data redaction.
|
| Option B | Re-create redaction policies that use FULL data redaction.
|
| Option C | Re-connect the sessions that access objects with redaction policies defined on them.
|
| Option D | Flush the shared pool.
|
| Option E | Restart the database instance.
|
Explanation About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect. Note: * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application. * UPDATE_FULL_REDACTION_VALUES Procedure This procedure modifies the default displayed values for a Data Redaction policy for full redaction. * After you create the Data Redaction policy, it is automatically enabled and ready to redact data. * Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods: / Full redaction. / Partial redaction. / Regular expressions. / Random redaction. / No redaction. Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data Redaction Value