READ Free Dumps For Oracle- 1z0-060
| Question ID 2179 | Which three statements are true about using flashback database in a multitenant container database (CDB)? |
| Option A | A. The root container can be flashed back without flashing back the pluggable databases (PDBs). |
| Option B | B. To enable flashback database, the CDB must be mounted. |
| Option C | C. Individual PDBs can be flashed back without flashing back the entire CDB. |
| Option D | D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. |
| Option E | E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. |
| Correct Answer | B,D,E |
| Question ID 2180 |
|
| Option A | A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. |
| Option B | B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. |
| Option C | C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. |
| Option D | D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial. |
| Correct Answer | A,D |
