Page: 1
/ 13
Total 183 questions
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?
- A. Enable Flashback Data Archive for the tables.
- B. Enable supplemental logging for the database.
- C. Specify undo retention guarantee for the database.
- D. Create Flashback Data Archive on the tablespace on which the tables are stored.
- E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
Answer : A
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report(lmy_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?
- A. Add a finding directive for the ADDM task.
- B. Add a segment directive for the ADDM task.
- C. Add a parameter directive for the ADDM task.
- D. Disable the Segment Advisor from the Automatic Maintenance Task.
Answer : B
View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ 'customers^be1,
'(countryjd, cust_state_province)') FROM dual;
Which statement describes the significance of this command?
- A. It collects statistics into the pending area in the data dictionary.
- B. It creates a virtual hidden column in the CUSTOMERSjDBE table.
- C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
- D. It creates a histogram to hold skewed information about the data in the columns.
Answer : B
Examine the following PL/SQL block:
SET SERVEROUTPUT ON -
SET LONG 10000 -
ECLARE report clob;
BEGIN -
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT .PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?
- A. The plan baselines are verified with the SQL profiles.
- B. All fixed plan baselines are converted into nonfixed plan baselines.
- C. All the nonaccepted SQL profiles are accepted into the plan baseline.
- D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer : D
Which statement is true regarding the VALIDATE DATABASE command?
- A. It checks the database for intrablock corruptions only
- B. It checks for block corruption in the valid backups of the database.
- C. It checks the database for both intrablock and interblock corruptions.
- D. It checks for only those corrupted blocks that are associated with data files.
Answer : A
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a
SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)
- A. the SQL text
- B. the execution plan
- C. the execution context Do- the execution frequency
- D. the system change number (SCN)
Answer : A,C,D
Which three statements correctly describe the features of the I/O calibration process?
(Choose three.)
- A. Only one I/O calibration process can run at a time
- B. It automates the resource allocation for the Automated Maintenance Tasks.
- C. It improves the performance of the performance-critical sessions while running.
- D. It can be used to estimate the maximum number of l/Os and maximum latency time for the system.
- E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
Answer : A,D,E
Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)
SQL>STARTUP UPGRADE -
- A. It enables all system triggers.
- B. It allows only SYSDBA connections.
- C. It ensures that all job queues remain active during the upgrade process.
- D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Answer : B,D
Which three statements are true regarding the functioning of the Autotask Background
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 maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
Answer : A,C,D
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
- A. Compute the baseline statistics.
- B. Take an immediate AWR snapshot.
- C. Decrease the window size for the baseline.
- D. Decrease the expiration time for the baseline.
Answer : A
You upgraded Oracle Database 10g to Oracle Database 11 g. How would this affect the existing users' passwords?
- A. All passwords automatically become case-sensitive.
- B. All passwords remain non-case-sensitive till they are changed.
- C. All passwords remain non-case-sensitive and cannot be changed.
- D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
Answer : B
Which steps are mandatory to enable Direct NFS?
1. Mount all required file systems using the kernel NFS driver.
2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3. Replace the ODM library libodm11 .so_stub with libodm11 .so.
- A. 2 and 3
- B. 1 and 3
- C. 1 and 2
- D. 1, 2 and 3
Answer : B
- A. The tablespace having Flashback Archive is dropped.
- B. The Flashback Archive FLA1 is dropped only if it is empty.
- C. The Flashback Data Archive and historical data are dropped.
- D. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
Answer : D
You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario?
(Choose all that apply.)
- A. ASM compatibility controls which features for the ASM will be enabled.
- B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
- C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
- D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
Answer : A,B,D
SQL> EXECUTE -
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?
- A. It creates a baseline template that never expires.
- B. It produces an error because no snapshot information is provided to create the baseline.
- C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
- D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.
Answer : A
30 days access 