Database Administration Questions


Q:

Fastest Shorthand Writer was

A) Dr. G. D. Bist B) J.R.D. Tata
C) J.M. Tagore D) Khudada Khan
 
Answer & Explanation Answer: A) Dr. G. D. Bist

Explanation:

Dr. G. D. Bist, Guinness Record Holder, the first-ever Ph.D. in Stenography in the world.

 

He had achieved a highest speed of 250 w.p.m. in Shorthand.

Report Error

View Answer Workspace Report Error Discuss

275 47132
Q:

Which region in India is known as the "Rice Bowl of India"?

A) Indo-Gangetic plain B) Krishna-Godavari Delta region
C) North-East region D) Kerala and Tamil Nadu
 
Answer & Explanation Answer: B) Krishna-Godavari Delta region

Explanation:

In India, the Krishna-Godavari Delta region is called as "Rice Bowl of India".

 

Coming to the Indian State, Chhattisgarh is known as Rice Bowl of India.

Report Error

View Answer Workspace Report Error Discuss

96 25097
Q:

The Hardest Logic Puzzle Ever?

If a giraffe has two eyes, a monkey has two eyes, and an elephant has two eyes, how many eyes do we have?

A) 3 B) 4
C) 1 D) 2
 
Answer & Explanation Answer: B) 4

Explanation:

4 eyes.

Here in the question, it is asked how many Eyes We have so that means here the person who has asked the question is also including the person who is suppose to give the answer. In a clear understanding, the Conversation is happening between 2 people 1st who asked the question and 2nd to whom it has been asked, which means there are 4 eyes.

Report Error

View Answer Workspace Report Error Discuss

83 16706
Q:

Fumble is to Finesse as Malign is to

A) Slander B) Extol
C) Criticize D) Assurance
 
Answer & Explanation Answer: B) Extol

Explanation:

Fumble means grope, mishandle, drop, mistake, blunder, bungle.

Finesse means skill, grace, elegance, assurance, diplomacy, discretion.

So, they are opposites.

 

Similarly,

Malign means slander or criticize.

Extol means being kind or good-natured. A person without finesse often fumbles. A person without extol in his heart often maligns.

Extol means praise or exalt, benevolence

Report Error

View Answer Workspace Report Error Discuss

13 14401
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 Workspace Report Error Discuss

8 12955
Q:

The famous Rock Garden is located in which city?

A) Jaipur B) Simla
C) Lucknow D) Chandigarh
 
Answer & Explanation Answer: D) Chandigarh

Explanation:

The famous Rock Garden which is also known as Nek Chand's Rock Garden after its founder Nek Chand, a government official who started the garden secretly in his spare time in 1957 is in the city Chandigarh.

 

The Rock Garden of Chandigarh is a sculpture garden in Chandigarh, India.

Report Error

View Answer Workspace Report Error Discuss

50 12778
Q:

5 C in an OF?

A) 5 Cards in an Old Fan B) 5 Circles in an Olympic Flag
C) 5 Colors in an Old Football D) 5 Colors in an Old Flag
 
Answer & Explanation Answer: B) 5 Circles in an Olympic Flag

Explanation:

5 C in an OF denotes 5 Circles in an Olympic Flag.

These are riddles of type

12 S of the Z

52 W in a Y.

Report Error

View Answer Workspace Report Error Discuss

49 12471
Q:

 Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

 

Purpose of SQL are ::

* To define the data structures

* To specify the syntax and semantics of SQL manipulation language

* To specify the syntax and semantics of SQL data definition language

Report Error

View Answer Workspace Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

11 11013