Database Administration 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

52 40803
Q:

Rita ? into the cellar.

Which of the following words best suitable in the place of '?'

A) ascended B) rescinded
C) descended D) intended
 
Answer & Explanation Answer: C) descended

Explanation:

Rita descended into the cellar.

Descended means went down. As the cellar is in the basement, she must go down.

Options and meanings :: 

descended  -  went down 

rescinded   - cancelled or annulled

ascended   - went up 

intended    - meant

 

Report Error

View Answer Report Error Discuss

27 40638
Q:

Modern : Antiquated :: Weak : ?

A) Strong B) Fragile
C) Inadequate D) Puny
 
Answer & Explanation Answer: A) Strong

Explanation:

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.

Report Error

View Answer Report Error Discuss

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

27 40451
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 40118
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

180 39219
Q:

If  1 1 1 1 = R
    2 2 2 2 = T
    3 3 3 3 = E
    4 4 4 4 = N

 

Then  5 5 5 5 = ?

A) Y B) Z
C) T D) X
 
Answer & Explanation Answer: A) Y

Explanation:

If you add all the terms of the LHS of equality, then the last letter of the sum written in words would give you the RHS.

1 + 1 + 1 + 1 = 4 = FOUR

2 + 2 + 2 + 2 = 8 = EIGHT

3 + 3 + 3 + 3 = 12 = TWELVE

4 + 4 + 4 + 4 = 16 = SIXTEEN

 

So, following the same pattern.

5 + 5 + 5 + 5 = 20 = TWENTY

 

That gives us our answer to 5 5 5 5 =  "Y".

Report Error

View Answer Report Error Discuss

86 38644
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

110 37312
Q:

Where is RAM located?

A) Mother Board B) Expansion Board
C) External Drive D) None
 
Answer & Explanation Answer: A) Mother Board

Explanation:

RAM is located in The central processing unit (CPU), also called a processor, is located inside the computer case on the motherboard. It is sometimes called the brain of the computer, and its job is to carry out commands.

Report Error

View Answer Report Error Discuss

156 37050