Database Administration Questions

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

A Telephone or an Alarm...

The total number of instructions a computer executes per second is called as its processors speed. 

Maximum the processor's speed minimum the time for execution.

A test to determine processor speed is a benchmark.

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.

True, the carbon in the ocean originates from the atmosphere. The oceanic surface water absorbs the carbon dioxide gas from the atmosphere and dissolves in it.

When both sides have won the same number of points then: when each side has won one, or two, points, the score is described as "15-all" and "30-all" (or "15-up" and "30-up"), respectively.

However, if each player has won three points, the score is called as "deuce", not "40–all". From that point on in the game, whenever the score is tied, it is described as "deuce", regardless of how many points have been played.

Satellites orbit the earth at a speed of 28,000 kmph.

Satellites that are further away actually travel slower. The International Space Station has a Low Earth Orbit, about 400 kilometers (250 miles) above the earth's surface. Objects orbiting at that altitude travel about 28,000 kilometers per hour (17,500 miles per hour).

The act of formally approving something is known as Ratification.