Introduction to Database System When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used to add/rename data files, to change storage to create a database trigger All of these None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to add/rename data files, to change storage to create a database trigger All of these None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The master list of an indexed file is sorted in ascending order has a number assigned to each record contains only a list of keys and record numbers None of these both (b) and (c) is sorted in ascending order has a number assigned to each record contains only a list of keys and record numbers None of these both (b) and (c) ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity. instance child subtype parent instance child subtype parent ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The activity of a file if high, reduces processing efficiency for sequential and nonsequential files is a low percentages of number of records added or deleted from a file is a measure of the percentage of existing records updated during a run None of these refers to how closely the files fits into the allocated if high, reduces processing efficiency for sequential and nonsequential files is a low percentages of number of records added or deleted from a file is a measure of the percentage of existing records updated during a run None of these refers to how closely the files fits into the allocated ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM? dBase-II R:base IDMS DB2 dBase-II R:base IDMS DB2 ANSWER DOWNLOAD EXAMIANS APP