**** 本内容被作者隐藏 ****

**** 本内容被作者隐藏 ****

Which two statements are true about the ORDER BY clause? A) Numeric values are displayed in descending order if they have decimal positions. B) Only columns that are specified in the SELECT list can b ...

Which two statements are true regarding non equijoins? A) The ON clause can be used. B) The USING clause can be used. C) The SQL:1999 compliant ANSI join syntax must be used. D) Table aliases must be ...

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEES_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement: UPDATE employees SET ( ...

Which two statements are true about single row functions? A) CONCAT: can be used to combine any number of values B) FLOOR: returns the smallest integer greater than or equal to a specified number C) C ...

Which three actions can you perform by using the ORACLE DATAPUMP access driver? A) Create a directory object for an external table. B) Read data from an external table and load it into a table in the ...

You want to write a query that prompts for two column names and the WHERE condition each time It is executed in a session but only prompts for the table name the first time it is executed. The variabl ...