插人默认值
添加数据到一行中的所有列
插入多个行
添加数据到一行中的部分列
单选题The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER 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.
点击查看答案
单选题现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为自增长的标识，使用insert语句向book表中插入数据，以下语句错误的是（）。A insertintobook（id，title，price）values（1，’java’，100）B insertintobook（title，price）values（’java’，100）C insertintobookvalues（’java’，100）D insertbookvalues（’java’，100）
单选题INSERTINTOGoods（Name，Storage，Price）VALUES（’Keyboard’，3000，90.00）的作用是（）。A 插人默认值B 添加数据到一行中的所有列C 插入多个行D 添加数据到一行中的部分列
多选题要在users表中插入一条新记录，下面语句正确的是（）。AInsert Into users（id，user_name） Values（100， luhong）BInsert Into users（real_name，tel） Values（卢红，6545632）CInsert Into users（user_name，Email） Values（luhong， ）DInsert Into users（user_name，Email） Values（luhong， NULL）
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? （）A INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);B INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');C INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));D INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');
单选题要查询book表中所有书名中以“计算机”开头的书籍的价格，可用（）语句。A SELECT price FROM book WHERE book_name=‘计算机*’B SELECT price FROM book WHERE book_nameLIKE‘计算机*’C SELECT price FROM book WHERE book_name=‘计算机%’D SELECT price FROM book WHERE book_nameLIKE‘计算机%’
单选题According to the speaker, how does the price of an electronic keyboard compare with the price of a piano?A The electronic instrument is much more expensive.B The electronic instrument is slightly more expensive.C The piano is slightly more expensive.D The piano is much more expensive.
