Database Administration Questions

Here the given number series is 270, 261, 279, 252, 289, 243

270 - 9 = 261

261 + 18 = 279

279 - 27 = 252

252 + 36 = 288 (not equals to 289)

288 - 45 = 243

Hence, the odd number in the given number series is 289.

Given Transition is to Change, and we know that Transition and change are Synonyms. Similarly, Immobility means not moving and synonym of immobility are motionlessness, stillness,...

Hence, Transition is to change as immobility is to stillness.

The given number series is 

71      88       113       150       203          277

   +17    +25       +37      +53        +74

        +8      +12        +16       +21

            +4          +4         +5

The series should be  71  88  112   150    203   276 i.e, the differences of the difference should be +4.

Hence, the odd man in the given series is 277.

The given series 16, 254, 1296, 4096, 10000 follows a pattern that

24, 44, 64, 84, 104,...

Hence, the odd man in the series is 4 x 4 x 4 x 4 = 256 not 254.

Modern is used to refer to something new whereas antiquated is used with respect to something old.

In other words, both terms are the opposite of each other.

From the above analysis, the missing word should be a word that represents the opposite of weak. Strong is used to with great influence. Therefore, the apt word is strong or any synonym of strong like potent, powerful, keen,...

Hence, Modern : Antiquated :: Weak : Strong.

Here Thread and String are Synonyms of each other. Then the answer will be the synonym of Cask. 

• Cask is nothing but a large barrel-like container used for storing liquids, typically alcoholic drinks. 

Ex : Drum, Vessel, Tank, Barrel, Hogshead, Firkin,...

• Here from the options Barrel is the only synonym of Cask.

Thus,  Thread : String :: Cask : Barrel

Given number sequence is 28, 16, 28, 76, 274

Here the sequence follows a pattern that

28

28 x 0.5 + 2 = 14 + 2 = 16

16 x 1.5 + 4 = 24 + 4 = 28

28 x 2.5 + 6 = 70 + 6 = 76

76 x 3.5 + 8 = 266 + 8 = 274

274 x 4.5 + 10 = 1233 + 10 = 1243

Hence, the next number in the given number sequence is 1243.

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