Oracle 1Z0-083 Quiz 30 Topic 9 Questions 146-150

Question: 1

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

AFULL redaction is active on the SAL column

BRANDOM redaction is active on the MGR column

CRANDOM redaction is active on the HIREDATE column

DPARTIAL redaction is active on the MGR column.

EPARTIAL redaction is active of the HIREDATE column.

Show Answer

Question: 2

Which two are true about flashback features in Oracle Database 19c and later releases?

AFlashback logs are monitored and proactively deleted when beyond the retention period definedin DB_flashback_retention_TARGET only after there is space pressure

BFlashback logs are monitored and proactively deleted when beyond the retention period definedin db_flashback_retention_target before there is space pressure.

CFlashback logs are automatically purged whenever the value
Of DB_FLASHBACK_RETENTION_TARGET is changed.

DFlashback logs are monitored for being older than the retention period defined
in db_flashback_retention_target and can be deleted by an administrator written event trigger.

EFlashback logs are automatically purged when db_flashback_retention_target is set lower
than the time they have already been retained.

Show Answer

Question: 3

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)?

AThe Oracle Grid Infrastructure Installation must be owned by the grid user.

BThe Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

CThe primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.

DThe Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.

EThe same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

EBy default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

Show Answer

Question: 4

Your sales_root application container has two application PDBs.

The sales_app application has a common table, FIN.REVENUE, in the two PDBs.

Examine this query and its output:

q4_1Z0-083

Which two are true?

AA container map exists for the revenue table, but Is not enabled.

BThe maptable table defines a logical partition key on a commonly used column for the revenue table.

CThe containers clause cannot be used in queries on the revenue table.

DThe revenue table partitions are not pruned across the PDBs automatically.

EThe maptable table is a metadata-linked table.

FThe revenue table must be a list-partitioned table.

Show Answer

Question: 5

You are managing this configuration:

1. CDB1 is a container database.

2. BDB1 and PDB2 are two pluggable databases in CDB1.

3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.

q5_1Z0-083

Which two are true?

AThe inserts on USER1 . EMP were committed when the session connected to pdb2.

BThe insert on user2.dept is uncommitted.

CThe inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.

DThe inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.

EThe insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.

FThe insert on user2.dept fails because of the active transaction in the parent container.

GThe inserts on USER1.EMP were rolled back when the session connected to pdb2.

Show Answer

Oracle 1Z0-083 Quiz:30 Topic:9 Questions:146-150