Database Administration Questions


Q:

The following bar graph shows the percentage of chairs produced by two companies Neel Kamal and Raj Kamal during five different years. Bar graph also shows the total no. of chairs produced in different years associated with it. Study the graph carefully to answer the following questions.

bar_g1527828671.jpg image

Question 1)  Find the average no. of chairs produced by Raj Kamal in the years 2004, 2006 and 2007 together.

 

Question 2)  What is the ratio of no. of chairs produced by Neel Kamal in the years 2007 and 2008 together to that by Raj Kamal in the same years together?

 

Question 3)  If 12% chairs out of total chairs produced in the year 2008 were defective and in them ratio of defective chairs by Raj Kamal and Neel Kamal is 2 : 3 then find the no. of defective chairs produced by Neel Kamal in the year 2008.

Answer

Answer 1)  


1/3 x (54 x 150 + 60 x 300 + 36 x 450)


= 1/3 x 42300


= 14100.


 


Answer 2)


Required ratio of chairs = 64 x 450 + 56 x 50036 x 450 + 44 x 500


= 56800/38200


= 284/191.


 


Answer 3)


 


Required number of chairs =  35 x 12100 x 50000
= 3600.


 

Report Error

View answer Workspace Report Error Discuss

7 3466
Q:

I am a 5 letter word.

I am normally below you. If you remove my 1st letter, you'll find me above you. If you remove my 1st & 2nd letters, you can't see me.

What am I?

Answer

Firstly, I focussed on "If you remove my 1st & 2nd letters, you can't see me". The first thing that comes to mind which we can’t see is the "AIR".


 


So now, what 4 letter words can be formed ending with "AIR"? Think of all the words from A to Z, considering which one lies above you. That is how we get to "HAIR".


 


Now, which 5 letter word can be formed ending with "HAIR"? Starting with A to Z, we reach "CHAIR" and also, it lies below us.


 


And the required answer is "CHAIR".

Report Error

View answer Workspace Report Error Discuss

4 3464
Q:

What is the primary purpose of most constitutions?

A) to provide a substitute for government B) to define and limit government power
C) to give the government absolute power D) to define a moral code for people to follow
 
Answer & Explanation Answer: B) to define and limit government power

Explanation:

There are many reasons why a constitution is needed. One of the primary purposes is to define and limit power of the government.

It gives the structures for the functioning of the country such as courts and parliament and limits the power.

e.g. to imprison without trial for the government.

Report Error

View Answer Report Error Discuss

4 3448
Q:

Which online security campaign has been launched by Google India to safeguard internet users?

A) #SecurityCheckKiya B) #InternetSafetyKiya
C) #OnlineSecurityKiya D) #SecureInternetKiya
 
Answer & Explanation Answer: A) #SecurityCheckKiya

Explanation:

Google has launched new online security campaign #SecurityCheckKiya in India to promote security awareness among general public. The purpose of the campaign is to protect young and first-time web users from account hijacking, safeguard Android devices from malicious apps and secure all their personal data if they lose their device.

Report Error

View Answer Report Error Discuss

2 3448
Q:

A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called

A) Touple B) View
C) Relation D) Key
 
Answer & Explanation Answer: B) View

Explanation:

A view may be a subset of the database or it may contain virtual data that is derived from the database files but is not explicitly stored .

 

 

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3448
Q:

Magnetic field lines about a current-carrying wire

A) circle the wire in closed loops B) extend radially from the wire
C) both of these D) None of the above
 
Answer & Explanation Answer: A) circle the wire in closed loops

Explanation:

Electric current produces a magnetic field. This magnetic field can be visualized as a pattern of circular field lines surrounding a wire.

Report Error

View Answer Report Error Discuss

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

3 3441
Q:

5 + 2 x 10 =

A) 70 B) 20
C) 25 D) 52
 
Answer & Explanation Answer: C) 25

Explanation:

According to BODMAS rule,

After multiplication only, addition is done.

Hence,

5 + 2 x 10 = 5 + 20 = 25.

Report Error

View Answer Report Error Discuss

4 3441
Q:

When was Barb Wire patented

A) 1898 B) 1868
C) 1874 D) 1866
 
Answer & Explanation Answer: C) 1874

Explanation:

Joseph F. Glidden - Father of Barbed Wire.

      • Glidden was born in New York in 1812. He invented Barbed Wire in 1873 and was granted the patent on Nov. 24, 1874. After a three year battle over the patent, which he eventually won received a patent for the modern invention in 1874 after he made his own modifications to previous versions.
Report Error

View Answer Report Error Discuss

Filed Under: Inventions
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Database Administration , Bank PO , Analyst

10 3439