网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
按照姓名降序排列( )
A.ORDER BY DESC NAME
B.ORDER BY NAME DESC
C.ORDER BY NAME ASC
D.ORDER BY ASC NAME
参考答案
更多 “ 按照姓名降序排列( )A.ORDER BY DESC NAMEB.ORDER BY NAME DESCC.ORDER BY NAME ASCD.ORDER BY ASC NAME ” 相关考题
考题
选出正确的关系代数表达式。查询所有“外科”病区和“内科”病区的所有医生姓名； A．σName="外科"∨Name="内科"(π4(Q))B．σName="外科"∧Name="内科"(π4(Q))C．π4(σName="外科"∨Name="内科"(Q))D．π4(σName="外科"∧Name="内科"(Q))
考题
假设需要格式化作者表AUTHOR查询的列信息,将AUTHOR_NAME列名字格式化为“作者编号”,AUTHOR_NAME列名字格式化为“作者名称”,AUTHOR_DESC列名字格式化为“作者简介”,可以使用如下()方式
A.FORMATAUTHOR_IDHEADING’作者编号’FORMATAUTHOR_NAMEHEADING’作者名称’FORMATAUTHOR_DESCHEADING’作者简介’SELECTAUTHOR_ID,AUTHOR_NAME,AUTHOR_DESCFROMAUTHORB.COLUMNAUTHOR_IDHEADING’作者编号’COLUMNAUTHOR_NAMEHEADING’作者名称’COLUMNAUTHOR_DESCHEADIN
考题
假设需要给某个客户表Customer的Customer_name列添加注释信息:客户姓名,可以使用如下()方式
A.COMMENTONTABLECUSTOMERIS'客户姓名'B.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAMEIS'客户姓名'C.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'D.COMMENTONCOLUMNCUSTOMER.CUSTOMER_NAME'客户姓名'
考题
查询内科病区患胃病的病人的姓名。 A．σName="内科"∨SC="胃病"(π2(R))B．σName="内科"∧SC="胃病"(π2(R))C．π2(σName="内科"∨SC="胃病"(R))D．π2(σName="内科"∧SC="胃病"(R))
考题
用途：指定需返回数据的范围语法：SELECT column_name FROM table_nameWHERE column_nameBETWEEN value1 AND value2Order by用途：指定结果集的排序语法：SELECT column-name(s)FROM table-name ORDER BY{order_by_expression[ASC|DESC13.
考题
Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES 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_dateFROM EMPLOYEESORDER BY salary DESC;SELECT last_name, salary, hire_dateFROM EMPLOYEESORDER 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.
考题
已知关系：学生(学号，姓名，年龄)，如果按年龄降序列出所有学生，并且相同年龄的学生按姓名升序排列。则排序子句应该是( )。A．ORDER BY年龄，姓名B．ORDER BY姓名，年龄C．ORDER BY年龄DESC，姓名D．ORDER BY姓名，年龄DESC
考题
如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )()
A. INSTANCE_NAMEB. DB_NAMEC. DB_UNIQUE_NAMED. SERVICE_NAMESE. GLOBAL_NAMES
考题
用print（)函数打印输出姓名的名，即姓名中第一个汉字之后的所有汉字（不考虑复姓的情况更），姓名存储在name中，以下方法正确的是：A．format(name[0])B．format(name[1])C．format(name[1:])D．format(name)
热门标签
最新试卷
