Introduction to Database System Which command is used to remove an index from the database in SQL? REMOVE INDEX ROLL BACK INDEX DROP INDEX DELETE INDEX REMOVE INDEX ROLL BACK INDEX DROP INDEX DELETE INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in an indexed file a tree file None of these a sequential file a hashed file an indexed file a tree file None of these a sequential file a hashed file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator? Supertype entity Instance entity Subtype entity Archetype entity Supertype entity Instance entity Subtype entity Archetype entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System After you _____ a record, many data management the environments require you to issue a command to save the changes you made. Update Sort key Index Delete Update Sort key Index Delete ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table INSERT COLUMN ALTER TABLE MODIFY TABLE ADD COLUMN INSERT COLUMN ALTER TABLE MODIFY TABLE ADD COLUMN ANSWER DOWNLOAD EXAMIANS APP