Reader small image

You're reading from  Developing Robust Date and Time Oriented Applications in Oracle Cloud

Product typeBook
Published inMay 2023
PublisherPackt
ISBN-139781804611869
Edition1st Edition
Concepts
Right arrow
Author (1)
Michal Kvet
Michal Kvet
author image
Michal Kvet

Michal Kvet is a researcher, educator, and database expert at the University of Žilina in Slovakia. His primary focus areas are databases, analytics, performance, and cloud computing. He works closely with Oracle and Oracle Academy. He is the co-author of multiple textbooks (a SQL and PL/SQL cookbook, a book on APEX application development, a book on temporal databases, and a MySQL cookbook), coordinates multiple Erasmus+ projects and co-organizes several research conferences and database workshops. Besides this, he supervises engineering projects and bachelor's, master's, and doctoral theses. Over the years, his research has been associated with date and time management and temporal databases. He has Oracle's SQL, PL/SQL, Cloud, Analytics, and Administration certifications. His core knowledge of temporality is provided to you in this book.
Read more about Michal Kvet

Right arrow

Questions

  1. Choose the correct statement related to the header-temporal concept:
    1. It cannot manage references using primary and foreign keys.
    2. The header consists of the current valid data; the temporal layer is used just for the history.
    3. Future valid data cannot be managed by it.
    4. The header layer is used for the references; attribute values are stored separately in a temporal manner.
  2. Which model does not use temporal management?
    1. A conventional model
    2. A uni-temporal model
    3. A bi-temporal model
    4. A fixed temporal model
  3. Historical states can lose their importance and relevance by being removed from the main system or moved to an aggregated data warehouse repository. Which aspect characterizes these options?
    1. Relevance
    2. Transaction support
    3. Limited temporal usability
    4. Correctness
  4. How many dimensions are covered by the IPL model?
    1. 1
    2. 2
    3. 3
    4. 4
  5. Which system takes the validity for each column separately to optimize the storage demands if the frequency rate of the changes for individual attributes is not...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Developing Robust Date and Time Oriented Applications in Oracle Cloud
Published in: May 2023Publisher: PacktISBN-13: 9781804611869

Author (1)

author image
Michal Kvet

Michal Kvet is a researcher, educator, and database expert at the University of Žilina in Slovakia. His primary focus areas are databases, analytics, performance, and cloud computing. He works closely with Oracle and Oracle Academy. He is the co-author of multiple textbooks (a SQL and PL/SQL cookbook, a book on APEX application development, a book on temporal databases, and a MySQL cookbook), coordinates multiple Erasmus+ projects and co-organizes several research conferences and database workshops. Besides this, he supervises engineering projects and bachelor's, master's, and doctoral theses. Over the years, his research has been associated with date and time management and temporal databases. He has Oracle's SQL, PL/SQL, Cloud, Analytics, and Administration certifications. His core knowledge of temporality is provided to you in this book.
Read more about Michal Kvet