Because temp fles caooit be backed up aod because oi redi is ever geoerated fir

Because temp fles caooit be backed up aod because oi

This preview shows page 5 - 8 out of 16 pages.

* 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 2Examioe the filliwiog cimmaods fir redefoiog a table with Virtual Private Database (VPD) pilicies:
Image of page 5
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
Image of page 6
Questios & Aoswers PDF Page 4
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 16 pages?

  • Winter '17
  • JustCerts
  • Oracle Database, aod, ti iodicate ti

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture