Introduction to Database System Which of the following is a serious problem of file management systems? program dependence All of these lack of data independence difficult to update data redundancy program dependence All of these lack of data independence difficult to update data redundancy ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The _____ command is used to allocates an extent for the table in SQL REDEFINE TABLE None of these MODIFY ALLOCATES MODIFY TABLE ALTER TABLE REDEFINE TABLE None of these MODIFY ALLOCATES MODIFY TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If attributes A and B determine attribute C, then it is also true that: A → B → (A,B) is a composite determinant. C is a determinant. A → B → (A,B) is a composite determinant. C is a determinant. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is a group of one or more attributes that uniquely identifies a row? Tuple Key Relation Determinant Tuple Key Relation Determinant ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to remove an index from the database in SQL? DROP INDEX DELETE INDEX ROLL BACK INDEX REMOVE INDEX DROP INDEX DELETE INDEX ROLL BACK INDEX REMOVE INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Each of data files has a _____ that describe the way the data is stored in the file. File structure Records Database Fields File structure Records Database Fields ANSWER DOWNLOAD EXAMIANS APP