click below
click below
Normal Size Small Size show me how
COP4020_Chapter_10
Question | Answer |
---|---|
Data may be stored in the following formats _____. | files and databases |
A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems. | end-user database management system |
A(n) _____ can support large volumes of data and support applications that run an entire company. | enterprise database management system |
A(n) _____ is basically an electronic list of information that is stored on a disk. | unordered sequential access file |
SQL operates on _____. | tables of data at a time |
Which of the following is NOT a characteristic of current object-relational databases? | support for inheritance |
In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database. | table |
The type of database that is most capable of supporting complex data types is _____. | object-oriented DBMS |
The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____. | referential integrity |
A relational database may be optimized for _____. | storage efficiency and speed of access |
A(n) _____ occurs when data are stored redundantly in a database and only some of the instances are updated when a change is needed. | update anomaly |
A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form. | second |
If the data model does not have any repeating fields it is in _____. | first normal form |
If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____. | third normal form |
In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model. | denormalize |
To improve the access speed of a database, similar records in a table are stored together in primary key order. This optimizing access speed process is called _____. | intrafile clustering |
_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project’s | Volumetrics |
The size of a database is determined by the _____. | amount of raw data in the tables and overhead requirements for the DBMS |
A mini-table that contains values from one or more columns in a table and the location of the values within the table is called a(n) _____. | index |