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 2953
Q:

Why are manhole covers round?

Answer

A number of possible explanations for why manhole covers are round include :


 


1. A round manhole cover cannot fall through its circular opening, whereas a square, rectangular, or oval manhole cover could fall in if it were inserted diagonally in the hole.


2. Circular covers don’t need to be rotated or precisely aligned when placing them on the opening.


3. A round manhole cover is easily moved and rolled.


4. Human beings have a roughly circular cross-section.


5. Round tubes are the strongest shape against the compression of the earth around them, so the cover of the tube would naturally be round as well.


6. It’s easier to dig a circular hole.

Report Error

View answer Workspace Report Error Discuss

2 2950
Q:

Which of the following vitamins are water soluble?

A) Vitamins B & C B) Vitamins K, D & C
C) Vitamins A, D & K D) Vitamins A, K, B, C & D
 
Answer & Explanation Answer: A) Vitamins B & C

Explanation:

Vitamins are essential nutrients found in foods. They perform specific and vital functions in a variety of body systems, and are crucial for maintaining optimal health.

 

The two different types of vitamins are fat-soluble vitamins and water-soluble vitamins.

 

Fat-soluble vitamins :

 Vitamins A, D, E and K — dissolve in fat before they are absorbed in the bloodstream to carry out their functions. Excesses of these vitamins are stored in the liver, and are not needed every day in the diet.

 

Water-soluble vitamins :

Vitamins dissolve in water and are not stored by the body. Since they are eliminated in urine, we require a continuous daily supply in our diet. The water-soluble vitamins include the vitamin B-complex group and vitamin C.

 

Water-soluble vitamins are easily destroyed or washed out during food storage or preparation.

Report Error

View Answer Report Error Discuss

Filed Under: Chemistry
Exam Prep: AIEEE , Bank Exams , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

0 2948
Q:

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Can’t delete a row from primary table if there are related rows in secondary table.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2945
Q:

How many times can you subtract 5 from 25?

Answer

Technically or logically it is possible only once. As if you subtract 5 from 25 at first te result will be 20. Now, you can't subtract 5 from 25 since the left number is 20.


 


But if you go mathematically, it can be done infinite times and only 5 times without going into the negatives.

Report Error

View answer Workspace Report Error Discuss

8 2940
Q:

Physical data models describe the details of how data is stored in the computers

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

They describe the details of how data is stored in the computers

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2931
Q:

I always run but never walk, often murmur, never talk, have a bed but never sleep, have a mouth but never eat. Who am I?

I_always_run_but_never_walk,_often_murmur,_never_talk,_have_a_bed_but_never_sleep,_have_a_mouth_but_never_eat1551358331.jpg image

A) Forest B) Fire
C) River D) Mountain
 
Answer & Explanation Answer: C) River

Explanation:

River.

It always runs  or flows but never walks.

It will sound like murmuring but never talks.

It has bed but never sleeps.

It has mouth but never eats.

Report Error

View Answer Report Error Discuss

5 2926
Q:

Website always has

A) Address B) Information
C) Attachments D) Images
 
Answer & Explanation Answer: A) Address

Explanation:

Website always has an address whether it has images, any information or any attchments in it or not but it must has an address. 

Website_always_has1551876614.jpg image

Report Error

View Answer Report Error Discuss

1 2923