Introduction to Database System A scheme describes data elements record relationships All of these None of these records and files data elements record relationships All of these None of these records and files 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- independent entity ID-dependent entity Weak entity Strong entity ID- independent entity ID-dependent entity Weak entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following indicates the maximum number of entities that can be involved in a relationship? Greater Entity Count (GEC) Minimum cardinality Maximum cardinality ERD Greater Entity Count (GEC) Minimum cardinality Maximum cardinality ERD ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme. add a composite key. change the theme. create a new theme. split the relation into two relations, each with a single theme. add a composite key. change the theme. create a new theme. 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 measure of the percentage of existing records updated during a run None of these refers to how closely the files fits into the allocated is a low percentages of number of records added or deleted from a file if high, reduces processing efficiency for sequential and nonsequential files 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 is a low percentages of number of records added or deleted from a file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command(s) is(are) used to create a synonym for a schema object? All of the listed here CREATE SCHEMA CREATE SAME CREATE SYNONYM All of the listed here CREATE SCHEMA CREATE SAME CREATE SYNONYM ANSWER DOWNLOAD EXAMIANS APP