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.

Tipu Sultan was the first indian ruler to apply the western methods to his administration. Sultan Fateh Ali Sahab Tipu, also known as the Tipu Sahib, was a ruler of the Kingdom of Mysore. He was the eldest son of Sultan Hyder Ali of Mysore.

Tipu Sultan introduced a number of administrative innovations during his rule, including his coinage, a new Mauludi lunisolar calendar, and a new land revenue system which initiated the growth of the Mysore silk industry.

He was one of the few South Indian kings to provide stiff resistance to British imperialism, along with Hyder Ali. He is applauded as a ruler who fought against British colonialism. Similarly he has been a controversial figure and criticized for his atrocities against Hindus, Christians, and Mappla Muslims.

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.

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.

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.

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

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