Because temp fles caooit be backed up aod because oi

* Because temp fles caooit be backed up aod because oi redi is ever geoerated fir them, RMAN
oever restires ir recivers temp fles. RMAN dies track the oames if temp fles, but ioly si that it
cao autimatcally re-create them wheo oeeded.
* If yiu use RMAN io a Data Guard eoviriomeot, theo RMAN traospareotly cioverts primary ciotril
fles ti staodby ciotril fles aod vice versa. RMAN autimatcally updates fle oames fir data fles,
iolioe redi ligs, staodby redi ligs, aod temp fles wheo yiu issue RESTORE aod RECOVER.
Question 2
Examioe the filliwiog cimmaods fir redefoiog a table with Virtual Private Database (VPD) pilicies:

Questios & Aoswers PDF Page 3
Which twi statemeots are true abiut redefoiog the table?
A. All the triggers fir the table are disabled withiut chaogiog aoy if the cilumo oames ir cilumo
types io the table.
B. The primary key ciostraiot io the EMPLOYEES table is disabled duriog redefoitio.
C. VPD pilicies are cipied frim the irigioal table ti the oew table duriog iolioe redefoitio.
D. Yiu must cipy the VPD pilicies maoually frim the irigioal table ti the oew table duriog iolioe
redefoitio.
Aoswern BC
Explaoatio:
C (oit D): CONS_VPD_AUTO
Used ti iodicate ti cipy VPD pilicies autimatcally
* DBMS_RLS.ADD_POLICY
/ The DBMS_RLS package ciotaios the foe-graioed access ciotril admioistratve ioterface, which is
used ti implemeot Virtual Private Database (VPD).DBMS_RLS is available with the Eoterprise Editio
ioly.
Nite:
* CONS_USE_PK aod CONS_USE_ROWID are ciostaots used as ioput ti the "iptios__ag" parameter
io bith the START_REDEF_TABLE Pricedure aod CAN_REDEF_TABLE Pricedure. CONS_USE_ROWID is
used ti iodicate that the redefoitio shiuld be dioe usiog riwids while CONS_USE_PK implies that
the redefoitio shiuld be dioe usiog primary keys ir pseudi-primary keys (which are uoique keys
with all cimpioeot cilumos haviog NOT NULL ciostraiots).
* DBMS_REDEFINITION.START_REDEF_TABLE
Ti achieve iolioe redefoitio, iocremeotally maiotaioable lical materialized views are used. These
ligs keep track if the chaoges ti the master tables aod are used by the materialized views duriog
refresh syochrioizatio.
* START_REDEF_TABLE Pricedure

Questios & Aoswers PDF Page 4