CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Passed Exam Today 1z0-083

Page: 17 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 65

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_REDACTION_VALUES(-1); 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 zero.What must you do to activate the new default value for numeric full redaction?

Options:

A.

Re-enableredactionpoliciesthatuseFULLdataredaction.

B.

Re-createredactionpoliciesthatuseFULLdataredaction.

C.

Re-connect the sessions that access objects with redaction policies defined on them.

D.

Flushthesharedpool.

E.

Restart the database instance. Correct

Question 66

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

Options:

A.

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.

Re-createthepasswordfileintheOracleDatabase12cformat. Correct

Question 67

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

Options:

A.

All the triggers associated with the table are flashed back but are disabled.

B.

Materialized views that use the CUSTOMERS table are flashed back.

C.

LOB segments associated with the CUSTOMERS table are flashed back.

D.

All the constraints defined on the table, except the referential integrity constraints, are flashed back.

E.

Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

Question 68

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

Options:

A.

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

B.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

F.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Page: 17 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF