Database Administration Questions


Q:

One word substitution:

Commencement of words with the same letter.

A) Alliteration B) Oxymoron
C) Pun D) Transferred epithet
 
Answer & Explanation Answer: A) Alliteration

Explanation:

Alliteration is the one-word substitute for Commencement of words with the same letter.

 

Alliteration is a figure of speech which is identified as the occurrence of the same letter or sound at the beginning of adjacent or closely connected words.

Report Error

View Answer Report Error Discuss

25 37167
Q:

Which operator performs pattern matching ?

A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these
 
Answer & Explanation Answer: A) LIKE operator

Explanation:

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

Report Error

View Answer Report Error Discuss

27 36771
Q:

Complete the Analogy?

 

Grain : Stock :: Stick : ?

A) Bundle B) String
C) Collection D) Heap
 
Answer & Explanation Answer: A) Bundle

Explanation:

Here the relation between the given words is that the second word is the collection of the first word.

As the collection of grains is called Stock, similarly, the collection of sticks is called as Bundle.

 

Hence, Grain : Stock :: Stick : Bundle.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

17 36061
Q:

Transition : Change :: Immobility :  ?

A) Stillness B) Liveliness
C) Action D) Busyness
 
Answer & Explanation Answer: A) Stillness

Explanation:

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.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

36 35345
Q:

One word substitute :

a person who abstains from alcoholic drinks

A) Teetotaller B) Heretic
C) Angler D) Drunkard
 
Answer & Explanation Answer: A) Teetotaller

Explanation:

A person who practices teetotalism i.e abstains from all kinds of alcoholic drinks is called a teetotaller or is simply said to be teetotal.

Report Error

View Answer Report Error Discuss

50 35114
Q:

11 P in a CT

Answer

The given letter equation implies that 11 P in a CT means 11 Players in a Cricket Team.

Report Error

View answer Workspace Report Error Discuss

106 34590
Q:

Which of the following is a popular programming language for developing multimedia webpages.

A) COBOL B) Java
C) BASIC D) Assembler
 
Answer & Explanation Answer: B) Java

Explanation:

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.

 

Which_of_the_following_is_a_popular_programming_language_for_developing_multimedia_webpages1548652333.jpg image


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

Report Error

View Answer Report Error Discuss

152 34390
Q:

Thread is to String as Cask is to

A) Barrel B) Disc
C) Wallet D) Box
 
Answer & Explanation Answer: A) Barrel

Explanation:

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

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

45 34331