1z0-063 Exam Question 91
Your database supports an OLTP workload. Examine the output of the query:
To ensure faster instance recovery, you set the FAST_START_MTTR_TARGETinitialization parameter to 30.
What is the effect of this setting on the database?
To ensure faster instance recovery, you set the FAST_START_MTTR_TARGETinitialization parameter to 30.
What is the effect of this setting on the database?
1z0-063 Exam Question 92
You are administering a multitenant container database (CDB) CDB1with two pluggable databases (PDBs), PDB1and PDB2. You execute the following commands on CBD$ROOTas the SYSuser:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTTuser?
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTTuser?
1z0-063 Exam Question 93
When is the UNDO_RETENTION parameter value ignored by a transaction?
1z0-063 Exam Question 94
After implementing full Oracle Data Redaction, you change the default value for the number data type as
follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
- ------------------------
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
- -----------------------
- 1
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?
follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
- ------------------------
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
- -----------------------
- 1
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-063 Exam Question 95
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)