Database Administration Questions


Q:

A UNION query is which of the following?

A) Combines the output from multiple queries and does not include the same number of columns. B) Combines the output from multiple queries and must include the same number of columns.
C) Combines the output from no more than two queries and does not include the same number of columns. D) Combines the output from no more than two queries and must include the same number of columns.
 
Answer & Explanation Answer: B) Combines the output from multiple queries and must include the same number of columns.

Explanation:

A UNION query combines the output from multiple queries and must include the same number of columns.

Report Error

View Answer Report Error Discuss

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

2 10540
Q:

The two kinds of Main Memory are

A) Random and sequential B) ROM and RAM
C) Primary and secondary D) All the above
 
Answer & Explanation Answer: B) ROM and RAM

Explanation:

The main memory in computers is where the programs and data are kept when the processor is actively using them.

 

The main storage region of a computer is of two kinds. They are ::

 

RAM -- Random Access Memory

 

ROM -- Read Only Memory.

 

The_two_kinds_of_Main_Memory_are1552389409.jpg image

 

The main memory is defined as the central storage in a computer.

Report Error

View Answer Report Error Discuss

11 10329
Q:

Country : President :: State : ?

A) Governor B) Speaker
C) Prime Minister D) Chief Minister
 
Answer & Explanation Answer: A) Governor

Explanation:

The President is the highest officer in the country. Similarly, Governor is the highest officer of the state.

 

Hence, Country : President :: State : Governor.

Report Error

View Answer Report Error Discuss

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

18 10328
Q:

Careful is to Cautious as Boastful is to

A) Surprisingly B) Happily
C) Arrogant D) Humble
 
Answer & Explanation Answer: C) Arrogant

Explanation:

Here the given words Careful and Cautious are related in such a way that they are Synonyms of each other.

Therefore, Similarly Boastful is synonym to the word Arrogant.

Happily and Humble are Antonyms of Boastful and Surprisingly is the word not related to Boastful in any way.

 

So, Careful is to Cautious as Boastful is to Arrogant.

Report Error

View Answer Report Error Discuss

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

7 10278
Q:

Tractor : Trailer :: Horse : ?

A) Saddle B) Engine
C) Cart D) Stable
 
Answer & Explanation Answer: C) Cart

Explanation:

Here the given words are related in such a way that,

Trailer is pulled by Tractor and similarly, Cart is pulled by Horse.

 

Hence, Tractor : Trailer :: Horse : Cart.

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

13 10268
Q:

Solve the Riddle :: Three men were on a boat that was stuck one mile from the shore.

One was afraid of Sharks. The other couldn't Swim. And the last one didn't have a life jacket. However, they reached the shore without any problems. How did they do it?

Answer

They walked and did this.


It was never specified that the boat was at sea. Since this logic is observed by them to tackle situation.

Report Error

View answer Workspace Report Error Discuss

22 10210
Q:

Which is the point from where an azimuth originates?

A) South B) North
C) East D) West
 
Answer & Explanation Answer: B) North

Explanation:

The azimuth originates at true North i.e, the azimuth originates from the north point. It is a measure of how far an object forms the observer's north point.

 

Azimuth is a technical mapping term which is used to describe the direction of an angle between north and south on a compass circle through which the circle line passes. It is the most common military method to express direction. When using an azimuth, the point from which the azimuth originates is the center of an imaginary circle.

Report Error

View Answer Report Error Discuss

8 10139
Q:

Prophet of New India is

A) Dayanand Saraswathi B) Sri Ramakrishna
C) Swamy Vivekananda D) Raja Ram Mohan Roy
 
Answer & Explanation Answer: B) Sri Ramakrishna

Explanation:

Sri Ramakrishna is called as the Prophet of New India.

Sri Ramakrishna (1836-86) mostly known as Ramakrishna Paramhamsa was a spiritual genius now respected in India and abroad as an outstanding saint of our times. His life and thoughts represents the highest and best of modern Hindu philosophy and practice.

Reverence and admiration for him amongst Bengali elites led to the formation of the Ramakrishna Mission by his chief disciple Swami Vivekananda. His devotees look upon him as an incarnation or Avatara of the formless Supreme Brahman as described in the Vedanta while some devotees see him as an avatara of Vishnu.

Report Error

View Answer Report Error Discuss

20 9876