单选题What does the TRUNCATE statement do?（）ARemoves the tableBRemoves all rows from a tableCShortens the table to 10 rowsDRemoves all columns from a tableERemoves foreign keys from a table
单选题
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 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.
Which configuration command removes all log filters currently configured on the ERX Edge Router?() A.AB.BC.CD.D
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 TABLEB.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
Which of the following will DELETE all of the rows from table T03?() A.DELETE * FROM TABLE T03B.DELETE ALL FROM T03C.DELETE * FROM T03D.DELETE FROM T03
若要删除book表中所有数据,以下语句错误的是哪两项?() A.delete all from bookB.delete from bookC.truncate table bookD.drop table book
What does the command udld reset accomplish？（）A、allows an UDLD port to automatically reset when it has been shutdownB、resets all UDLD enabled ports that have been shutdownC、removes all UDLD configurations from interfaces that were globally enabledD、removes all UDLD configurations from interfaces that were enabled per-port
ORACLE数据库中如何删除表table中的所有记录，并回收所有空间（）A、delete * from tableB、delete from tableC、truncate tableD、clear table
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 routerB、The peer router immediately removes the BGP routes that it learned from the restarting router from its BGP routing tableC、The restarting router does not remove any stale prefixes after the timer for stale entries expiresD、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 updatesE、The restarting router removes any stale prefixes after the timer for stale entries expires
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.
What are three objectives that the no ip inspect command achieves？（）A、removes the entire CBAC configurationB、removes all associated static ACLsC、turns off the automatic audit feature in SDMD、denies HTTP and Java applets to the inside interface but permits this traffic to the DMZE、resets all global timeouts and thresholds to the defaultsF、deletes all existing sessions
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 filesB、 -remove only removes the program， -purge only removes the config filesC、 -remove removes a package， -purge also removes all packages dependent on itD、 -remove removes only the package file itself， -purge removes all files related to the package
Which of the following will DELETE all of the rows from table T03?（）A、DELETE * FROM TABLE T03B、DELETE ALL FROM T03C、DELETE * FROM T03D、DELETE FROM T03
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 TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
Which of the following functions does the "ifconfig en4 down" perform？（）A、Removes the en4 interfaceB、Removes the en4’s network routeC、Stops all traffic through the en4 interfaceD、Stops all traffic through the en4 and removes its network route from the routing table
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.
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
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.
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.
单选题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 filesB -remove only removes the program， -purge only removes the config filesC -remove removes a package， -purge also removes all packages dependent on itD -remove removes only the package file itself， -purge removes all files related to the package
单选题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？（）AIt removes one or more network adapters from a specified NIC team.BIt removes a team interface from a NIC team.CIt removes a specified NIC team from the host.DIt removes a network adapter member from a switch team.
单选题In a vapor compression refrigeration the evaporating pressure is maintained constant by the action of the （）, which removes vapor from the evaporator at the same rate at which it is formed.AevaporatorBcompressorCcondenserDnone of the above
单选题Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）AIt performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. BIt creates a natural join of tables T1 and T2 for all columns that have the same name. CIt creates a Cartesian product of table T1 and table T2 for all columns that have the same name. DFor each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
单选题Which of the following functions does the "ifconfig en4 down" perform？（）ARemoves the en4 interfaceBRemoves the en4’s network routeCStops all traffic through the en4 interfaceDStops all traffic through the en4 and removes its network route from the routing table
单选题How does the ERX Edge Router interact with subscriber IP addresses assigned by an externa lDHCP server?（）AIt monitors messages from the external server and updates the routing table as needed.BIt maintains the leases for the DHCP server and reassigns addresses to new subscribers.CIt sends keepalives to the subscriber and makes the address available when the subscriber stops responding.DIt sends keepalives to the subscriber and removes the host route when the subscriber stops responding.
单选题What does the TRUNCATE statement do?（）ARemoves the tableBRemoves all rows from a tableCShortens the table to 10 rowsDRemoves all columns from a tableERemoves foreign keys from a table
单选题Which statement is true regarding synonyms?（）ASynonyms can be created only for a table BSynonyms are used to reference only those tables that are owned by another user CA public synonym and a private synonym can exist with the same name for the same table DThe DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
单选题Which of the following will DELETE all of the rows from table T03?（）ADELETE * FROM TABLE T03BDELETE ALL FROM T03CDELETE * FROM T03DDELETE FROM T03
单选题Water is a very effective fire extinguishing agent because it（）Awill remove all the toxic fumes from the airBhas the greatest cooling abilityCwill leave no harmful residueDcompletely removes combustible vapors from the air