1Z0-007
单选题What does the TRUNCATE statement do?（）A Removes the tableB Removes all rows from a tableC Shortens the table to 10 rowsD Removes all columns from a tableE Removes foreign keys from a table
题目
Removes the table
Removes all rows from a table
Shortens the table to 10 rows
Removes all columns from a table
Removes foreign keys from a table
参考答案和解析
相似问题和答案
第1题：
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?（）
A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
B.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
C.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
D.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
第2题：
A.delete all from book
B.delete from book
C.truncate table book
D.drop table book
参考答案：BC
第3题：
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）
A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.
B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.
C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
第4题：
In which two ways does the BGP graceful capability preserve prefix information during a restart？（）
- A、The peer router immediately removes the BGP routers that it learned from the restarting router from itsBGP routing tables.
- B、The router establishes BGP sessions with other routers and relearns the BGP routes from others that are also capable of graceful restart. The restarting router waits to receive updates from the neighboringrouters. When the neighboring routers send end-of-RIB messages to indicate that they are donesending updates，the restarting router starts sending its own updates.
- C、The peer router sends an end-of-RIB message to the restarting router.
- D、The restarting router removes any stale prefixes after the timer for stale entries expires.
- E、The restarting router does not remove any stale prefixes after the timer for stale entries expires.
正确答案:B,D
第5题：
ORACLE数据库中如何删除表table中的所有记录，并回收所有空间（）
- A、delete * from table
- B、delete from table
- C、truncate table
- D、clear table
正确答案:C
第6题：
A.DELETE * FROM TABLE T03
B.DELETE ALL FROM T03
C.DELETE * FROM T03
D.DELETE FROM T03
第7题：
What does the command udld reset accomplish？（）
- A、allows an UDLD port to automatically reset when it has been shutdown
- B、resets all UDLD enabled ports that have been shutdown
- C、removes all UDLD configurations from interfaces that were globally enabled
- D、removes all UDLD configurations from interfaces that were enabled per-port
正确答案:B
第8题：
A.A
B.B
C.C
D.D
第9题：
In which two ways does the BGP graceful restart capability preserve prefix information during a restart？（）
- A、The peer router sends an end-of RIB message to the restarting router
- B、The peer router immediately removes the BGP routes that it learned from the restarting router from its BGP routing table
- C、The restarting router does not remove any stale prefixes after the timer for stale entries expires
- D、The router establishes BGP sessions with other routers and relearns the BGP routes from other routers that are also capable of graceful restart. The restarting router waits to receive updates from the neighboring routers. When the neighboring routers send end-of-RIB messages to indicate that they are done sending updates， the restarting router starts sending its own updates
- E、The restarting router removes any stale prefixes after the timer for stale entries expires
正确答案:D,E
第10题：
What are three objectives that the no ip inspect command achieves？（）
- A、removes the entire CBAC configuration
- B、removes all associated static ACLs
- C、turns off the automatic audit feature in SDM
- D、denies HTTP and Java applets to the inside interface but permits this traffic to the DMZ
- E、resets all global timeouts and thresholds to the defaults
- F、deletes all existing sessions
正确答案:A,E,F