题目内容（请给出正确答案）

[主观题]

TheAutomaticDatabaseDiagnosticMonitor（ADDM）analysisrunsevery60minutesonyourdatabase.Yourda

tabaseisfacingaseriesofinterrelatedproblemsoveraperiodoftwohours.YouneedtoensurethattheADDManalysisisrunoveratimespanoftwohoursinfuture.Whatwouldyoudo？（）

A.CreatetwocustomADDMtasks.

B.ModifytheAWRsnapshottimeintervaltotwohours.

C.Createanewschedulerwindowforatimeperiodoftwohours.

D.ModifytheAutomaticWorkloadRepository（AWR）snapshotretentionperiodtotwohours.

提问人：网友wu28wu28 发布时间：2022-01-07

参考答案

查看官方参考答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装简答题APP，拍照搜题省时又省心！

更多“TheAutomaticDatabaseDiagnostic…”相关的问题

第1题

The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

点击查看答案

第2题

Foranincompleterecovery,whichfourbackuptypescanbeusedbyRecoveryManager(RMAN)torestoredatafiles?()

A.RMANimagecopies.

B.RMANdatabasebackups.

C.RMANtablespacebackups.

D.User-managedbackupsplacedintheflashrecoveryarea.

E.User-managedbackupsthathavebeencatalogedwithRMAN.

F.User-manageddatafilebackupsforwhichthepullpathnameisspecified.

点击查看答案

第3题

Given:Whatistheresult?()

A.Nooutputisproduced.123

B.Nooutputisproduced.234

C.Nooutputisproduced.1234

D.Anexceptionisthrownatruntime.123

点击查看答案

第4题

ClicktheExhibitbutton.Whatistheresult?()

A.Thecodewilldeadlock.

B.Thecodemayrunwithoutput"2064".

C.Thecodemayrunwithnooutput.

D.Thecodemayrunwithoutput"06".

E.Anexceptionisthrownatruntime.

F.Thecodemayrunwithoutput"0246".

点击查看答案

第5题

YouaremanaginganOracleDatabase11gdatabase.Thedatabaseisopen,andyouplantoperformRecoveryManager(RMAN)backups.Whichthreestatementsaretrueaboutthesebackups()

A.Thebackupswouldbeconsistent.

B.Thebackupswouldbeinconsistent.

C.ThebackupswouldbepossibleonlyifthedatabaseisrunninginARCHIVELOGmode.

D.ThebackupswouldbepossibleonlyifthedatabaseisrunninginNOARCHIVELOGmode.

E.Thebackupsneedtoberestoredandthedatabasehastoberecoveredincaseofamediafailure.

点击查看答案

第6题

Initially，fortheAutomaticWorkloadRepository（AWR）statistics，theretentionperiodissetto7days，thecollectionintervalissetto30minutesandthecollectionlevelissettoTypicalinyourproductiondatabase.

YouhavebeenusingtheMemoryAdvisorforthelastthreemonthstogeneraterecommendationsfortuningmemorycomponents.However，whenyouobservetheMemoryAdvisoronaFriday，youfindthatthestatisticsareavailableonlyfortwodays，ThursdayandFriday，ofthatweek.

Whatwouldhavecausedthestatisticstoberemoved？（）

点击查看答案

第7题

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:Which statement should you use to resolve this issue?（）

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B.ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG‘;

点击查看答案

第8题

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)EMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 HR_MGR 5000106 Bryan 40 110 AD_ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EX_DIR 8000120 Ravi 20 110 SA_DIR 6500Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）

A. SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;

B. SELECT e.employee_id "Emp_id", e.emp_name "Employee",

C. salary,

D. employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;

点击查看答案

第9题

You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number data type3. an ORDER_STATUS column that contains a character data type4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today‘s date should be used instead.Which statement accomplishes this?（）

A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

点击查看答案

警告：系统检测到您的账号存在安全风险

为了保护您的账号安全，请在“简答题”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！

微信搜一搜

简答题

点击打开微信

警告：系统检测到您的账号存在安全风险

抱歉，您的账号因涉嫌违反简答题购买须知被冻结。您可在“简答题”微信公众号中的“官网服务”-“账号解封申请”申请解封，或联系客服。

微信搜一搜

简答题

点击打开微信