Which is an /SQL*Plus command?（）..

第1题

[多选题] Which two statements are true regarding the SQL Repair Advisor?（）

A、The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. B、The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. C、The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. D、The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

点击查看答案

第2题

[单选题] 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.

点击查看答案

第3题

[单选题] 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.

点击查看答案

第4题

[单选题] Which is an /SQL*Plus command? （）

A、INSERT B、UPDATE C、SELECT D、DESCRIBE E、DELETE F、RENAME

点击查看答案

第5题

[] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（） You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、A.
B.
C.
D.

点击查看答案

第6题

[单选题] At an unsheltered anchorage the chief engineer officer shall consult with the master whetheror not to maintain an underway watch“An underway watch” means（）

A、a watch which is kept with lower standard B、a watch which is kept when the ship isnt sailing C、a watch which is kept when the ship is sailing D、a watch which is kept when the ship is in a restricted visibility area

点击查看答案

第7题

[] Which is an /SQL*Plus command?（）

A、A. INSERT B、B. UPDATE C、C. SELECT D、D. DESCRIBE E、E. DELETE F、F. RENAME

点击查看答案

第8题

[单选题] The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

A、statistics recommendations B、SQL Profile recommendations C、Index-related recommendations D、restructuring of SQL recommendations

点击查看答案

第9题

[多选题] You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）

A、SYS, SYSTEM B、SCOTT C、Only for successful executions D、Only for failed executions E、Both successful and failed executions

点击查看答案

Which is an /SQL*Plus command?（）

请使用微信扫码支付