DBMS and SQL Quiz 3 DBMS and SQL Quiz 3 The term DBMS was first introduced in late 1940s.TRUEFALSEData anomalies occur due to defining well-structured relations.TRUEFALSEThe issue associated with Control Concurrency is more complicated in a distributed database environment.TRUEFALSEPrimary key is, basically, selected from the:determinantscandidate keyscomposite keysforeign keys“The value of a cell in one column must be less than the value of a cell in another column in the same row of the same table”, this type of constraint is called as:A domain constraint A range constraint An intra-relation constraintAn interrelation constraintIf attribute C is determined by attributes A and B, then it is also true that:A → 3B → 3 C is a determinant(A,B) is a composite determinantSequences ensures valid surrogate keys.TRUE FALSE The entity’s integrity rule states that:no primary key may be equal to a value in a foreign key.no primary key may be unique. no primary key can be composite.no primary key attribute may be null.SQL Server indexes are the special data structures that are used to improve database performance.TRUEFALSEAll ERP solutions are entirely dependent on databases for storing the data required by the applications.TRUEFALSE
