Database Administration Questions

Saw, Zipper and Gear have teeth but can bite us. Comb have teeth but cannot bite.

'Internet' is the shortened form of 'INTERnational-NETwork' which is the interconnected network of all the Web Servers worldwide. It is often called the 'World Wide Web'. 

HTML Tag  is used to make a text italic.

In India, Andhra Pradesh & the Krishna-Godavari Delta region is called as "Rice Bowl of India".

Coming to the Indian State, Chhattisgarh is also known as Rice Bowl of India.

The given number series 2, 19, 0, 21, –2, ? follows a pattern,

2

2 + 17 = 19

19 - 19 = 0

0 + 21 = 21

21 - 23 = -2

-2 + 25 = 23

Hence, the next number in the series is 23.

Magnetic disk is a kind of data storage device. Storage capacity of magnetic disk depends on 

1. tracks per inch of surface

2. bits per inch of tracks

3. disk pack in disk surface

It can be shown as ::

LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}

{PATTERN} often consists of wildcards.

In SQL, there are two wildcards:


% (percent sign) represents zero, one, or more characters.

_ (underscore) represents exactly one character.

More :: Certification Questions on SQL

Rita descended into the cellar.

Descended means went down. As the cellar is in the basement, she must go down.

Options and meanings :: 

descended  -  went down 

rescinded   - cancelled or annulled

ascended   - went up 

intended    - meant