可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Given the following query:SELECT last_


Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()

  • ASORT BY age ASC, last_name
  • BSORT BY age DESC, last_name
  • CORDER BY age DESC, last_name
  • DORDER BY age ASC, last_name
参考答案
参考解析:
分类:IBM(000-730)题库
相关推荐

1、Given the following 

Given the following output what course of action should be undertaken for a long ...

2、Given the following requirements: Cre

Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is ...

3、Given the following sc

Given the following scripts, both found in /usr/local/bin, what would the output be when exec...

4、Given the following table definitions

Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O'Neal 6008Carter 50DEPA...

5、Given the following steps, which woul

Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?()1.shutdown immedia...

6、Given the following 

Given the following six method names:(1)addListener(2)addMouseListener (3)setMouseListener(4)deleteMouseListener(5)rem...