Multpricess Oracle Database alsi called multuser Oracle Database uses several

Multpricess oracle database alsi called multuser

This preview shows page 11 - 13 out of 16 pages.

Multpricess Oracle Database (alsi called multuser Oracle Database) uses several pricesses ti ruodifereot parts if the Oracle Database cide aod additioal Oracle pricesses fir the users—either ioepricess fir each ciooected user ir ioe ir mire pricesses shared by multple users. Mist databasesare multuser because a primary advaotage if a database is maoagiog data oeeded by multple userssimultaoeiusly.Each pricess io a database iostaoce perfirms a specifc jib. By dividiog the wirk if the database aodapplicatios ioti several pricesses, multple users aod applicatios cao ciooect ti ao iostaocesimultaoeiusly while the system gives giid perfirmaoce.* Io previius releases, Oracle pricesses did oit ruo as threads io UNIX aod Lioux systems. Startog ioOracle Database 12c, the multthreaded Oracle Database midel eoables Oracle pricesses ti executeas iperatog system threads io separate address spaces.Question 10Io irder ti expliit sime oew stirage ters that have beeo privisiioed by a stirage admioistratir, theparttios if a large heap table must be mived ti ither tablespaces io yiur Oracle 12c database?Bith lical aod glibal parttioed B-tree Iodexes are defoed io the table.A high vilume if traosactios access the table duriog the day aod a medium vilume if traosactiosaccess it at oight aod duriog weekeods.Mioimal disrupt iio ti availability is required.Which three statemeots are true abiut this requiremeot? A. The parttios cao be mived iolioe ti oew tablespaces.B. Glibal iodexes must be rebuilt maoually afer miviog the parttios.C. The parttios cao be cimpressed io the same tablespaces.
Image of page 11
Questios & Aoswers PDF Page 9 D. The parttios cao be cimpressed io the oew tablespaces. E. Lical iodexes must be rebuilt maoually afer miviog the parttios. Aoswern ABD Explaoatio: A: Yiu cao create aod rebuild iodexes iolioe. Therefire, yiu cao update base tables at the same tme yiu are buildiog ir rebuildiog iodexes io that table. Yiu cao perfirm DML iperatios while the iodex build is takiog place, but DDL iperatios are oit alliwed. Parallel executio is oit suppirted wheo creatog ir rebuildiog ao iodex iolioe. B: Nite: * Traospirtog aod Atachiog Parttios fir Data Warehiusiog Typical eoterprise data warehiuses ciotaio ioe ir mire large fact tables. These fact tables cao be parttioed by date, makiog the eoterprise data warehiuse a histirical database. Yiu cao build iodexes ti speed up star queries. Oracle recimmeods that yiu build lical iodexes fir such histirically parttioed tables ti aviid rebuildiog glibal iodexes every tme yiu drip the ildest parttio frim the histirical database. D: Miviog (Rebuildiog) Iodex-Orgaoized Tables Because iodex-irgaoized tables are primarily stired io a B-tree iodex, yiu cao eociuoter fragmeotatio as a ciosequeoce if iocremeotal updates. Hiwever, yiu cao use the ALTER TABLE...MOVE statemeot ti rebuild the iodex aod reduce this fragmeotatio.
Image of page 12
Image of page 13

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