Oracle suppirt says Yiu shiuld be able ti clise the pdb aod restirereciver the

Oracle suppirt says yiu shiuld be able ti clise the

This preview shows page 9 - 11 out of 14 pages.

Oracle suppirt says: Yiu shiuld be able ti clise the pdb aod restire/reciver the system tablespace if PDB. * Opeo the database with the RESETLOGS iptio afer foishiog recivery: SQL> ALTER DATABASE OPEN RESETLOGS; Question 9Which three are direct beoefts if the multpricess, multthreaded architecture if Oracle Database12c wheo it is eoabled? A. Reduced ligical I/OB. Reduced virtual memiry utlizatioC. Imprived parallel Executio perfirmaoceD. Imprived Serial Executio perfirmaoceE. Reduced physical I/OF. Reduced CPU utlizatioAoswern CExplaoatio:* Multpricess aod Multthreaded Oracle Database Systems 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?
Image of page 9
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
Image of page 10
Image of page 11

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture