NPTEL Data Base Management System Assignment Answers
NPTEL Data Base Management System Week 8 Assignment Answers 2023
1.
Answer :- d
2.
Answer :- b
3.
Answer :- b, c
4.
Answer :- c
5.
Answer :- d
6.
Answer :- d
7.
Answer :- c
8.
Answer :- a, d
9.
Answer :- c
10.
Answer :- a, b
| Course Name | Data Base Management System |
| Category | NPTEL Assignment Answer |
| Home | Click Here |
| Join Us on Telegram | Click Here |
NPTEL Data Base Management System Week 7 Assignment Answers 2023
1.
Answer :- b
2.
Answer :- b
3.
Answer :- b
4.
Answer :- d
5.
Answer :- a, d
6.
Answer :- d
7.
Answer :- a, c
8.
Answer :- c
9.
Answer :- b
10.
Answer :- b
| Course Name | Data Base Management System |
| Category | NPTEL Assignment Answer |
| Home | Click Here |
| Join Us on Telegram | Click Here |
NPTEL Data Base Management System Week 6 Assignment Answers 2023
Q1.
Answer:- b
Q2.
Answer:- d
Q3.
Answer:- c
Q4.
Answer:- c
Q5. A 2-3-4-tree, can store a maximum 4095 number of keys. What will be the minimum height of the tree? The height of the root node is assumed to be zero.
a) 4
b) 5
c) 6
d) 10
Answer:- b
Q6.
Answer:- c
Q7.
Answer:- a
Q8. Suppose a database management system uses dense indexing. Suppose that 128 blocks are required to store a database file and its index file. How many records does the database file contain? Given that one memory block of the disk can store either 48 key pointers or 16 whole
records.
a) 1024
b) 1536
c) 2048
d) 4096
Answer:- b
Q9.
Answer:- d
Q10.
Answer:- a
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:- b
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:- a
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:- b, c
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:- c
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:- d
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:- a
Q8.
Answer:- d
Q9.
Answer:- b
Q10.
Answer:- a, b
NPTEL Data Base Management System Week 4 Assignment Answers 2023
1. Consider the relational schema OfficeList (Sector, Company, Building, Floor, Employees)with the following Functional Dependency set:
{Sector, Company} -> Building, Floor}
{Company, Building} – {Employees, Sector}
Building > Floor
Which attribute is present in all the composite candidate kevs of OfficeList?
a) Sector
b) Company
c) Building
d) Floor
Answer :- b
2. Consider the relational schema:
DeviceLogs (Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the
following Functional Dependency set:
{Device, OperatingSystem} -› DeviceLocation
{Logins, Date0fRecord] – OperatingSystem
DeviceLocation -› DateOfRecord
If X is the number of candidate keys of DeviceLogs and Y is its highest Normal Form, find the values of X and Y.
a) X=1, Y=2
b) X=2, Y=1
c) X=3, Y=3
d) X=2, Y=3
Answer :- c
3. Consider the relational schema DataLabelling (DataSetName, DataFeature1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set:
Answer :- b, c
4. Consider the relational schema LuckyDraw (Box, Item, Price, Picked, WinningPrize). Which of the following set of functional dependencies should be chosen so that LuckyDraw can be in 2NF but not in 3NF?
Answer :- a
5. Consider the relational schema Tournament (Champion, Category, Participants, Judges, Day) with the following Functional Dependency set F.
Answer :- c
6. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency set:
Answer :- b
7. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency sets:
Answer :- c
8. Consider the relational schema Gallery (GallerySection, ArtistID, ArtID, Sold, Theme) with the following Functional Dependency set:
Answer :- b
9. In a relation FurnitureStore (FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent on FurnitureNo and Weight together. Which of the following are the non-prime attributes of FurnitureStore?
a) FurnitureNo
b) Height
c) Weight
d) DeliveryCharge
Answer :- b, d
10. In a relation FurnitureStore (FurnitureNo, FurnitureType, Price, Width, Height, Weig DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent on FurnitureNo and Weight together. The highest normal form of FurnitureStore is n. If the highest normal form of the relation has to be increased to n+1, which of the following changes should be made in its current functional dependency set?
a) FurnitureNo and Weight together, should identify FurnitureType and Price
b) Only Width, Height and Weight should identify the DeliveryCharge
c) Only FurnitureType, Height and Weight should identify the DeliveryCharge
d) Only Weight should identify the Width and Height
Answer :- a
| Course Name | Data Base Management System |
| Category | NPTEL Assignment Answer |
| Home | Click Here |
| Join Us on Telegram | Click Here |
NPTEL Data Base Management System Week 3 Assignment Answers 2023
1. Consider the relation Payments as follows:
a) UPI
b) Cash
c) NEFT
d) Card
Answer :- a
2. Consider the relation Payments as follows:
Which of the TransactionIDs will NOT be present in the output of R1-R2?
a) 42
b) 15
c) 14
d) 4
Answer :- b
3. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes).
Choose the correct Tuple Relational Calculus that represents the following statement:
“Display the titles of those videos that are published on You Tube Channels and have more than 50,000 likes.”
Answer :- c
4. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes).
Choose the correct Domain Relational Calculus that is equivalent to the following SQL Query:
SELECT Channel, VideoTitle FROM Content
WHERE Dislikes<100;
a) {< c,v > |31, d(< c,v, 1,d >€ Content ^ d < 100)}
b) {c,v|3c,v, 1, d(< c,v, 1, d >€ Content ^ Dislikes < 100)}
c) {< c,v > 3c,v,1,d € Content ^ d < 100}
d) {c,v|3 < 1, >€ Content ^ Dislikes < 100}
Answer :- a
5. A C program, with embedded SQL query, allows the users to enter a date and an amount to check the transactions that were made on that day. The entered date is stored in the variable Idate and the amount in variable amt. The SQL query returns the TransactionID and Amount of those payments from Payments (Mode, TransactionID, PaymentDate, Amount) whose PaymentDate match with the user’s entered date and the Amount is more than the entered amount. Which of the following SQL queries is correct for the purpose?
a) EXEC SQL
DECLARE c CURSOR FOR
SELECT TransactionID, Amount
FROM Payments
WHERE PaymentDate= :Tdate AND Amount>: amt
END EXEC
b) EXEC SOL
DECLARE c CURSOR FOR
SELECT *
FROM Payments
WHERE PaymentDate= Tdate AND Amount>amt
END EXEC
c) EXEC SOL
DECLARE c CURSOR FOR
SELECT *
FROM Payments
WHERE Tdate=PaymentDate AND amt>Amount
d) EXEC SQL
DECLARE c CURSOR FOR
SELECT TransactionID, Amount
FROM Payments
WHERE : PaymentDate= :Tdate AND : Amount>: amt
END EXEC
Answer :- a
6. A cloth factory maintains a schema of manufactured Clothes where each clothing item is identified by a tag. The clothes are also associated with corresponding sizes and materials. However, each cloth can be designed by multiple designers. Which of the following schema correctly represents the Clothes entity set?
a) Clothes (Tag, Size, Material, Designer)
b) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer)
c) Clothes (Tag, Size, Material), Clothes_Designer (Tag, Designer)
d) Clothes (Tag, Size, Material), Clothes Designer (Tag, Designer)
Answer :- d
7. Consider the three relational schemas:
Stories (Title, Author, Pages, StoryCount)
Books (Title, Author, Pages)
Educational (Title, Author, Pages, Subject)
Which of the Entity Relationship diagrams correspond to the given schemas?
Answer :- c
8. Consider the Entity Relationship Diagram:
Which of the following is/are true?
a) The participation of Organizer in Org.Conf is partial.
b) The participation of Conference in Org-Conf is partial.
c) Presenter is a composite attribute of Presentation.
d) Presenter is a multivalued attribute of Presentation.
Answer :- b, d
9. Consider the entity relationship diagram.
Answer :- b
10. Consider the following instance of organizer.
Answer :- a
| Course Name | Data Base Management System |
| Category | NPTEL Assignment Answer |
| Home | Click Here |
| Join Us on Telegram | Click Here |
NPTEL Data Base Management System Week 2 Assignment Answers 2023
1. Consider two relations StyleName and PrintStyle as follows:
An operation θ between StyleName and PrintStyle will generate the following output:
Identify the operation G.
a) natural join
b) natural left outer join
c) natural right outer join
d) natural full outer join
Answer:- d
2. Consider the following CREATE statements:
Answer:- a
3. Consider the following schema:
- loan (loan _number, branch_name, amount)
Answer:- b, d
4. Consider the following instance of the relation
BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)
Answer:- a
5. Consider the following instance of the relation
BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)
Answer:- b
6. Consider the following instance of the relational schema
PAYSCALE (POSITION, BASE_SALARY, EXPERIENCE)
Answer:- c
7. A role Manager has the privilege to perform select, insert, update and delete operations on all tables of database. A new role Software_Engineer is created and the following statement is executed.
Answer:- d
8. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.
Answer:- a
9. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)
Answer:- b
10. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)
Answer:- c
NPTEL Data Base Management System Week 1 Assignment Answers 2023
1. Which of the following statements is (are) correct?
- a) Phsical level abstraction describes how a record is stored.
- b) View level abstraction hides details of data types.
- c) Physical level abstraction describes data stored in a database and their relationships.
- d) Logical level abstraction defines the physical schema.
Answer :- a, b,
2. Consider the following relations:
Subject (sid, sname, credit)
Faculty (fid, sid)
Which of the following is correct?
- a) RA1 C RAz
- b) RAg C RAg
- c) RAI C RAg
- d) RA1 = RAg
Answer :- c) RAI C RAg
3. What does the following Relational Algebra expression return?
- a) All heights except the maximum height from Mountain relation.
- b) All heights except the minimum height from Mountain relation.
- c) Minimum height from Mountain relation.
- d) Maximum height from Mountain relation.
Answer :- d) Maximum height from Mountain relation.
4. Consider the relational schema PhoneBook (Name, PhoneNo, Location, LastCalled)
- Ankit 3222265783 Kolkata 15 Jul
- Shreya 3222265783 Delhi 16 Jul
- Ankit 2222586110 Delhi 16 Jul
- Shreya 2222586110 Kolkata 15 Jul
Answer :- c
5. Consider the relation Flight (FlightNo, Source, Destination, Duration) where {FlightNo} and {Source, Destination, Duration} are the 2 candidate keys. What is the possible num- ber of superkeys of Flight?
- a) 8
- b) 9
- c) 10
- d) 16
Answer :- b
6. Consider a truth table having the following columns P Q R= ((P V Q) – -P) S= ( (P V Q) – P) If the truth table, with all the values, is represented as a relational instance, which column(s) (attribute(s)) should be chosen as candidate keys?
- a) {P,R}
- b) {P,Q}
- c) {Q,R}
- d) {Q,S)
Answer :- b, c
7. Consider the following instance of ChatBox (SenderID, ReceiverID).
Answer :- b
8. Consider the following table:
Answer :- d
9. Consider the following table:
Answer :- c
10. Which of the following can be a candidate key for the following instance?
Answer :- b
| Course Name | Data Base Management System |
| Category | NPTEL Assignment Answer |
| Home | Click Here |
| Join Us on Telegram | Click Here |
![[Week 1] NPTEL Ethical Hacking Assignment Answers 2023](https://gecmunger.in/wp-content/uploads/2023/07/Ethical-Hacking-1024x576.png "[Week 12] NPTEL Ethical Hacking Assignment Answers 2023 104")
