NPTEL Data Base Management System Week 5 Assignment Answers 2023

NPTEL Data Base Management System Week 5 Assignment Answers 2023

NPTEL Data Base Management System Week 5 Assignment Answers 2023

Q1. Identify the incorrect statement (s) about the 3-tier application architecture from the following.
a) The Controller Layer acts as the middle layer between the front and the database.
b) The Presentation Layer acts as the user interface between users and the database.
c) The Business Logic Layer acts as the middle layer between the front-end and the database.
d) The Data Access Layer acts as the backend of the application.

Answer:- a

Q2. Caching is used to improve web server performance. Which of the following sentences is not true about caching?
a) Caching is used on the server side for JDBC connection pooling.
b) Caching is used to increase the amount of data that needs to be sent over the network.
c) Web proxy caching is used to store copies of frequently accessed Web objects.
d) Caching is used on the server side for generated HTML.

Answer:- For Answer Click Here

Q3. A Redundant Arrays of Independent Disk (RAID) system has 8 disks and it uses block level striping to improve reliability. If we have to store a 16 KB file in it and the size of a disk block is 512 bytes. In which disk, the last file block will be stored?
a) Disk 8
b) Disk 7
c) Disk 1
d) Disk 0

Answer:- For Answer Click Here

Q4. Which of the two alternatives would you choose if you need to support real-time queries that must be answered within a guaranteed short period of time?
a) Magnetic Hard Disk
b) Solid State Drive
c) Redundant Arrays of Independent Disks
d) Digital Video Disk

Answer:- 

Q5. If a system contains 1,000 disk drives, and each of them has a 6,00,000-hour MTBF (Mean
time between failure), how often a single drive failure will occur in that disk system?
a) 25000 hours
b) 14400 hours
c) 600 hours
d) 25 hours

Answer:- For Answer Click Here

Q6. Suppose you have a 64-gigabyte disk pack with the following specifications: 32 double-sided platters, 1024 tracks per surface, and 512 sectors per track. What is the data size of one sector?
a) 64 Kilobyte
b) 32 Kilobyte
c) 4 Kilobyte
d) 2 Kilobyte

Answer:- 

Q7. Consider the following string of reference:
33, 25, 81, 42, 33, 25, 50, 33, 25, 81, 42, 50
Find the number of replacements (where an existing value is replaced by a new value because the buffer is full) incurred using the least recently used (LRU) buffer replacement algorithm with 3 empty buffer frames.
a) 7
b) 8
c) 10
d) 12

Answer:- For Answer Click Here

Q8.

Answer:- 

Q9.

Answer:- For Answer Click Here

Q10.

Answer:-