Database Administration Questions

SQL statements are broadly classified into three. They are

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Local :

Only available to the current Db connection for current user and are cleared when connection is closed.

Multiple users can’t share a local temporary table.

Global:

Available to any connection once created. They are cleared when the last connection is closed.

Can be shared by multiple user sessions

Dots per inch (DPI, or dpi) is a measure of spatial printing or video or image scanner dot density, in particular the number of individual dots that can be placed in a line within the span of 1 inch (2.54 cm).

ArrayList and LinkedList both implements List interface and maintains insertion order. Both are non synchronized classes.

But there are many differences between ArrayList and LinkedList classes that are given below.

ArrayList    V/s     LinkedList ::

1) ArrayList internally uses dynamic array to store the elements.

                   Whereas

LinkedList internally uses doubly linked list to store the elements.

2) Manipulation with ArrayList is slow because it internally uses array. If any element is removed from the array, all the bits are shifted in memory.

                   Whereas

Manipulation with LinkedList is faster than ArrayList because it uses doubly linked list so no bit shifting is required in memory.

3) ArrayList class can act as a list only because it implements List only.

                   Whereas

LinkedList class can act as a list and queue both because it implements List and Deque interfaces.

4) ArrayList is better for storing and accessing data.

                   Whereas

LinkedList is better for manipulating data.

The distance around a circle is called as Circumference. And that in the case of square or rectangle it is called as Perimeter.

IPv6 - Internet Protocol Version 6.

IPv6 addresses have a size of 128 bits.

Internet Protocol Version 6 [IPv6] is the successor to the Internet's first addressing infrastructure, Internet Protocol version 4 (IPv4).

In contrast to IPv4, which defined an IP address as a 32-bit value, IPv6 address have a size of 128 bits. 

Land is considered as an important resource because it is useful in producing many things. For example, in agriculture, land is used for cultivating the crop, in industrial use, it is used for constructing factories and to make products that we use.