Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）A、The two statements produce identical results.B、The second statement returns a syntax error.C、There is no need to specify DESC because the results are sorted in descending order by default.D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）
- A、The two statements produce identical results.
- B、The second statement returns a syntax error.
- C、There is no need to specify DESC because the results are sorted in descending order by default.
- D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
相关考题：
Which two are attributes of ／SQL*Plus? () A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.() A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?（）A. All of the desired resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement
Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?() A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product
Evaluate these two SQL statements:What is true about them?() A. The two statements produce identical results.B. The second statement returns a syntax error.C. There is no need to specify DESC because the results are sorted in descending order by default.D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
By default, which two statements are true about export routing polices?() A. Export polices can evaluate only active routesB. Export polices can evaluate all routesC. Export polices can be applied to the forwarding tableD. Export polices can be applied to interfaces
By default, which two statements are true about export routing policies?（）A、Export policies can evaluate only active routes.B、Export policies can evaluate all routes.C、Export policies can be applied to the forwarding table.D、Export policies can be applied directly to interfaces
Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)A、It contains only SQL profiles generated by SQL Tuning Advisor.B、It stores plans generated by the optimizer using a stored outline.C、It is part of the data dictionary and stored in the SYSAUX tablespace.D、It is part of the data dictionary and stored in the SYSTEM tablespace.E、It contains the statement log, the plan history, plan baselines, and SQL profiles.
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）A、The two statements produce identical results.B、The second statement returns a syntax error.C、There is no need to specify DESC because the results are sorted in descending order by default.D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A、0B、1C、0.00D、An error statement
Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）A、Cursor cacheB、Stored outlineC、SQL Tuning SetD、Automatic Workload Repository (AWR) snapshots
Which two are attributes of iSQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accessed from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）A、one SQL Server 2005 computer with one instanceB、two SQL Server 2005 computers， each with two instancesC、two SQL Server computers， one with one instance and one with three instancesD、one SQL Server 2005 computer with two instances
Which two are attributes of /SQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
多选题Which two are attributes of /SQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
多选题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
多选题By default, which two statements are true about export routing polices?（）AExport polices can evaluate only active routesBExport polices can evaluate all routesCExport polices can be applied to the forwarding tableDExport polices can be applied to interfaces
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A16 B100 C160 D200 E150
单选题Evaluate the following command： SQL CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（）A The LOB values are automatically compressed.B The LOB values are cached by default in the buffer cache.C The LOB values are automatically stored in encrypted mode.D All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
多选题By default, which two statements are true about export routing policies?（）AExport policies can evaluate only active routesBExport policies can evaluate all routesCExport policies can be applied to the forwarding tableDExport policies can be applied directly to interfaces
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A0B1C0.00DAn error statement
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）Aone SQL Server 2005 computer with one instanceBtwo SQL Server 2005 computers， each with two instancesCtwo SQL Server computers， one with one instance and one with three instancesDone SQL Server 2005 computer with two instances
单选题Evaluate these two SQL statements: What is true about them?（）A The two statements produce identical results.B The second statement returns a syntax error.C There is no need to specify DESC because the results are sorted in descending order by default.D The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.