A: SELECT*FROMCUSTOMER
B: SELECT*CUSTOMER
C: MODIFY*FROMCUSTOMER
D: UPDATE*FROMCUSTOMER
举一反三
- 查询Customer表中所有客户的信息，要求显示CustomerCode、Name、Hometown和Telephone字段信息。语句如下：SELECT _________ FROM Customer
- BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息，SQL语句: SELECT ________ FROM Customer
- 要授予所有用户对表 CUSTOMER 的 SELECT 权限,需用哪个语句? A: GRANT SELECT ON CUSTOMER TO ALL USERS; B: GRANT ALL ON CUSTOMER TO ALL; C: GRANT SELECT ON CUSTOMER TO ALL; D: GRANT SELECT ON CUSTOMER TO PUBLIC;
- 使用语句( )可以更新表中的数据。 A: SELECT B: INSERT C: DELECT D: UPDATE
- 使用语句( )可以删除表中的数据。 A: INSERT B: DELECT C: SELECT D: UPDATE
内容
- 0
使用语句( )可以向表中插入数据。 A: INSERT B: UPDATE C: DELECT D: SELECT
- 1
您的数据库中包含一个名为Customer的表。您需要从Customer表中删除Customer表中删除CustomerID为12345的记录。您应该使用哪个语句？ A: DELETE FROM Customer WHERE CustomerID = 12345 B: DELETE CustomerID FROM Customer WHERE CustomerID = 12345 C: UPDATE Customer DELETE * WHERE CustomerID = 12345 D: UPDATE CustomerID FROM DELETE * CustomerID = 12345
- 2
BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息，要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句： SELECT _________ FROM Customer
- 3
若要从数据库中检索数据，可以将命令对象的commandtext属性设置（）语句。 A: select B: insert C: update D: delete
- 4
假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”，可以使用（）语句。 A: AALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE B: BALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE C: CRENAME TABLE CUSTOMER TO CUSTOMER_CHANGE D: DRENAME TABLE CUSTOMER CUSTOMER_CHANGE