IT Trainer Questions


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 36823
Q:

Choose the word which gives similar meaning to the given word from the following options.

'Autopsy'

A) Diagnosis B) Rebuild
C) Manufacture D) Postmortem
 
Answer & Explanation Answer: D) Postmortem

Explanation:

Autopsy is the medical term for postmortem.

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 , IT Trainer , Network Engineer , Project Manager

18 36317
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 35702
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 35455
Q:

Cup : Lip :: Bird : ?

A) Grass B) Forest
C) Beak D) Bush
 
Answer & Explanation Answer: A) Grass

Explanation:

Cup is used to drink something with the help of lips. Similarly, birds collect grass with the help of beak to make her nest.

 

Hence, Cup : Lip :: Bird : Grass.

Report Error

View Answer Report Error Discuss

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

85 35425
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 34656
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 34615
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 34498