移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Which of the following calendaring syntax expressions would evaluate to the last day of every month?()  

A

 FREQ = MONTHLY; BYMONTHDAY = 31

B

 FREQ = MONTHLY; BYMONTHDAY = -1

C

 FREQ = DAILY; BYDAY = -1

D

 FREQ = MONTHLY; BYDAY = 31

E

 FREQ = DAILY; BYMONTHDAY = LAST_DAY

多选题 Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)

A

The ADR base keeps all diagnostic information in binary format

B

SQL*Plus provides the ADRI script, which can be used to work with ADR

C

The ADR can be used for problem diagnosis only when the database is open

D

The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E

The ADR can be used for problem diagnosis even when the database instance is down

F

The ADR base is shared across multiple instances

单选题 You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?()

A

Set MEMORY_TARGET to zero

B

Set the STATISTICS_LEVEL parameter to BASIC

C

Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D

Set the PGA_AGGREGATE_TARGET parameter to nonzero value

单选题 After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:   Select group_number, count(*) from v$asm_operation;   What is the implication if the query against V$ASM_OPERATION returns zero rows?()  

A

 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

B

 The drop disk operation is complete and you can run the undrop disks command if needed.

C

 The drop disk operation is complete and you cannot run the undrop disk command.

D

 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 

E

 None of the above is true.

单选题 If a job references a schedule that has been disabled, what will be the result?()  

A

 The job will be automatically disabled.

B

 The job will never execute.

C

 The job will attempt to execute but will fail.

D

 The job will inherit the DEFAULT_SCHEDULE schedule.

E

 A schedule object cannot be disabled.

单选题 You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()

A

The tuned plan is not added to the SQL plan baseline.

B

The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C

The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D

The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

单选题 Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()  

A

 AWR baselines are always created as repeating baselines.

B

 AWR baselines can be created on the basis of two time values.

C

 AWR baselines are always created with infinite expiration duration.

D

 AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

单选题 Evaluate the following function code:   CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON (EMPLOYEES) IS avgsal NUMBER(6); BEGIN  SELECT AVG(SALARY)INTO avgsal FROM EMPLOYEES   WHERE DEPARTMENT_ID = dept_id; RETURN avgsal; END get_dept_avg;   Which statement is true regarding the above function?()

A

 The cached result becomes invalid when any structural change is done to the EMPLOYEES table. 

B

 If the function execution results in an unhandled exception,the exception result is also stored in the cache.

C

 Each time the function is invoked in a different session,the current result in the result cache gets overwritten.

D

 If the function is invoked with a different parameter value,the existing result in the result cache gets overwritten by the latest value.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第