answer 27 questions
pzftoresc8h5
1. A highly organized collection of data is a database management system.
[removed] True
[removed] False
4 points
QUESTION 2
1. Financial data residing in a database is not a corporate resource.
[removed] True
[removed] False
4 points
QUESTION 3
1. Modality is the maximum number of entity occurrences involved in a relationship.
[removed] True
[removed] False
4 points
QUESTION 4
1. Unary relationships contain one entity type.
[removed] True
[removed] False
4 points
QUESTION 5
1. In a database, if there is more than one candidate key one MUST be identified as a primary key.
[removed] True
[removed] False
4 points
QUESTION 6
1. A concurrency problem is defined as multiple data sets stored in the database.
[removed] True
[removed] False
4 points
QUESTION 7
1. The most significant problem with data redundancy in a database is data integrity.
[removed] True
[removed] False
4 points
QUESTION 8
1. Data redundancy can result in requiring unnecessary storage space for the database.
[removed] True
[removed] False
4 points
QUESTION 9
1. Many-many relationships should be converted to associative entities on an Entity-Relationship diagram.
[removed] True
[removed] False
4 points
QUESTION 10
1. There are two modes of data access known as sequential and direct access.
[removed] True
[removed] False
4 points
QUESTION 11
1. Data within a database is typically controlled and manipulated by:
[removed] | A. | MY SQL Workbench |
[removed] | B. | Database Management Software |
[removed] | C. | MS Word |
[removed] | D. | MS Excel |
4 points
QUESTION 12
1. A unique identifier of an entity is ____
[removed] | A. | Relationship |
[removed] | B. | Cardinality |
[removed] | C. | Attribute |
[removed] | D. | Binary |
4 points
QUESTION 13
1. In an M-M relationship, the combination of or the association between two entities is known as ____
[removed] | A. | Cardinality |
[removed] | B. | Modality |
[removed] | C. | Associative entity |
[removed] | D. | Intersection data |
4 points
QUESTION 14
1. A ________ relationship associates occurrences of an entity type with other occurrences of the same entity type.
[removed] | A. | Binary |
[removed] | B. | Tertiary |
[removed] | C. | Unary |
[removed] | D. | Secondary |
4 points
QUESTION 15
1. How many entity types are involved in a tertiary relationship?
[removed] | A. | 1 |
[removed] | B. | 2 |
[removed] | C. | 3 |
[removed] | D. | 4 |
4 points
QUESTION 16
1. The means by which an analyst records, documents, and diagrams the business environment is known as ________.
[removed] | A. | Relationship Identification |
[removed] | B. | Data Association |
[removed] | C. | Data Analysis |
[removed] | D. | Data modeling |
4 points
QUESTION 17
1. In a DBMS, Referential Integrity contains three rules which are:
[removed] | A. | Restrict |
[removed] | B. | Cascade |
[removed] | C. | Set-to-null |
[removed] | D. | Read |
[removed] | E. | All of the above |
[removed] | F. | A, B, and C |
4 points
QUESTION 18
1. The process of arranging attributes of entities in a given business environment into database structures is known as:
[removed] | A. | Physical Database design |
[removed] | B. | Database structuring |
[removed] | C. | Logical Database design |
[removed] | D. | Relationship mapping |
4 points
QUESTION 19
1. Each row of a database is known as a ______
[removed] | A. | File |
[removed] | B. | Field |
[removed] | C. | Entity |
[removed] | D. | Record |
4 points
QUESTION 20
1. An entity’s attribute in a database management system is referred to as a ________.
[removed] | A. | Record |
[removed] | B. | Relationship |
[removed] | C. | Field |
[removed] | D. | Row |
4 points
QUESTION 21
1. A foreign key is defined as _________.
[removed] | A. | The key attribute of an entity |
[removed] | B. | An identifier of the relationship |
[removed] | C. | Primary key of an entity |
[removed] | D. | Primary key of a relation that appears in another relation |
4 points
QUESTION 22
1. An attribute or field that uniquely appears in every row of the relation is known as ____.
[removed] | A. | Key field |
[removed] | B. | Primary Key |
[removed] | C. | Foreign Key |
[removed] | D. | Intersection ID |
4 points
QUESTION 23
1. Each table column in a database entity is commonly known as a ____________.
[removed] | A. | Record |
[removed] | B. | Relationship |
[removed] | C. | Field |
[removed] | D. | Primary Key |
4 points
QUESTION 24
1. The purpose of a database is to _____________.
[removed] | A. | Eliminate redundancy |
[removed] | B. | Centralize data |
[removed] | C. | Integrate data logically |
[removed] | D. | All of the above |
[removed] | E. | None of the above |
QUESTION 1
1. Describe what is an array. Provide examples and uses in VB & C# languages.
QUESTION 2
1. Explain how to derive New Classes from Base Classes. Provide examples and uses in VB & C# languages.
QUESTION 3
1. Describe classes, including constructors, methods, data, value, and reference types. Provide examples and uses in VB & C# languages.
QUESTION 4
1. Describe delegate types. Provide examples and uses in VB & C# languages.
- 8 years ago
- 15
Purchase the answer to view it
- exam.docx