Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Data architecture document does not include:

Business Data Model
Logical Data Model
Data Management Process Model
Data entity/business function Matrix
Data Interface requirements

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What is a 'tuple' ?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

logical model
data flow diagram
entity-relationship diagram
data tree

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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 ?

computer_id
product_id
company_id
employee_id
order_id

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What is a schema ?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

Entity
Category
Hierarchy
Relationship
Atttibute

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
417
418
419
420
421
422
423
424
425
…
486
487
Next →