1Z0-060 Exam Question 46
After implementing full Oracle Data Redaction, you change the default value for the NUMBERdata type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
1Z0-060 Exam Question 47
You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the command to back up the ASM metadata regularly.
MD_BACKUP
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
MD_BACKUP
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
1Z0-060 Exam Question 48
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?
1Z0-060 Exam Question 49
To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE('SH', 'SALES', 'INT_SALES', 600); What is the significance of the dml_lock_timeoutperiod of 600 seconds in the preceding command?
1Z0-060 Exam Question 50
On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)