Introduction to Database System In SQL, which command(s) is(are) used to redefine an index's future storage allocation MODIFY INDEX DO INDEX ALTER INDEX None of these REDEFINE INDEX MODIFY INDEX DO INDEX ALTER INDEX None of these REDEFINE INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In a relational schema, each tuple is divided into fields called Relations Queries Domains All of the listed here Relations Queries Domains All of the listed here ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier? Strong entity ID-dependent entity ID- independent entity Weak entity Strong entity ID-dependent entity ID- independent entity Weak entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System With respect to data input, the most accurate description of batch control is controlling the input of each input clerk All of these dividing documents to be entered into batches None of these comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system controlling the input of each input clerk All of these dividing documents to be entered into batches None of these comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System For some relations, changing the data can have undesirable consequences called: normal forms. modification anomalies. transitive dependencies. referential integrity constraints. normal forms. modification anomalies. transitive dependencies. referential integrity constraints. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it. Delete Index Update Sort Key None of these Delete Index Update Sort Key None of these ANSWER DOWNLOAD EXAMIANS APP