• databases Online Quiz - 33
Back
0

databases Online Quiz - 33

Description: databases Online Quiz - 33
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

AI Explanation

To answer this question, you need to understand the concept of a schema. Let's go through each option to understand why it is correct or incorrect:

Option A) A diagram showing the domains of all attributes in the data model - This option is incorrect because a schema does not specifically refer to a diagram showing the domains of all attributes in the data model. While a schema may include information about attribute domains, it is not limited to just this aspect.

Option B) A schedule of data modeling steps - This option is incorrect because a schema is not a schedule of data modeling steps. A schema is a representation of a data model or database, not a schedule or plan.

Option C) A plan of action for database design - This option is incorrect because a schema is not a plan of action for database design. It is a representation of the database structure or data model, not a plan for how to design the database.

Option D) A diagram showing the flow of data in an application - This option is incorrect because a schema is not specifically a diagram showing the flow of data in an application. While a schema may include information about data flow, it is not limited to just this aspect.

Option E) A graphical or language representation of a data model or database - This option is correct because a schema is indeed a graphical or language representation of a data model or database. It describes the structure and organization of the data, including tables, columns, relationships, and constraints.

The correct answer is Option E. This option is correct because it accurately describes what a schema is, which is a graphical or language representation of a data model or database.

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

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Data about data - This option is a characteristic of metadata. Metadata is information that describes other data, providing context and meaning.

Option B) Describe a data dictionary - This option is not a characteristic of metadata. A data dictionary is a separate resource that provides a detailed description of the data elements within a dataset. While a data dictionary may contain metadata, it is not a characteristic of metadata itself.

Option C) Self-describing - This option is a characteristic of metadata. Metadata is designed to be self-describing, meaning it provides information about the structure, format, and meaning of the data it describes.

Option D) Includes user data - This option is not a characteristic of metadata. Metadata does not include the actual user data itself, but rather provides information about the user data.

Option E) Supports its own structure - This option is a characteristic of metadata. Metadata often has its own structure or format that allows for consistent representation and interpretation.

The correct answer is D) Includes user data. This option is not a characteristic of metadata because metadata does not include the actual user data; it provides information about the user data.

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

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

AI Explanation

To answer this question, we need to understand the concept of an atomic field.

An atomic field is a field that contains a single value. It can only store a single piece of data. This means that it cannot contain multiple values or be used to store collections of data.

Now, let's go through each option to understand why it is correct or incorrect:

Option A) A key that contains only a single field - This option is incorrect because an atomic field is not necessarily a key. It can be any field that stores a single value.

Option B) A key field - This option is incorrect because an atomic field is not necessarily a key. It can be any field that stores a single value.

Option C) A numerical field - This option is incorrect because an atomic field can store any type of data, not just numerical values.

Option D) A single valued field - This option is correct because an atomic field is a field that contains only a single value.

Therefore, the correct answer is D) a single valued field. This option is correct because it accurately describes the concept of an atomic field.

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

What can a mandatory one to one relationship indicate?

technology databases

  1. More entities are needed

  2. The model should be denormolized

  3. The tables are not properly indexed

  4. The model cannot be implemented physically

  5. More attributes are needed

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions