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

[主观题]

You find this query being used in your Oracle 12c database:Which method a used by the optimizer to limit the rows being returned？（）

A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

D. A TOP-N query is created to limit the rows to 20 percent of the total rows

查看答案

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

您可能会需要：

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

安装赏学吧APP，拍照搜题省时又省心！

更多“You find this query being used…”相关的问题

第1题

You want to create a list of all purchase orders for which you have not yet received

an invoice.What can you use to find these specific purchase orders when entering your criteria for the search query？ Please choose the correct answer.()

A.Scope of list

B.Breakdown

C.Layout

D.Selection parameter

点击查看答案

第2题

Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query？（）

Examine the structure of the EMPLOYEES, DEPARTMENT

A. To find the tax percentage for each of the employees.

B. To list the name, job id, and manager name for all the employees.

C. To find the name, salary, and department name of employees who are not working with Smith.

D. To find the number of employees working for the Administrative department and earning less then 4000.

E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

点击查看答案

第3题

Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query？（）

Click the Exhibit button to examine the structures

A.to find the tax percentage for each of the employees

B.to list the name, job_id, and manager name for all the employees

C.to find the name, salary, and the department name of employees who are not working with Smith

D.to find the number of employees working for the Administrative department and earning less than 4000

E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned

点击查看答案

第4题

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other tabl

e with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL＞ FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement？（）

You plan to use Flashback Drop feature to recover

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

第5题

Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.EMPLOYEESNOT NULL, Pri

maryEMPLOYEE_ID NUMBERKeyVARCHAR2EMP_NAME(30)VARCHAR2JOB_ID(20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT_IDcolumn ofthe DEPARTMENTStableDEPARTMENTSNOT NULL,DEPARTMENT_ID NUMBERPrimary KeyVARCHAR2DEPARTMENT_NAME|30|ReferencesMGR_ID columnMGR_ID NUMBERof theEMPLOYEES tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERFor which situation would you use a nonequijoin query？（）

A. To find the tax percentage for each of the employees.

B. To list the name, job id, and manager name for all the employees.

C. To find the name, salary, and department name of employees who are not working with Smith.

D. To find the number of employees working for the Administrative department and earning less then 4000.

E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

点击查看答案

第6题

You are the network administrator for TestKing.com. The network contains two Windows Serve

r 2003 computers named TestKing7 and TestKing8. You install a new modem on TestKing7 to allow an application to dial out to your pager. You install the driver. When you test the modem, it does not dial outsuccessfully. You install an identical hardware and driver configuration on TestKing2, and the modem dials out successfully.You need to find out if the modem card in TestKing7 is defective.What should you do on TestKing7？（）

A. In Device Manager, right-click the modem, and then click Scan for hardware changes.

B. In Modem Properties, click the Modem tab, and then set the maximum port speed to the same value as the value for the maximum port speed on TestKing8.

C. In Modem Properties, click the Diagnostics tab, and then click the Query Modem button.

D. In Device Manager, right-click Ports, and then click Scan for hardware changes.

点击查看答案

第7题

ROW-based replication has stopped working. You investigate the error log file and find the

following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START".We stopped at log ‘56_masterbin. 000003‘ position 684 Why did you receive this error？（）

A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B.The table definition on the slave -litters from the master

C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates

D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

点击查看答案

第8题

Youarelookingforanexecutablefilefoo.Selectthecommandthatwouldsearchforfoowithindirectoriessetintheshellvariable，PATH.（）

A.locate

B.which

C.find

D.query

E.whereis