更多"delete from system.table1与truncate "的相关试题:
[多项选择]关于DELETE和TRUNCATE TABLE的说法，正确的是（）。
A. 两者都反回被删除记录的数目
B. 两者都可以删除指定条目的记录
C. 前者返回被删除记录数目，后者不返回
D. 前者可以删除指定条目的记录，后者不能
[判断题]DELETE TABLE的功能是删除表结构。
[多项选择]Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
[单项选择]What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B. The rows in the table are truncated without being archived.
C. The rows in the table are archived, and then truncated.
D. The rows in both the table and the archive are truncated.
[多项选择]Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
[简答题]数据库命令delete和truncate区别是什么？
[单项选择]在Access中，运行SQL命令"delete*from类别"后，得到的结果是（）
A. 复制"类别"表中所有的记录
B. 删除"类别"表中所有的记录
C. 修改"类别"表中所有的记录
D. 查询"类别"表中所有的记录
[单项选择]在Access中，运行SQL命令"delete*from订单"后，得到的结果是（）
A. 复制"订单"表中所有的记录
B. 删除"订单"表中所有的记录
C. 修改"订单"表中所有的记录
D. 查询"订单"表中所有的记录
[单项选择]在Access中，运行SQL命令"delete*from订单where订单ID=10257"后，得到的结果是（）
A. 复制订单ID为10257的记录
B. 删除订单ID为10257的记录
C. 修改订单ID为10257的记录
D. 查询订单ID为10257的记录
[多项选择] You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
A. Each extra column in the copy with more columns must not have a default value
B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C. The slave database cannot have more columns than the master. Only the master database can have more columns
D. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
[单项选择]运行SQL命令“Delete*From比赛成绩Where姓名＝李勇”，得到的结果是（）。
A. 删除“比赛成绩”表中的所有记录
B. 删除“比赛成绩”表中姓名为“李勇”的记录
C. 删除“比赛成绩”表中的“李”的所有记录
D. 查询“比赛成绩”表中姓名为“李勇”的记录
[判断题]在SQL语句中，使用TRUNCATE删除数据要比DELETE删除数据速度快，而且删除后的数据也很可以很方便恢复。
[单项选择]SQL语句“delete from department”，需要SqlCommand对象的哪一个方法在执行（）。
A. ExecuteNonQuery（）
B. ExecuteScalar（）
C. ExecuteReader（）
D. ExecuteXmlReader（）
[单项选择] 有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;
A. emp表中数据处于回滚段中
B. emp表中的数据被永久删除
C. emp表中的数据没有变化
D. 原来的emp表中的数据被添加到新emp表中
E. 以上所述都不正确
[单项选择]What does the TRUNCATE statement do?（）
A. Removes the table
B. Removes all rows from a table
C. Shortens the table to 10 rows
D. Removes all columns from a table
E. Removes foreign keys from a table
[多项选择] Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? （）
A. Deleting the records of employees who do not earn commission.
B. Increasing the commission of employee 3 by the average commission earned in department 20.
C. Finding the number of employees who do NOT earn commission and are working for department 20.
D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.
E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
[判断题]执行完Delete From users语句后，共删除10条记录。（）
[单项选择] You delete content from a file named Speed.doc that is stored in the C:///Data folder. You edit 20 files in this folder over the next two days. You need to restore the version of the file that had the correct data. You also need to ensure that the other files in the folder remain unaffected. What should you do？ （）
A. From the Previous Versions tab， restore the version of the file that contains the correct data.
B. Restore a version of the folder that contains the correct version of the file.
C. Open a version of the folder that contains the correct version of the file.
D. Copy a version of the folder that contains the correct version of the file. Replace the existing version of the folder with the older version.
