TESTED QUESTIONS AND ACCURATE
ANSWERS GRADED A+
●● False.
Answer: T/F Working with data in data file is much faster than working
with data caches because the DBMS does not have to wait for the hard
disk to retrieve the data and no I/O operations are needed to work within
the data file
●● False.
Answer: T/F Query parsing is a phase in which all rows that match the
specified conditions are retrieved, stored and grouped
●● True.
Answer: Data replication and partitioning is a star schema performance
improvement technique that splits and makes copy of a database table
●● True.
Answer: Non-Volatile ensures that data are never deleted and new data
are continually added, so the warehouse is always growing
●● True.