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

考题 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？（）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.

查看答案

考题单选题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.A evaporatorB compressorC condenserD none of the above

查看答案

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

查看答案

考题单选题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 externa lDHCP 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 keepalives to the subscriber and makes the address available when the subscriber stops responding.D It sends keepalives 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

查看答案

考题单选题Which statement is true regarding synonyms?（）A Synonyms can be created only for a table B Synonyms are used to reference only those tables that are owned by another user C A public synonym and a private synonym can exist with the same name for the same table D The 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?（）A DELETE * FROM TABLE T03B DELETE ALL FROM T03C DELETE * FROM T03D DELETE FROM T03

查看答案

考题单选题Water is a very effective fire extinguishing agent because it（）A will remove all the toxic fumes from the airB has the greatest cooling abilityC will leave no harmful residueD completely removes combustible vapors from the air

查看答案

网友您好，请在下方输入框内输入要搜索的题目：

更多 “单选题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” 相关考题

网友您好， 请在下方输入框内输入要搜索的题目：

更多 “单选题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” 相关考题

网友您好，请在下方输入框内输入要搜索的题目：