数据库xscj中有xs表,下列哪些语句可以执行()A、use xscjB、use xsC、rename table xs to xs1D、rename database xscj to xscj1
数据库xscj中有xs表,下列哪些语句可以执行()
- A、use xscj
- B、use xs
- C、rename table xs to xs1
- D、rename database xscj to xscj1
相关考题:
在当前目录下有数据表文件“XS.dbf”,执行如下SQL语句后( )。 SELECT*FROM XS INTO CURSOR XS ORDER BY 学号A.生成一个按“学号”升序的临时表文件,将原来的XS.dbf文件覆盖B.生成一个按“学号”降序的临时表文件,将原来的XS.dbf文件覆盖C.不会生成新的排序文件,保持原数据表内容不变D.系统提示出错信息
在数据库已打开的情况下,利用SQL命令从学生表中派生出含有“学号”、“姓名”和“年龄”字段的视图,下列语句正确的是A.CREATE VIEW xs_view AS; SELECT学号,姓名,年龄FROM学生表B.CREATE VIEW xs_view; SELECT学号,姓名,年龄FROM学生表C.CREATE VIEW xs_view AS; (SELECT学号,姓名,年龄FROM学生表)D.CREATE VIEW xs_view; (SELECT学号,姓名,年龄FROM学生表)
在当前目录下有数据表文件“Xs.dbf”,执行下列SQL语句后( )。 SELECT*FROM XS INTO CURSOR XS ORDER BY 学号A.生成一个按“学号”升序的临时表文件,将原来的XS.dbf文件覆盖B.生成一个按“学号”降序的临时表文件,将原来的XS.dbf文件覆盖C.不会生成新的排序文件,保持原数据表内容不变D.系统提示出错信息
将Student.dbf表中jg字段的名称改为籍贯,如下选项中正确的SQL语句是A)ALTER TABLE student ALTER COLUMN jg TO籍贯B)ALTER TABLE student ADD籍贯C(10)C)ALTER TABLE student RENAME jg TO籍贯D)ALTER TABLE student RENAME jg籍贯
将Student.dbf表中jg字段的名称改为籍贯,如下选项中正确的SQL语句是( )。A.ALTER TABLE student ALTER COLUMN jg TO 籍贯B.ALTER TABLE student ADD 籍贯 C(10)C.ALTER TABLE student RENAME jg TO 籍贯D.ALTER TABLE student RENAME jg 籍贯
数据库xscj中有xs表,下列( )语句可以执行。A.rename table xs to xs1B.rename database xscj to xscj1C.use xscjD.use xs
数据库xscj中有xs表,下列()语句可以执行。A、use xscjB、use xsC、rename table xs to xs1D、rename database xscj to xscj1
MySQL中修改数据表的名字的命令是()。A、Alter table tablename rename to new_nameB、Alter table tablename rename new_nameC、Rename tablename to newnameD、Rename tablename newname
设有一个表rsda,该表有一个名为zc的字段。如果要把字段名zc改为zhicheng,可以使用下列命令()A、ALTER TABLE rsda RENAME COLUMN zc TO zhichengB、ALTER TABLE rsda RENAME FIELD zc TO zhichengC、ALTER TABLE rsda COLUMN RENAME zc TO zhichengD、ALTER TABLE rsda FIELD zc RENAME TO zhicheng
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()A、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN
假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”,可以使用()语句。A、ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGEB、ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGEC、RENAME TABLE CUSTOMER TO CUSTOMER_CHANGED、RENAME TABLE CUSTOMER CUSTOMER_CHANGE
多选题数据库xscj中有xs表,下列哪些语句可以执行()Ause xscjBuse xsCrename table xs to xs1Drename database xscj to xscj1
多选题数据库xscj中有xs表,下列()语句可以执行。Ause xscjBuse xsCrename table xs to xs1Drename database xscj to xscj1
多选题MySQL中修改数据表的名字的命令是()。AAlter table tablename rename to new_nameBAlter table tablename rename new_nameCRename tablename to newnameDRename tablename newname
单选题假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”,可以使用()语句。AALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGEBALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGECRENAME TABLE CUSTOMER TO CUSTOMER_CHANGEDRENAME TABLE CUSTOMER CUSTOMER_CHANGE