Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Subtypes and supertypes,”specialization/ generalization All[…]
Read moreAuthor: mfadmin
Partial Specialization Rule,”a supertype may have a subtypeIndicated with a single line (e.g.
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Partial Specialization Rule,”a supertype may[…]
Read moreDisjointess contraint:
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Disjointess contraint: determines whether a[…]
Read moresubtype discriminators,”Hourly- HSalaried- SConsultant- CThe letters H, S
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.subtype discriminators,”Hourly- HSalaried- SConsultant- CThe[…]
Read moreT/F? Supertype/subtype relationships can span multiple levels
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.T/F? Supertype/subtype relationships can span[…]
Read moreThe typical flow when designing a database involves:,”Developing an ER diagramMapping the ER diagram into the relational modelNormalizing to avoid anomalies, reduce redundancy, and increase integrityInstantiating the database (e.g.
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.The typical flow when designing[…]
Read moreKey properties of relational modeling,”Values are atomic (i.e., a data cell cannot contain multiple values)Values in a given column are of the same domain/type (e.g., float)No rows contain completely duplicate dataThe order of rows and columns is completely irrelevantThe names of every relation are unique and within relations
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Key properties of relational modeling,”Values[…]
Read moreDescribe the RECO,”Recoverer Process• Used with the distributed database configuration• Automatically connects to other databases involved in in-doubt distributed transactions• Automatically resolves all in-doubt transactions• Removes any rows that correspond to in-doubt transactionsIf the RECO process fails to connect with a remote server, RECO automatically tries to connect again after a timed interval. However
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the RECO,”Recoverer Process• Used[…]
Read moreDescribe the LREG,”Listener Registration ProcessRegisters information about the database instance and dispatcher processes with the Oracle Net ListenerLREG provides the listener with the following information:• Names of the database services• Name of the database instance associated with the services and its current andmaximum load• Service handlers (dispatchers and dedicated servers) available for the instance, including their type, protocol addresses
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe the LREG,”Listener Registration ProcessRegisters[…]
Read moreDescribe ARCn,”Archiver Processes• Copy redo log files to a designated storage device after alog switch has occurred• Can collect transaction redo data and transmit that data tostandby destinationsIf you anticipate a heavy workload for archiving (such as during bulk loading of data)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe ARCn,”Archiver Processes• Copy redo[…]
Read more