Analyst Questions

The given number series is 152, 124, 96, 69, 40

152

152 - 28 = 124

124 - 28 = 96

96 - 28 = 68 (not 69)

68 - 28 = 40

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

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.

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

Here the given series is 123 112 133 112 143

It follows a pattern that,

123

123 - 11 = 112

112 + 21 = 133

133 - 31 = 102 (not 122)

102 + 41 = 143

Hence, the odd man in the given number sequence is 122 instead of 102.

The above given sequence follows a pattern that,

$$\begin{gathered} 1 \\ 22 = 4 \\ 33 = 27 \\ 44 = 256 \\ 55 = 3125 \\ 66 = 46656 \\ and so on... \end{gathered}$$

Therefore, the next two numbers in the given sequence is 256 & 3125.

The given series is 1 6 27 124 650

1

1 + 2 x 2 = 6

6 + 3 x 3 = 27

27 + 4 x 4 = 124

124 + 5 x 5 = 645 (NOT 650)

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

The given number series is 10, 6, 8, 15, ?

10

10 x 0.5 + 1 = 6

6 x 1 + 2 = 8

8 x 1.5 + 3 = 15

15 x 2 + 4 = 34

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