Ask a Question

If a piece of data is stored in two places in the database, then

in Education by
If a piece of data is stored in two places in the database, then (a) Storage space is wasted (b) Changing the data in one spot will cause data inconsistency (c) In can be more easily accessed (d) Storage space is wasted & Changing the data in one spot will cause data inconsistency This question was posed to me in an online quiz. My query is from Organization of Records in Files in chapter Storage and File Structures of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
The correct choice is (d) Storage space is wasted & Changing the data in one spot will cause data inconsistency For explanation: The database is always consistent and so there is no duplication.

Related questions

0 votes
Q: Two numbers are selected at random from 1,2,3,....100 and are multiplied, then the probability correct to two places of decimals that the product thus
    Two numbers are selected at random from 1,2,3,....100 and are multiplied, then the probability correct to two places ... 67 75 D. 8 75 Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
Q: Which of the following is used to determine, if a piece of data in cache needs to be written back to cache?
    Which of the following is used to determine, if a piece of data in cache needs to be written back to cache? (a)Valid Bit = 0 (b)Dirty Bit = 1 (c)Valid Bit = 1 (d)Dirty Bit = 0...
asked Oct 6, 2020 in Technology by JackTerrance
0 votes
Q: If pattern is to be stored, then what does stable state should have updated value of?
    If pattern is to be stored, then what does stable state should have updated value of? (a) current sate (b) next ... (d) none of the mentioned Please answer the above question....
asked Aug 30, 2022 in Education by JackTerrance
0 votes
Q: Caching Technique where cache is populated the first time a certain piece of data is requested is called _________.
    Caching Technique where cache is populated the first time a certain piece of data is requested is called _________. (a)Local ... (b)Lazy Loading (c)Cache aside (d)Upfront Loading...
asked Oct 6, 2020 in Technology by JackTerrance
0 votes
Q: What would happen if the protective tin coating over an iron bucket is broken in some places ?
    What would happen if the protective tin coating over an iron bucket is broken in some places ? Select the correct answer from above options...
asked Jan 5, 2022 in Education by JackTerrance
0 votes
Q: If a piece of bread is kept in a container in moist place for 2-3 days, (1) What will you see? (2) Write scientific name and a character
    If a piece of bread is kept in a container in moist place for 2-3 days, (1) What will you see? (2) ... of the organism you may observe. Select the correct answer from above options...
asked Nov 9, 2021 in Education by JackTerrance
0 votes
Q: The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?
    The traditional storage of data that is organized by customer, stored in separate folders in filing ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: How inserting data through stored procedure do reduces network traffic and increase database performance?
    How inserting data through stored procedure do reduces network traffic and increase database performance? (a) ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The database design that consists of multiple tables that are linked together through matching data stored in each table is called
    The database design that consists of multiple tables that are linked together through matching data stored in ... Hashing in division Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The primary medium for the long-term online storage of data is the __________ where the entire database is stored on magnetic disk.
    The primary medium for the long-term online storage of data is the __________ where the entire database is ... topic in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
    If the state of the database no longer reflects a real state of the world that the database is supposed ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
    If the state of the database no longer reflects a real state of the world that the database is ... Query Processing in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...