Archive for the '1z0-043' Category


Aug 15 2008

Pass4side 1Z0-043 Oracle Database 10g: Administration II Demo download

Published by mac0002 under 1z0-043

Exam Number: 1Z0-043 
Associated Certifications: Oracle Database 10g Database Administrator Oracle Certified Professional
 
Exam Price: $125.00 USD
Exam Registration: Register
   
 
Duration: 90 minutes
Number of Questions: 70
Passing Score: 70%
 

    1. You configure Flashback Database for the database instance with the following commands:

      SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=2880 SCOPE=BOTH SQL> ALTER DATABASE FLASHBACK ON;

      Which three statements must be true to make the above configuration successful? (Choose three)

    2. The database is open
    3. The database is in the ARCHIVELOG mode
    4. The database is backed up at least once
    5. The database is mounted in the EXCLUSIVE mode
    6. The flash recovery area is configured for the database instance
    1. You receive the following error while enabling the Flashback Database for the database instance:

      SQL> ALTER DATABASE FLASHBACK ON;
      alter database flashback on
      *
      ERROR at line 1:
      ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
      ORA-38707: Media recovery is not enabled.

      What is the reason for this?

    2. The database is not in the ARCHIVELOG mode
    3. The database is opened with the RESETLOGS option
    4. The Flash Recovery Area is not configured for the database instance
    5. The DB_FLASHBACK_RETENTION_TARGET parameter is set to zero
    1. You have a requirement to create a tablespace of 16 KB block size. You executed the CREATE TABLESPACE command and receive the following error:

      SQL> CREATE TABLESPACE glob_tbs DATAFILE SIZE 50M BLOCKSIZE 16K
      CREATE TABLESPACE glob_tbs DATAFILE SIZE 50M BLOCKSIZE 16K
      *
      ERROR at line 1:
      ORA-29339: tablespace block size 16384 does not match configured block sizes

      Which action would you take for successful execution of the command at the next attempt?

    2. Set the DB_16K_CACHE_SIZE parameter to a nonzero value
    3. Set the DB_KEEP_CACHE_SIZE parameter to a nonzero value
    4. Change the block size in the command to a value less than the standard block size
    5. Change the DB_BLOCK_SIZE parameter to 16 K in the parameter file and restart the database
    1. Examine the following scenario with respect to user-managed backup and recovery:

      - The loss of an important nonsystem tablespace in the database is reported at 11:30 AM
      - The tablespace was accidentally dropped at 11 AM.
      - You have the backup of all data files.
      - You have the backup of the control file that has an entry for the tablespace.

      Which statement is true about the recovery of the tablespace?

    2. Restore all data files; recover the database until a time before 11 AM
    3. Restore the control file; restore the data file that corresponds to the tablespace; recover the database
    4. Restore the control file; recover the database until a time before 11 AM with the USING BACKUP CONTROLFILE option
    5. Restore the control file; restore all data files; recover the database until a time before 11 AM with the USING BACKUP CONTROLFILE option
    1. You follow the incremental backup strategy for backing up your database. You want the Recovery Manager (RMAN) to identify only the modified blocks and avoid scanning every block in the data files while performing the incremental backup.

      What would you do to achieve this?

    2. Enable the block change tracking feature
    3. Configure the backup optimization feature
    4. Configure the RMAN for compressed backup
    5. Enable Flashback Database for the target database instance
    1. While the database instance is running, you receive an out-of-memory error due to the undersizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:

      ORA-04031: unable to allocate 4000 bytes of shared memory

      On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further.

      Identify a solution to reduce the probability of getting this error in future.

    2. Set the PRE_PAGE_SGA parameter to TRUE
    3. Set the LOCK_SGA initialization parameter to TRUE
    4. Implement Automatic Shared Memory Management
    5. Set the SGA_TARGET initialization parameter to zero

    BDE

    A

    A

    D

    A

    C

    Pass4side 1Z0-043 Oracle Database 10g: Administration II  Demo download

    More Oracle Certification infomation  visit:

    http://www.pass4side.com/Oracle.html

    No responses yet