You need to ensure data integrity while sharing a database file between different departments using a remote file system.Which consistency semantics should be implemented?Answer( Please choose a correct answer )   CLEARSession semantics used in distributed database systemsWrites to an open file are immediately visible to other usersSharing a file pointer to allow concurrent read and write accessMultiple users should not be allowed to access the same file simultaneously

In file processing, every user group will maintain its own files for handling its data-processing applications.Data redundancy and inconsistencyDifficulty in accessing the dataData isolationAtomicity problemsIntegrity problems

Select the purpose of concurrency control.To enforce IsolationTo preserve database consistencyTo resolve read-write and write-write conflictsTo make data more readable to the users

A user is reporting that a file has been shared specifically with another user on the network, but the other user opens the file and is unable to save it once edited. What is the probable cause?(1 Point)

Which of the following is true for a flat file database?*1 pointIt has multiple tables related to one anotherIt can be used concurrently by multiple individualsIt stores data in a structured way that is easy to retrieveIt is difficult to manage as it contains redundant and inconsistent data

Storing multiple copies of the same data within the system is not advisable, because it increasesData ConsistencyData RedundancyAtomicity of DataData Integrity