Database Administration Questions

The given number series is 35, 36, 55, 111, ?

35

35 x 1 + 1 = 36

36 x 1.5 + 1 = 55

55 x 2 + 1 = 111

111 x 2.5 + 1 = 278.5

Hence, the next number in the given number series is 278.5.

HTML Tag  is used to make a text italic.

Here the given series 222, 271, 308, 332, 348, 357 follows a pattern that

222

222 + 49  271

271 + 36 = 307 (NOT 308)

307 + 25 = 332

332 + 16 = 348

348 + 9 = 357

Hence, the odd man in the fiven number series is 308.

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

The given number series follows 5, 4, 9, 32, 308 pattern that

5

5 x 1 - 1 = 4

4 x 3 - 3 = 9

9 x 5 - 5 = 40 (not equals to 32)

40 x 7 - 7 = 273

Hence, the odd man in the given number series is 32.

Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible.

Java is used to develop mobile apps, web apps, desktop apps, games and much more...