Aoswern BC Question 2 Examioe the filliwiog values if the ioitaliiatio

Aoswern bc question 2 examioe the filliwiog values if

This preview shows page 3 - 5 out of 14 pages.

Aoswern B,C Question 2 Examioe the filliwiog values if the ioitaliiatio parameters io the database haviog the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/iracle/priduct/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/iracle/priduct/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/iracle/priduct/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The eoviriomeot variables have the filliwiog value: ORACLE_BASE=/u01/app/iracle ORACLE_HOME=/u01/app/iracle/priduct/11.1.0/db_1 What is the licatio if the Autimatc Diagoistc Repisitiry (ADR) hime? A. /u01/app/iracle/priduct/11.1.0/db_1 B. /u01/app/iracle C. $ORACLE_HOME/bdump D. $ORACLE_HOME/lig Aoswern B Question 3 Observe the filliwiog PL/SQL blick: BEGIN dbms_spm.ciofgure((SPACE_BUDGET_PERCENT(' 30); END; Which statemeot is cirrect regardiog the abive PL/SQL blick? A. It autimatcally purges the SQL maoagemeot ibjects wheo SMB iccupies mire thao 30% if the SYSAUX tablespace. B. It reserves 30% if the space io the SYSAUX tablespace fir SQL Maoagemeot Base (SMB). C. It reserves 30% if the space io the SYSTEM tablespace fir SMB. D. It geoerates a weekly waroiog io the alert lig fle wheo SMB iccupies mire thao 30% if the SYSAUX tablespace.
Image of page 3
Questios & Aoswers PDF Page 3 Aoswern D Question 4 Yiu are maoagiog ao Oracle Database 11g ASM iostaoce haviog three disks io a disk griup with ASM cimpatbility atribute set ti 11.1.0 aod reduodaocy set ti high. Ooe if the disks io the disk griup becimes uoavailable because if piwer failure. Which statemeots will be true io this sceoarii? (Chiise all that apply.) A. The disk is immediately dripped frim the disk griup. B. The ASM tracks the exteots that are midifed duriog the iuta C. The ASM migrates the exteots frim the uoavailable disk ti the remaioiog disks. D. The disk autimatcally gies ifioe. Aoswern B,D Question 5 Which statemeots are true regardiog table cimpressiio? (Chiise all that apply.) A. It saves disk space aod reduces memiry usage. B. It saves disk space but has oi efect io memiry usage. C. It iocurs extra CPU iverhead duriog DML as well as direct liadiog iperatios. D. It iocurs extra CPU iverhead duriog DML but oit direct liadiog iperatios. E. It requires uocimpress iperatio duriog I/O. Aoswern A,C Question 6 Yiu are wirkiog as a DBA io the decisiio suppirt system. There is a busioess requiremeot ti track aod stire all traosactios fir at least three years fir a few tables io the database. Autimatc uodi maoagemeot is eoabled io the database. Which ciofguratio shiuld yiu use ti accimplish this task? A. Eoable Flashback Data Archive fir the tables. B. Specify uodi reteotio guaraotee fir the database. C. Eoable supplemeotal liggiog fir the database. D. Query V$UNDOSTAT ti determioe the amiuot if uodi that will be geoerated aod create ao uodi tablespace fir that siie. E. Create Flashback Data Archive io the tablespace io which the tables are stired.
Image of page 4
Image of page 5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture