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

Copying the logs on the standby/backup server is an operation of Log Shipping

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

Explanation:

It is one of the operation of Log Shipping

Report Error

View Answer Workspace Report Error Discuss

0 3008
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 3002
Q:

'.bak' extension refers to what kind of file?

A) Document B) Movie/Video file
C) Backup file D) Audio file
 
Answer & Explanation Answer: C) Backup file

Explanation:

In computing, ".bak" is a filename extension commonly used to signify a backup copy of a file.

Report Error

View Answer Report Error Discuss

3 2998
Q:

Database is a collection of concepts that can be used to describe the structure of a database

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

Explanation:

Database provides necessary means to achieve this abstraction. By structure of a database we mean the data types, relations, and constraints that should hold on the data.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

0 2995
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 2994
Q:

Two main measures for the efficiency of an algorithm are

A) Time and Space B) Complexity and Memory
C) Data and Space D) Memory and Processor
 
Answer & Explanation Answer: A) Time and Space

Explanation:

Two main measures for the efficiency of an algorithm are Time and Space.

Report Error

View Answer Report Error Discuss

1 2992
Q:

The act of formally approving something is known as Arbitration.

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

Explanation:

The act of formally approving something is known as Ratification.

Report Error

View Answer Workspace Report Error Discuss

2 2978