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 9961
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 9940
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

10 9826
Q:

Exercise is to Gym as Eating is to

A) Dieting B) Fitness
C) Restaurent D) Food
 
Answer & Explanation Answer: C) Restaurent

Explanation:

The given words are related in such a manner that, for exercise we go to gym. Simmilarly, for eating we go to restaurent.

 

Hence, Exercise : Gym :: Eating : Restaurent.

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

8 9786
Q:

The computer that process both analog and digital is called

A) Hybrid computer B) Mainframe computer
C) Digital computer D) Analog computer
 
Answer & Explanation Answer: A) Hybrid computer

Explanation:

The computer that process both analog and digital is called Hybrid computer.

Report Error

View Answer Report Error Discuss

6 9726
Q:

Folder is to document as envelope is to

A) Money B) Articles
C) Letters D) Wires
 
Answer & Explanation Answer: C) Letters

Explanation:

We know that, a folder holds documents in the same way an envelope holds letters.

 

Hence, Folder : Document :: Envelope : Letter.

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

3 9711
Q:

Who is making the web standards?

A) Internet Explorer B) Netscape Navigator
C) The World Wide Web Consortium D) All of the above
 
Answer & Explanation Answer: C) The World Wide Web Consortium

Explanation:

Web standards are rules and guidelines established by the World Wide Web Consortium ( W3C ) developed to promote consistency in the design code which makes up a web page.

 who_is_making_the_web_standards1557557101.jpg image

 

W3C is an international community of member organizations created in 1994 that articulates web standards so that websites look and work the same in all web browsers.

 

Its mission is to lead the World Wide Web to its full potential.

Report Error

View Answer Report Error Discuss

7 9638
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 9561