Database Administration Questions

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

The given number series follows a pattern that, 4, 15, 37, 81, ?

4

4 + 11 = 15

15 + 22 = 37

37 + 44 = 81

81 + 88 = 169

Hence, the next number in the sequence is 169.

HTML Tag  is used to make a text italic.

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 is 5, 8, 40, 90, 664

5

5 - 1 x 2 = 8

8 - 3 x 4 = 20 (NOT 40)

20 - 5 x 6 = 90

90 - 7 x 8 = 664

The given number series 11, 13, 30, 96, ? follows a pattern that,

11

11 x 1 + 2 = 13

13 x 2 + 4 = 30

30 x 3 + 6 = 96

96 x 4 + 8 = 392

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

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.