itgle.com

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The

题目

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）

A. The results are not sorted.

B. The results are sorted numerically.

C. The results are sorted alphabetically.

D. The results are sorted numerically and then alphabetically.

相似考题

1.You are creating a DataTable. You use the following code segment to create the DataTable. (Line numbers are included for reference only.)01 DataTable dt = new DataTable(Products”);02 dt.Columns.Add(new DataColumn(Price”, typeof(decimal)));03 dt.Columns.Add(new DataColumn(Quantity”, typeof(Int32)));04 DataColumn dc = new DataColumn(Total”, typeof(decimal));05 dt.Columns.Add(dc);You need to ensure that the Total column is set to the value of the Price column multiplied by the Quantity column when new rows are added or changed. What should you do? （）A. Add the following code segment after line 05. dc.ExtendedProperties["Total"] = "Price * Quantity”;B. Add the following code segment after line 05. dc.Expression = “Prince * Quantity”;C. Write an event handler for the DataTable‘s TableNewRow event that updates the row‘s Total.D. Write an event handler for the DataTable‘s ColumnChanged event that updates the row‘s Total.

2.找出"作者"库表中没有出现在"获奖名单"库表中的所有作者信息的SQL语句,(提示:使用NOT IN,NOT EXISTS,以及外部连接(+)三种方法),并说明那种方法是不优化的出版社: 出版社代码 char(2),出版社名称 varchar2(32)图书: 图书编号 char(8),图书名称 varchar2(128),出版社代码 char(2),作者代号char(4),图书简介 varchar2(128)作者: 作者代号 char(4),作者名称 varchar2(10),性别 char(1),年龄 number(3),文学方向 varchar2(64)获奖名单: 获奖日期 date,获奖人员 char(4)

3.有以下程序include using namespace std;class MyClass{public: MyClass(int n) { nu有以下程序 #include ＜iostream＞ using namespace std; class MyClass { public: MyClass(int n) { number=n; } // 拷贝构造函数 MyClass(MyClass& other) {number=other. number;} -MyClass() {} private: int number; }; MyClass fun(MyClass p) { MyClass temp(p); return temp; } int main() { MyClass obj1(10), obj2(0); MyClass obj3(obj 1); obj2=fun(obj3); return 0; } 程序执行时，MyClass 类的拷贝构造函数被调用的次数是______ 次。A．5B．4C．3D．2

4.Inthedatamodelyoucreatedthisquery:SELECTID_no,description,price,quantity,manufacturer_IDFROMinventoryNextyouclickanddragthemanufacturer_IDcolumnoutofandabovethedefaultgroup.YouneededtosortthechildgroupbyID_number.Howcouldyouaccomplishthistask?（）A.Addanorderbyclausetothequery.B.InthedatamodeldoubleclicktheID_numbercolumnandalterthebreakorder.C.InthelayoutmodeldoubleclicktheID_numberfiledandlatertheprintdirection.D.Defaultthelayout,chooseamaster/detailreportstyleandselectID_numberasthebreakorder.

参考答案和解析
参考答案：D
更多“The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NU ”相关问题

  • 第1题：

    【其它】请完成本次上机实训，将答案保存为图片，然后上传图片！ 解题思路: 1、约束price 字段（浮点类型)的值在1.00-100.00之间的check约束为:price ﹥=1.00 and price ﹤=100.00 2、设置时间默认值，用getdate（)，或用＇2019-12-12＇ 3、唯一键: unⅰque（product_name)


    实训1.doc

  • 第2题：

    23、假定 number=4，下面哪个语句不会出错？

    A．print(format(number, "2d"), format(number ** 1.5, "4d"))

    B．print(format(number, "2d"), format(number ** 1.5, "4.2d"))

    C．print(format(number, "2d"), format(number ** 1.5, "4.2f"))

    D．print(format(number, "2f"), format(number ** 1.5, "4.2d"))


    正确

  • 第3题：

    8、在SQL Server数据库中，有一个产品表products，想按照价格从小到大的顺序显示所有产品的名称（productname）和价格（price），可以实现该功能的T-SQL语句是_______

    A．SELECT productname,price from products order by price ASC

    B．SELECT productname,price from products order by price DESC

    C．SELECT productname,price from products order by price

    D．SELECT productname from products order by price DESC


    C

  • 第4题：

    将students中的列变量重新命名为： （1）id_number, name, gender, score, has_graduate （2）选出Bob的性别gender，并存入变量bob_gender （3）选出列has_graduate，并存入向量status （4）创建数据框part_df，其中包含前三个学生的所有信息 （5）创建数据框rest_df，包含其余学生的所有信息


    AD

  • 第5题：

    16、MySQL数据库中，通常将用户写入对应的权限表来控制访问权限的，以下属于用户权限得选项（）。

    A．User

    B．db

    C．table_priv

    D．columns_priv


    grant;insert

相关内容