Tag: introduction and importance of ms excel

Quizzes (0) Questions (36)

Questions Related to introduction and importance of ms excel

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

A relation is given an identity by its ___and description by its ____.

  1. schema,name

  2. name ,schema

  3. both of the above

  4. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In database terminology, a relation (table) is identified by its name, while its structure and constraints are defined by its schema. Therefore, the name provides the identity and the schema provides the description.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In relational data model column header is called as_________.

  1. domain

  2. tuple

  3. relation

  4. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In the relational data model, a column header represents an attribute of the entity. Since 'attribute' is not listed as an option, 'None of the above' is the correct choice.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

A column header is called an __________, in relational data model.

  1. Domain

  2. Tuple

  3. Attribute

  4. Relation
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In relational data model, the table name and column names are used to help in interpreting the meaning of values in each row. All values in a column, which belong to a particular domain, are of same data type. A column header is called an attribute.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In database, the ___________ implies that distinct tables have been logically organised and the purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both B and C
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Database has two important properties (or characteristics): one is integrated and second is shared. Integrated property implies that distinct data tables have been logically organised. The purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

The ________ represents the database as collection of relations, which resembles a table of values (or data table).

  1. Relational data model

  2. ER model

  3. Data model

  4. Both A and B
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

A row is called a _________, in relational data model.

  1. Domain

  2. Tuple

  3. Attribute

  4. Relation
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The relational data model represents a table of values (or data table). Each row of the table, therefore, represents a collection of related data values and hence typically corresponds to real world entity or relationship. Formally, a row is called a tuple.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In database, __________ means that all those who are authorised to use data/information have access to relevant data.

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both A and B
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database has two important properties (or characteristics): one is integrated and second is shared. The shared property means that all those who are authorised to use data/information have access to relevant data.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

__________ refers to data that have been processed and organised in a form, which is suitable for decision-making.

  1. Data

  2. Database

  3. Information

  4. Reality
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Information refers to data that have been processed and organised in a form, which is suitable for decision-making, The raw data processed in accordance with decision usefulness of a decision-maker becomes information.