单选题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

第1题：

第2题：

ORACLE数据库中如何删除表table中的所有记录，并回收所有空间（）

• A、delete * from table
• B、delete from table
• C、truncate table
• D、clear table

第3题：

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.

第4题：

What is the difference between thE.remove and thE.purge action with the dpkg command？（）

• A、 -remove removes the program， -purge also removes the config files
• B、 -remove only removes the program， -purge only removes the config files
• C、 -remove removes a package， -purge also removes all packages dependent on it
• D、 -remove removes only the package file itself， -purge removes all files related to the package

第5题：

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

第6题：

How does the ERX Edge Router interact with subscriber IP addresses assigned by an external DHCP server?（）

• A、It monitors messages from the external server and updates the routing table as needed.
• B、It maintains the leases for the DHCP server and reassigns addresses to new subscribers.
• C、It sends keep alives to the subscriber and makes the address available when the subscriber stops responding.
• D、It sends keep alives to the subscriber and removes the host route when the subscriber stops responding.

第7题：

Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）

• A、It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. 
• B、It creates a natural join of tables T1 and T2 for all columns that have the same name. 
• C、It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. 
• D、For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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

第16题：

Which of the following will DELETE all of the rows from table T03?（）

• A、DELETE * FROM TABLE T03
• B、DELETE ALL FROM T03
• C、DELETE * FROM T03
• D、DELETE FROM T03

第17题：

Which of the following functions does the "ifconfig en4 down" perform？（）

• A、Removes the en4 interface
• B、Removes the en4’s network route
• C、Stops all traffic through the en4 interface
• D、Stops all traffic through the en4 and removes its network route from the routing table

第18题：

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

第19题：

You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed.You are running a training exercise for junior administrators. You are currently discussing what happens when you run the Remove-NetLbfoTeam Windows PowerShell cmdlet.Which of the following describes the results of running this cmdlet？（）

• A、It removes one or more network adapters from a specified NIC team.
• B、It removes a team interface from a NIC team.
• C、It removes a specified NIC team from the host.
• D、It removes a network adapter member from a switch team.

第20题：

第21题：

第22题：

第23题：

第24题：