Database Administration Questions


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 3412
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

6 3396
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 3395
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 3394
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 3392
Q:

The process of collecting, organizing and analyzing data is called

A) Statistics B) Data collection
C) Probability D) Systematic evaluation
 
Answer & Explanation Answer: A) Statistics

Explanation:

The process of collecting, organizing and analyzing data is called Statistics.

Report Error

View Answer Report Error Discuss

0 3383
Q:

Current search engines function by recognizing keywords.

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

Explanation:

A search engines are a software systems used for searching about any information in the world on the web.


                         current_search_engines_function_by_recognizing_keywords1536129682.png image


Search engines like Google, Bing, Internet explorer, Yahoo, etc... functions by providing relevant search results for the keywords user searches. 


 


Hence, the given statement is TRUE.

Report Error

View Answer Workspace Report Error Discuss

4 3375
Q:

A Step-Up Transformer Increases

A) Power B) Current
C) Frequency D) Voltage
 
Answer & Explanation Answer: D) Voltage

Explanation:

A transformer that increases voltage from primary to secondary (more secondary winding turns than primary winding turns) is called a Step-Up Transformer.

Conversely, a transformer designed to do just the opposite is called a Step-Down Transformer. 

Report Error

View Answer Report Error Discuss

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

5 3357