Introduction to Database System When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): referential integrity constraint. insertion anomaly. normal form. transitive dependency. referential integrity constraint. insertion anomaly. normal form. transitive dependency. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is a type of DBMS software? utilities report writer database manipulation language All of these query language utilities report writer database manipulation language All of these query language ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In which of the following is a single-entity instance of one type related to many entity instances of another type? One-to-Many Relationship Many-to-Many Relationship One-to-One Relationship Composite Relationship One-to-Many Relationship Many-to-Many Relationship One-to-One Relationship Composite Relationship ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not the responsibility of the utilities component of DBMS software? creating and maintaining the data dictionary removing flagged records for deletion creating the physical and logical designs None of these monitoring performance creating and maintaining the data dictionary removing flagged records for deletion creating the physical and logical designs None of these monitoring performance 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. Sort key Delete Index Update Sort key Delete Index Update ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE VIEW command is used to recompile a table to create a trigger to recompile view to define a view of one or more tables or views to recompile a table to create a trigger to recompile view to define a view of one or more tables or views ANSWER DOWNLOAD EXAMIANS APP