单项选择题

The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?（）
A.randomly
B.ascending by date
C.descending by date
D.ascending alphabetically
E.descending alphabetically

A.randomly
B.ascending
C.descending
D.ascending
E.descending

<上一题目录下一题>

热门试题

单项选择题

You need to change the definition of an existing tablE.The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per valuE.The table contains 20000 rows. Which statement is valid?（）A.ALTER TABLE commercials MODIFY (description CHAR2(1000));B.ALTER TABLE commercials CHANGE (description CHAR2(1000));C.ALTER TABLE commercials CHANGE (description VARCHAR2(1000));D.ALTER TABLE commercials MODIFY (description VARCHAR2(1000));E.You cannot increase the size of a column if the table has rows.

A.ALTER
B.ALTER
C.ALTER
D.ALTER
E.You

单项选择题

在直流电动机时，运行效率最高时应是（） A. 不变损耗与机械损耗相等 B. 铁耗与铜耗相等时 C. 铁耗与磁滞损耗相等时 D. 可变损耗与不变损耗相等

相关试题