单项选择题
The EMP table contains these columns:
EMPLOYEE_ID NUMBER(4)
EMPNAME VARCHAR2 (25)
SALARY NUMBER(9,2)
HIRE_DATE DATE
You query the database with this SQL statement:
SELECT empname,hire_date HIREDATE, salary
FROM EMP
ORDER 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
相关考题
-
单项选择题
Which is an iSQL*Plus command?（）
A.INSERT
B.UPDATE
C.SELECT
D.DESCRIBE
E.DELETE
F.RENAME -
单项选择题
Which iSQL*Plus feature can be used to replace values in the WHERE clause?（）
A.substitution variables
B.replacement variables
C.prompt variables
D.instead-of variables
E.This feature cannot be implemented through iSQL*Plus. -
多项选择题
Which four statements correctly describe functions that are available in SQL? （）
A.INSTR returns the numeric position of a named character.
B.NVL2 returns the first non-null expression in the expression list.
C.TRUNCATE rounds the column, expression, or value to n decimal places.
D.DECODE translates an expression after comparing it to each search value.
E.TRIM trims the heading or trailing characters (or both) from a character string.
F.NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
G.NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
