Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Data Modeling:

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

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?

  1. purchase_date

  2. credit_card

  3. null

  4. credit_card & product_id

  5. product_id
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

What is an alternate key?

  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
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

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

  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
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation