It Week8 Assignment Example | Topics and Well Written Essays - 500 words

It Week8 - Assignment Example However, the old network, IPv4, cannot be done away with until the transition period is complete (Venkata et al., 2012). The benefits that IPv6 offers surpass the limitations that IPv4 has. For instance, the new IPv6 makes it possible to have a plethora of IP addresses as opposed to IPv4. The burgeoning protocol has 128 bit addresses as compared to IPv4, which only has 32 bit addresses. The bit addresses that IPv6 uses enable the availability of numerous IP addresses. In addition to this, IPv6 eradicates the need for network address translation (NAT) which is present in IPv4 resulting in better peer-peer networks connectivity. Further, IPv4 presents security issues, which IPv6 eliminates as it promotes interoperability between myriad implementations (Venkata et al., 2012). Venkata, P., Reddy, P., Mohammed, K., Ali, I., Sandeep, B., & Ravi, T. (2012). Importance and benefits of IPV6 over IPV4†¯: a study. International Journal of Scientific and Research Publications, 2(12), 1-2. Data Definition Language (DDL) refers to statements that define the schema or database structure. For instance, CREATE – creates objects, ALTER – alters the database structure, DROP – deletes objects, COMMENT – adds comments to the dictionary of date, and RENAME – Renames database objects. DML refers to Data Manipulation Language, which are simply statements that manage data within schematic objects. For instance, SELECT – helps in retrieving data, UPDATE – updates data already present in a table, and CALL – Calls Java or PL/SQL. Data Control Language (DCL) includes commands such as GRANT. It mostly deals with permissions, rights, and additional controls of the database. SQL Server 2012 relies on the above SQL commands for interaction. Transact-SQL presents as central in sending and receiving communication with the SQL server (Microsoft, 2006). Distributed File System (DFS) enables administrators to make a group of shared