Oracle Database 11g: New Features for 9i OCPs v6.5 (1z0-055)

Page:    1 / 10   
Total 150 questions

Which three statements are true regardingpersistent lightweight jobs? (Choose three.)

  • A. The user cannot set privileges on persistent lightweight jobs
  • B. The use of a template is mandatory to create persistent lightweight jobs
  • C. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo
  • D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
  • E. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently


Answer : A,B,D

See the Exhibit:
Exhibit 1:
Exhibit 2:
The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit 1 less time than the process in exhibit2.
What is the reason for this?

  • A. It creates less metadata for the jobs
  • B. It creates jobs temporarily in memory only
  • C. It writes the job metadata to disk in compressed format
  • D. It updates several tables in the SYSTEM tablespace instead of creating new tables


Answer : A

While performing the backup of theflash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

  • A. The backup succeeds but it would be without the missing archived log
  • B. The backup fails because one of the archived redo log files is missing
  • C. The backup succeeds because it fails over to one of the alternative archived redo log destinations
  • D. During backup, you are prompted for the alternative destination for the missing archived redo log file


Answer : C

Which three actions are requiredto configure the Flashback Database? (Choose three.)

  • A. Set Flash Recovery Area
  • B. Enable Flashback logging
  • C. Create FLASHBACK tablespace
  • D. Start the database in the ARCHIVELOG mode
  • E. Start the database in the NONARCHIVELOG mode


Answer : A,B,D

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = LOCATION = /disk1/archive
LOG_ARCHIVE_DEST_2 = SERVICE = stdb1
DB-RECOVERY_FILE_DEST = /u01/oradata
Examine the following RMAN command is used to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED up 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

  • A. All archived redo log files backed up at least twice to tape are deleted
  • B. All archived redo log files backed up at least once to tape are eligible for deletion
  • C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area
  • D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion


Answer : D

Which three statements are true regarding the function of the AutotaskBackground Process
(ABP)? (Choose three.)

  • A. It translates tasks into jobs for execution by the scheduler
  • B. It creates jobs without considering the priorities associated with them
  • C. It determines the list of jobs that must be created for each maintenance window
  • D. It is spawned by the MMON background process at the start of the maintenance window
  • E. It maintenance a repository in the SYSTEM tablespace to store the history of the execution of all tasks


Answer : A,C,D

Which two statements regarding the Flashback Table feature are correct? (Choose two.)

  • A. Flashback Table can be performed on system tables
  • B. Flashback Table operation does not shrink the segments
  • C. Flashback table uses log mining to extract SQL_REDO and SQL_UNDO statements
  • D. Flashback Table operation acquires exclusive manipulation language (DML) locks


Answer : B,D

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?

  • A. It produces an error because data already exists in the table
  • B. It produces an error because compression can be enabled at table creation only
  • C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately
  • D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data


Answer : C

See the Exhibit:
Which statement is true regarding the status of the incident?

  • A. The DBA is working on the incident and prefers that the incident be kept in the ADR
  • B. The incident is now in the does state and the ADR can select the incident to be purged
  • C. The incident has been newly created and is in the process of collecting diagnostic information
  • D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support


Answer : D

See the series of commands to be executed:
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command?
(Choose two.)

  • A. It stores only the temporary table but not its indexes
  • B. It stores both the temporary table as well as its indexes
  • C. It must be a nondefault temporary tablespace for the database
  • D. It can be a default or nondefault temporary tablespace for the database
  • E. It must be default temporary tablespace of the user who issues the command


Answer : B,D

USER_DATA is anonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

  • A. Use Data Pump to transfer the existing data to a new encrypted tablespace
  • B. User ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace
  • C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
  • D. Enable row movement for each table to be encrypted and then use ALTER TABLESAPCE to encrypt the tablespace
  • E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted


Answer : A,B,C

Identify the activities performedas part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

  • A. Generating the SQL profile
  • B. Testing and accepting the SQL profile
  • C. Generating a list of candidate SQLs for tuning
  • D. Adding tuned SQL plans into the SQL plan baseline
  • E. Tuning each SQL statement in the order of importance
  • F. Generating baselines that include candidate SQL statement for tuning


Answer : A,B,C,E

See the Exhibit:
Which statement is true regarding the status of the incident?

  • A. The DBA is working on the incident and prefers that the incident be kept in the ADR
  • B. The incident is now in the does state and the ADR can select the incident to be purged
  • C. The incident has been newly created and is in the process of collecting diagnostic information
  • D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support


Answer : D

The SQL Tuning Advisor has beenconfigured with default configurationsinyourdatabase instance. Which recommendation is automatically implemented without the DBAs intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

  • A. Statistics recommendations
  • B. SQL profile recommendations
  • C. Index-related recommendations
  • D. Restructuring of SQL recommendations


Answer : B

Evaluate the following SQL statement used to create the PRODUCTS table:
Which statement is true regarding this command?

  • A. It executes successfully but partition pruning cannot happen for this partition key
  • B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key
  • C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key
  • D. It executes successfully but the values in the TOTAL_VLAUE column would not be physically stored in the partitions


Answer : D

Page:    1 / 10   
Total 150 questions