- #Are all file details maintained by the file system update#
- #Are all file details maintained by the file system software#
A 34) In a relational database, requiring that every record in a table have a unique identifier is called theĪnswer: A A 35) The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called theĭ) foreign key rule.
#Are all file details maintained by the file system update#
A 33) The update anomaly in file-based systems or unnormalized database tablesī) restricts addition of new fields or attributes.Ĭ) results in records that cannot be updated.ĭ) is usually easily detected by users. B 31) The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the _ anomaly.Ī) may result in unintentional loss of important data.Ĭ) restricts the addition of new records.ĭ) prevents users from deleting outdated data from records or tables. A 29) Inability to add new data to a database without violating the basic integrity of the database is referred to as theĪnswer: B B 30) A relational database in which customer data is not maintained independently of sales invoice data will most likely result inĭ) an integrity anomaly. A 28) The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called theĭ) delete anomaly. A 27) The problem of changes (or updates) to data values in a database being incorrectly recorded is known asĭ) a memory anomaly. A 26) The abstract representation of the contents of a database is called theĭ) schema. A 21) Which would not generally be considered a data dictionary output report?Ī) A list of cash balances in the organization's bank accountsī) A list of all programs in which a data element is usedĬ) A list of all synonyms for the data elements in a particular fileĭ) A list of all data elements used by a particular user A 22) Creating an empty table in a relational database requires use of the _, and populating that table requires the use of _.ĭ) DML DDA A 23) When the human resources manager wants to gather data about vacation and personal day usage by employees and by departments, the manager would use which language?ĭ) Data Definition Language A 24) If a national sales tax were implemented, which language would be used to add a new field in the sales table to track the sales tax due?ĭ) Data Update Language A 25) The feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.
#Are all file details maintained by the file system software#
A 19) Reports produced using the data dictionary could include all of the following except a list ofī) synonyms for the data items in a particular file.ĭ) the schemas included in a database D 20) Which statement below concerning the database management system (DBMS) is false?Ī) The DBMS automatically creates application software for users, based on data dictionary parameters.ī) The DBMS automatically maintains the data dictionary.Ĭ) Users' requests for information are transmitted to the DBMS through application software.ĭ) The DBMS uses special languages to perform specific functions. C 15) Record layouts, definitions, addresses, and indexes will be stored at the _ level schema.ĭ) meta C 16) The _ contains information about the structure of the database.ĭ) database management system B 17) Which of the following would not be found in a data dictionary entry for a data item?Ī) records containing a specific data itemĭ) field type B 18) The data dictionary usually is maintainedĭ) by top management. C 14) A low-level view of the database that describes how the data are actually stored and accessed is theĭ) external-level schema. C 13) A set of individual user views of the database is called theĭ) meta-schema. B 12) The schema that provides an organization-wide view of the entire database is known as theĭ) logical view of the database. 11) The logical structure of a database is described by theĭ) internal level.
0 kommentar(er)
