NPTEL Data Base Management System Week 5 Assignment Answers 2024

Join Our WhatsApp Group Join Now
Join Us On Telegram Join Now

NPTEL Data Base Management System Week 5 Assignment Answers 2024

1. Choose the INCORRECT statement from the following.

a) Data Dictionary stores the information about schema definition.
b) Data Dictionary stores the information about Integrity constraints on a relation.
c) Data Dictionary does not store user and accounting information of a database.
d) Data Dictionary stores the information about file organization.

Answer :- For Answer Click Here 

2. The different Uniform Resources used to identify and locate Web resources in the Web are Uniform Resource Identifier(URI), Uniform Resource Locator (URL) and Uniform Resource Name(URN). Find the INCORRECT statement from the following regarding URI, URL and URN.

a) URI can either be a URN or URL or both.
b) URN identifies a Web resource by its name given in the namespace.
e) URL provides the functionality of pointer to locate a Web resource in the Web.
d) URL defines something’s identity, while URN provides a location.

Answer :- For Answer Click Here 

3. Consider a table which contains the salary of employees. A new salary of 15200 is inserted into this table after which the pointers are rearranged as shown in the figure. Which of the following file organizations is used to represent this?

NPTEL Data Base Management System Week 5 Assignment Answers 2024
NPTEL Data Base Management System Week 5 Assignment Answers 2024
Answer :- For Answer Click Here 

4. If a disk system contains 1, 600 disk drives, and each has a 4, 00, 000 hour MTBF (Mean time between failure), how often a drive failure will occur in that disk system?

a) 6400000 hours
b) 400000 hours
c) 400 hours
d) 250 hours

Answer :- 

5. Consider a disk pack with the following specifications: 16 double-sided platters, 256 tracks per surface, 512 sectors per track and 1024 bytes per sector. Which of the following is the correct capacity of disk (approximately)?

a) 512 MB
b) 2 GB
c) 4 GB
d) 8 GB

Answer :- 

6. If you want to design a secure database applications with large amounts of data and low update rate. Which of the following RAID level will you select?

a) RAID level 5
b) RAID level 3
c) RAID level 1
d) RAID level 0

Answer :- For Answer Click Here 

7. In a Cafe Shop, several types of food items are there. A customer places his/her order. A serviceman can serve multiple orders but an order will be serviced by only one serviceman. A customer can place more than one order. Which of the following statement(s) is (are) true?

a) There will be minimum three entities in the E-R diagram.
b) There will be minimum four entities in the E-R diagram.
c) Minimum two relationships will be required in the E-R. diagram to modeled the scenario.
d) Minimum three relationships will be required in the E-R diagram to modeled the scenario.

Answer :- 

8. Consider there is a sequential file for the relation Customer. The record size is fixed and the size of one record is 46 bytes. If the records do not cross block boundaries, and the disk block is 512 bytes with the block pointer size 10 bytes long, what is the maximum number of records can be stored in one block?

a) 9
b) 10
c) 11
d) 12

Answer :- 

9.

NPTEL Data Base Management System Week 5 Assignment Answers 2024
Answer :- 

10. Which of the following statements are false about the Buffer Manager?

a) Programs call the buffer manager when they only need to transfer a block to disk.
b) If the block is already in the buffer, buffer manager will do nothing.
c) If the block is not in the buffer, the buffer manager allocates space in the buffer for the block.
d) For allocating the space, sometimes the buffer manager replace some other block also.

Answer :- For Answer Click Here