The ship being shown is USS Arleigh Burke (DDG-51).
The ship shown is the lead ship in the Arliegh Burke class (USS Arliegh Burke DDG - 51) but is called Daniel Boone in the show. The actual Daniel Boone is a submarine (SSBN - 629).
In the episode the electronic warfare system (EWS) being used on the U.S.S. Daniel Boone is called Ares, named after the god of war in Greek mythology. The actual EWS used on Arleigh Burke-class guided missile destroyers is called the Aegis Combat System (ACS), whose name also comes from Greek mythology, the shield used by Zeus is called Aegis. The ACS was first deployed on the U.S.S. Ticonderoga (CG-47), launched on April 25, 1981 she is the lead boat of the Ticonderoga-class guided missile cruisers. The ACS was initially developed by RCA and was acquired by Lockheed Martin in 1995, the company's description of its function is: "The Aegis Combat System (ACS) is an advanced command and control (command and decision, or C&D, in Aegis parlance) system that uses powerful computers and radars to track and guide weapons to destroy enemy targets." The ACS is what allows guided missile cruisers and destroyers to hit targets and shoot down missiles with such high degrees of accuracy. In 2009 Lockheed Martin released a new edition to the ACS called the Aegis Ballistic Missile Defense System which is being installed on the Flight IIA and Flight III versions of the Arleigh Burke-class guided missile destroyers making them effective anti-ballistic missile and anti-satellite weapon platforms. It's largely because of the Aegis Combat System and the Aegis Ballistic Missile Defense System that the Flight IIA and Flight III Arleigh Burke-class guided missile destroyers are considered to be the most powerful and most versatile warships in the world.
The Aegis Combat System, the real life electronic weapons system the Ares is based on, is capable of automatically controlling and firing a warship's weapons systems, although in most cases fire control still rests with an actual person, the only time fire control is turned over to the computer is when the ship is facing threats from multiple vectors, which would take too much time for a human to target and fire on. However it does not have the ability to take over the helm or navigate the ship, nor can it lock down areas of a ship.
A seacock is a valve on the hull of a ship that allows water to flow into the ship, typically for purposes of engine cooling or for salt water faucets; they also can be used to pump water out of a ship such as the drainage from sinks and toilets or to pump water out from a leak or hull breech. Warships also have special types of seacocks that are designed to rapidly flood the ship when opened, this is done for several reasons. The magazine room on a warship has several large valves that are used to flood the room in the event of a fire in order to prevent the detonation of ammunition and ordinance. If a warship is damaged and has taken on water this can cause the ship to become off balance, once the flooded sections have been sealed other sections can be sealed and flooded intentionally to act as a counterbalance. Warships typically also have extremely large valves to flood key areas of the ship in order to scuttle it, this causes the ship to rapidly sink and prevents it from falling into enemy hands.