Database Management Systems

It is the use sophisticated statistical analysis, including artificial intelligence techniques such as neural networks, to “discover” unhypothesized relationships in the data. For example, credit card companies use this to identify usage patterns indicative of fraud.

• Data integration
• Data Sharing
• Data Mining
• Database system

One or more very large databases containing both detailed and summarized data for a number of years that is used for analysis rather than transaction processing.

• Data warehouse
• Data Sharing
• Database
• Data Mining

A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data.

• Subschema
• Logical view
• Physical view
• Schema
• External-level schema

Which of the following is true?

• Structured Query Language (SQL) is a DBMS language that changes database content, including data element creations, updates, insertions, and deletions.
• Data Manipulation Language (DML) is a DBMS language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints.
• Data definitiona language (DDL) is a High-level, English-like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data.
• The use of standard language programs also provides the organization with a degree of independence from the DBMS vendor.

Which of the following is false?

• Normalization follows relational database creation rules to design a relational database that is free from delete, insert, and update anomalies.
• Update anomaly occurs when improper database organization where a non-primary key item is stored multiple times; updating the item in one location and not the others causes data inconsistencies.
• Insert anomaly occurs when improper database organization that results in the inability to add records to a database.
• Delete anomaly occurs when improper organization of a database that results in the loss of all information about an entity when a row is deleted.
• 2NF or second normal form is a state where relational database is free from update, insert and delete anomalies.

Occurs when multiple users seeking access to the same set of records lockout each other.

• Data manipulation
• Deadlock
• Database lockout
• Data redundancy

Which of the following is false regarding the reason why the function of system programmers should be separate from that of the database administrator?

• If one person has the authority to both write programs and access data, then control issues become a concern.
• The potential to commit fraud or embezzlement or to destroy or alter the company’s records increases.
• The lack of proper segregation of duties provides more opportunity for someone to inject malicious code without being detected.
• All information is false.

Which of the following is true?

• Database concurrency controls ensure the completeness and accuracy of a distributed database at remote sites where the same beginning data balances are updated by different transactions.
• A database lockout prevents multiple users from accessing the same table simultaneously and making changes to data values while they are temporarily inconsistent.
• SQL allows users to retrieve data from many different files without the assistance of programmer professionals.
• All information is true.

Which of the following is false?

• The entity relationship (ER) diagram is the graphical representation technique used to depict a data model.
• Each entity in an ER diagram is named in the singular noun form, such as Customer rather than Customers.
• The ER diagram also represents cardinality (the degree of association between two entities).
• Five basic forms of cardinality are possible in an E-R diagram

Which of the following is true?

• The term association pertains to the nature of the relationship between two entities.
• Cardinality is the degree of association between two entities.
• Assiciation is represented by a verb such as shipped, requests, or receives.
• Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.
• All statements are true