Tag: databases

Questions Related to databases

Data architecture document does not include:
technology databases

  1. Business Data Model

  2. Logical Data Model

  3. Data Management Process Model

  4. Data entity/business function Matrix

  5. Data Interface requirements

Show answer
Correct Option: E

Students -------------< Cars, This graphic indicates
technology databases

  1. that a student can own 0, 1 or many cars

  2. a car can be owned by many students

  3. a student cannot own a car

  4. a stundent can own many cars and a car can be owned by many students

Show answer
Correct Option: A

What is a 'tuple' ?
technology databases

  1. another name for the key linking different tables in a database

  2. another name for a table in an RDBMS

  3. an attribute attached to a record

  4. a row or record in a database table

Show answer
Correct Option: D

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes:
technology databases

  1. logical model

  2. data flow diagram

  3. entity-relationship diagram

  4. data tree

Show answer
Correct Option: C

A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?
technology databases

  1. computer_id

  2. product_id

  3. company_id

  4. employee_id

  5. order_id

Show answer
Correct Option: C

What is a schema ?
technology databases

  1. A diagram showing the domains of all attributes in the data model

  2. A schedule of data modeling steps

  3. A plan of action for database design

  4. A diagram showing the flow of data in an application

  5. A graphical or language representation of a data model or database

Show answer
Correct Option: E

Several pieces of information are captured about a book. This information includes: Title, Author First Name, Author Last Name, Book Genre, and Date Published.   Based on the scenario above, what part of the entity relationship is the Title?
technology databases

  1. Entity

  2. Category

  3. Hierarchy

  4. Relationship

  5. Atttibute

Show answer
Correct Option: E

Which one of the following is NOT a characteristic of metadata?
technology databases

  1. Data about data

  2. Describe a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure

Show answer
Correct Option: D

Which data model represents how the business world sees the information?
technology databases

  1. Logical Data Model

  2. Physical Data Model

  3. Network Data Model

  4. Conceptual Data Model

Show answer
Correct Option: D

Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach
technology databases

  1. third normal form

  2. the standard of a flat file

  3. second normal form

  4. first normal form

Show answer
Correct Option: A