Question 1

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

technology databases

that a student can own 0, 1 or many cars
a car can be owned by many students
a student cannot own a car
a stundent can own many cars and a car can be owned by many students

Answer

Correct Option: A

Question 2

What is a 'tuple' ?

technology databases

another name for the key linking different tables in a database
another name for a table in an RDBMS
an attribute attached to a record
a row or record in a database table

Answer

Correct Option: D

Question 3

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

technology databases

logical model
data flow diagram
entity-relationship diagram
data tree

Answer

Correct Option: C

Question 4

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

computer_id
product_id
company_id
employee_id
order_id

Answer

Correct Option: C

Question 5

What is a schema ?

technology databases

A diagram showing the domains of all attributes in the data model
A schedule of data modeling steps
A plan of action for database design
A diagram showing the flow of data in an application
A graphical or language representation of a data model or database

Answer

Correct Option: E

Question 6

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

Entity
Category
Hierarchy
Relationship
Atttibute

Answer

Correct Option: E

Question 7

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

technology databases

Data about data
Describe a data dictionary
Self-describing
Includes user data
Supports its own structure

Answer

Correct Option: D

Question 8

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

technology databases

Logical Data Model
Physical Data Model
Network Data Model
Conceptual Data Model

Answer

Correct Option: D

Question 9

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

technology databases

third normal form
the standard of a flat file
second normal form
first normal form

Answer

Correct Option: A

Question 10

An atomic field is

technology databases

a key that contains only a single field
a key field
a numerical field
a single valued field

Answer

Correct Option: D

Question 11

The ER Model is meant to

technology databases

replace relational design
be close to a users perception of the data
enable detailed descriptions of data query processing
enable low level descriptions of data

Answer

Correct Option: B

Question 12

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

technology databases

system planning and selection
systems design
systems analysis
systems implementation and operation
systems evaluation

Answer

Correct Option: C

Question 13

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

top-down approach
bottom-up approach
overview approach
business approach
conceptual approach

Answer

Correct Option: A

Question 14

Data Modeling:

technology databases

is achieved using an information flow digram
uses a dataflow diagram
is necessary to remove database anomalies through normalization
is the same as process modelling
is all of the above

Answer

Correct Option: C

Question 15

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

purchase_date
credit_card
null
credit_card & product_id
product_id

Answer

Correct Option: D

Question 16

What is an alternate key?

technology databases

The relationship between more than one entity which has more than one attribute
An attribute that cannot easily identify a record, but can easily viewed as a field
An attribute, other than primary key, that can be used to identify an instance of an entity
A non-distinguishable primary key which is not used to identify fields or records
A primary key with two or more columns on a non-clustered index

Answer

Correct Option: C

Question 17

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

Business Data Model
Transactional Data Model
Logical Data Model
Conceptual Data Model
Physical Data Model

Answer

Correct Option: D

Question 18

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

technology databases

An ER model is concerned primarily with a physical implementation of the data and secondly with a logical view
An ER model provides a view of the logic of the data and not the physical implementation
An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation
An ER model is entirely concerned with modelling the physical implementation

Answer

Correct Option: B

Question 19

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

technology databases

Non-identifying
Normalizing
Categorizing
Identifying
Emphasizing

Answer

Correct Option: D

Question 20

What can a mandatory one to one relationship indicate?

technology databases

More entities are needed
The model should be denormolized
The tables are not properly indexed
The model cannot be implemented physically
More attributes are needed

Answer

Correct Option: E

Description: databases Online Quiz - 33
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 33

Find more quizzes from top tags