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.

A UPS (Uninterruptible Power Supply) is a device that provides battery backup when the electrical power fails or drops to an unacceptable voltage level.

Small UPS systems provide power for a few minutes; enough to power down the computer in an orderly manner, while larger systems have enough battery for several hours.

Deleted files are not permanently removed from the hard drive or the computers memory. Before they are permanently removed from the system they are stored in Recycle Bin. Recycle Bin is a folder or directory where deleted items are temporarily stored. It is also called as trash.

All of the options given are synonyms of RUN.

Hence, Race, Amble, Lope are similar in meaning to the word Run.

AutoSys is an automated job control system for scheduling, monitoring, and reporting. These jobs can reside on any AutoSys-configured machine that is attached to a network.

However, in real business, you need to fire jobs not just based on scheduled time, but also based on events (like an arrival of a file), and, based on the success or failure of other jobs. Autosys is a total job scheduling solution that allows you to define these events, dependencies, time schedules, alerts, etc, making it a complete data center automation tool.

Million Instructions Per Second is a method of measuring the raw speed of a computer's processor. MIPS measures roughly the number of machine instructions that a computer can execute in one second.

The US state California's  economy has surpassed that of the UK to become the world’s fifth largest, according to new federal data released.

With a GDP of $2.7 trillion, California is now only behind the US, China, Japan and Germany.