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? （） -题库考试答案搜索网

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? （）

单选题

2022-02-24 18:22

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.

查看答案

正确答案

A

试题解析

标签： CMS专题 Oracle认证考试 1Z0-007

感兴趣题目

Atmosphere laden with coal dust or grain dust caused by loading these cargoes（）.

Atmosphere laden with coal dust or grain dust caused by loading these cargoes（）.

Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo，without the authorization or privity of the Shipowner or his agent，is（）.

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

A salvor may be（）the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.

The （） is used for hauling in or letting out the wires or ropes.

Vessels must be（）valid certificate of nationality or certificated of registry or license.

When loading or discharging dry mud or cement，crew members should use goggles and（）.

Effects which are dutiable or subject to prohibitions or restrictions should be declared in （）.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

Atmospheres laden with coal dust or grain dust caused by loading these cargoes（）.

逻辑运算符（AND、NOT、OR）的运算顺序是AND→OR→NOT。

相关题目: boost的意思是:help or encourage to increase or improve; eloquent的意思是:fluent or persuasive in speaking or writing; _____ed ucation is the instruction that occurs when the instructor and studen t s are separated by distance or time,or both.; A campus emergency ______ occur at any time of the day or night, weekend, or holiday, with little or no warning.; The attitudes or emotion of a language user in choosing a word and the influence of these on the listener or reader’s interpretation of the word form ___ of a word.; - Does she speak French or German? - She doesn.t, .; People take up hobbies not because these activities offer enjoyment, friendship, knowledge, or relaxation; 阅读下面的句子并选择正确的汉语翻译。目：1 Having a healthy snack on hand, like a granola bar or fruit can help your blood sugar levels and may provide a healthy boost of energy回答 2 Instead of sending an email to your co-worker, walk to her desk or just take the stairs today, even though youre tired回答 3 Moreover, these people may be friends or strangers — people of your own age, or people who are younger or older than you回答 4 People in different countries have different ideas of what sounds friendly, polite or sincere — and of what sounds rude or unfriendly!回答选项：; （）any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local quarantine officer must be notified immediately．; Should any case or suspected case of quarantinable disease，or any case of eruptive disease or any death be discovered，the local Quarantine Officer must be（）immediately.; Masters are（）solely responsible for all damages or accidents of whatever kind resulting from the navigating or handling of their vessels by day or by night.; 系统中雷达状态包括Unknown、Operational（or ON）、Failed（or OFF）、Detached。; The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire，（）the claimant proves that the fire arose from fault or neglect on the part of the carrier，his servants or agents.; Shutdown price（or point，or rule）停业价格（或停业点、停业原则）; I don’t know（）there’s any shortage or not.; 设t=2，b=3，c=4，d=5，则下面语句输出的是（）。 Print3>2*b Or a=c And b<>c Or c>d; 设t=2，b=3，c=4，d=5，则下面语句输出的是（）。 Print3>2*b Or a=c And bc Or c>d; 翻译：With Average or With Particular Average（WA or WPA）（）; These are the principles, however formulated, for which all good men and women throughout the world,（）of race or creed, education, social position, or occupation, are standing.; When latitude and longitude are used，these shall be expressed in（）（and decimals of a minute if necessary），north or south of the Equator and east or west of Greenwich.

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧