Computer Networks

The 'STOP SLAVE' command is the correct MySQL statement to stop replication on a slave server. This command halts the replication SQL thread and/or I/O thread without stopping the entire MySQL service. 'service mysql stop' would stop the entire MySQL server, not just replication.

When connecting to Oracle via SQL*Plus, you must specify the SQL*Plus keyword (command), username, and password. The database name is optional if connecting to a default database or using other connection methods. Options A, B, and C are all required components.

Exadata uses a Unified InfiniBand fabric that serves dual purposes: high-bandwidth, low-latency connectivity for storage traffic AND RAC (Real Application Clusters) private interconnect communication between database nodes. This unified network replaces separate storage and cluster networks.

FXS (Foreign Exchange Station) interfaces connect analog devices like phones to VoIP networks, providing ring voltage and dial tone. FXO is for connecting to PSTN lines, E&M is for trunk connections between PBXs, and E1 is a digital carrier standard, not an analog interface type.

The Sun Datacenter InfiniBand Switch 36 supports Quad Data Rate (QDR) speeds of 40 Gb/sec per link in each direction. Because it is bidirectional, this yields an aggregate bandwidth of 80 Gb/sec per link. Therefore, options a and c are correct statements, while b and d are false.

Ethernet bonding in Linux combines multiple physical network interfaces into a single logical interface for redundancy and increased bandwidth. The bonded interface acts as one interface with failover protection (if one link fails, traffic continues on others) and potential load balancing. Bonding is unrelated to DNS service (A), cable troubleshooting tools (B), or router configuration (C) - it specifically deals with interface aggregation at the network card level.

Heartbeat messages are periodic signals sent between components to verify that communication channels are working and systems are reachable. They specifically test connectivity status rather than functionality, backup completeness, or test success. When heartbeats stop, it indicates a connection failure.

A Local Area Network (LAN) connects computers within a limited geographic area like a single building, office, or campus. LANs enable devices to share resources like printers, files, and internet connections through direct or indirect connections.

VCM stands for Virtual Channel Memory, a memory architecture developed by NEC that allows multiple virtual channels to reduce memory latency by creating separate paths for different types of memory accesses, improving efficiency in multi-tasking environments.

A 'sniffer' is a network analyzer tool that captures and examines network traffic. While Wireshark (formerly Ethereal) is a specific popular sniffer application, 'sniffer' is the generic one-word term for any network analyzer. The term comes from the idea of 'sniffing' or capturing data packets as they travel across the network.

BYNET (Berkeley Networks YNet) is Teradata's proprietary high-speed interconnect that handles all communication and broadcasting between nodes, Parsing Engines (PEs), and Access Module Processors (AMPs). It ensures data is efficiently distributed and retrieved across the system. PE handles parsing, AMP manages data storage, and VDISK is virtual disk storage.

Clique in Teradata is a physical grouping of Nodes (hardware units) that share disk arrays. If one node fails, another node in the clique can take over its AMPs and access the same disk storage. Clique is NOT composed of Gateways, PEs, or AMPs - those are software components running on nodes.

A computer port serves as a physical or virtual interface point that allows the computer to communicate with peripheral devices such as printers, keyboards, mice, and external storage. Ports provide the necessary connection points for data transfer between the computer's internal systems and external hardware components. The other options are incorrect because downloading files requires network connectivity not just a port, communicating with all hard drives uses internal interfaces like SATA/IDE not ports, and connecting computers together typically requires network cards or crossover cables.

DSL (Digital Subscriber Line) provides high-speed internet over standard telephone lines. Unlike dial-up, DSL allows simultaneous internet and voice usage. GUI, HTML, and FTP are unrelated to high-speed internet connection technology.

Grid computing capabilities require physical infrastructure support from hardware vendors (servers, storage, networking equipment) and operating systems (resource management, clustering, virtualization). Hardware provides the physical resources, while operating systems manage and pool these resources. Developers and DBAs work at higher abstraction layers, while network/transport layers are communication protocols, not Grid infrastructure providers.