Tag: databases

Questions Related to databases

An atomic field is
technology databases

  1. a key that contains only a single field

  2. a key field

  3. a numerical field

  4. a single valued field

Show answer
Correct Option: D

The ER Model is meant to
technology databases

  1. replace relational design

  2. be close to a users perception of the data

  3. enable detailed descriptions of data query processing

  4. enable low level descriptions of data

Show answer
Correct Option: B

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:
technology databases

  1. system planning and selection

  2. systems design

  3. systems analysis

  4. systems implementation and operation

  5. systems evaluation

Show answer
Correct Option: C

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the:
technology databases

  1. top-down approach

  2. bottom-up approach

  3. overview approach

  4. business approach

  5. conceptual approach

Show answer
Correct Option: A

Data Modeling:

technology databases

  1. is achieved using an information flow digram

  2. uses a dataflow diagram

  3. is necessary to remove database anomalies through normalization

  4. is the same as process modelling

  5. is all of the above

Show answer
Correct Option: C

create table Purchaser{ name string, credit_card integer (primary key), address string } create table Product{ product_id integer (primary key), product_name string } create table Purchaser_Product{ credit_card integer, product_id integer, purchase_date date } Based on the sample code above, what is the primary key in the Purchaser_Product table?
technology databases

  1. purchase_date

  2. credit_card

  3. null

  4. credit_card & product_id

  5. product_id

Show answer
Correct Option: D

What is an alternate key?
technology databases

  1. The relationship between more than one entity which has more than one attribute

  2. An attribute that cannot easily identify a record, but can easily viewed as a field

  3. An attribute, other than primary key, that can be used to identify an instance of an entity

  4. A non-distinguishable primary key which is not used to identify fields or records

  5. A primary key with two or more columns on a non-clustered index

Show answer
Correct Option: C

A Banking and Financial Customer is interested to have an overview of a transactional data of their systems. Which of the following data model is suitable to fulfill the customer requirements?

technology databases

  1. Business Data Model

  2. Transactional Data Model

  3. Logical Data Model

  4. Conceptual Data Model

  5. Physical Data Model

Show answer
Correct Option: D

Which of the following statements best describe the function of an entity relational model?
technology databases

  1. An ER model is concerned primarily with a physical implementation of the data and secondly with a logical view

  2. An ER model provides a view of the logic of the data and not the physical implementation

  3. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation

  4. An ER model is entirely concerned with modelling the physical implementation

Show answer
Correct Option: B

If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?

technology databases

  1. Non-identifying

  2. Normalizing

  3. Categorizing

  4. Identifying

  5. Emphasizing

Show answer
Correct Option: D