Tag: micosoft office

Questions Related to micosoft office

Among several representational models, __________ is the most popular and widely used in actual practice.

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

  1. ER Model

  2. Relational Data Model

  3. Data Model

  4. Both ER Model and Relational Data Model

Show answer
Correct Option: B
Explanation:

Among several representational models, Relational Data Model (RDM) is the most popular and widely used in actual practice. It represents the database as collection of relations, which resembles a table of values (or data table).

__________ is defined as a set of programs, which are designed and developed for a community of users and not for any particular application with respect to a particular user.

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

  1. Data-purpose software

  2. General-purpose software

  3. General-purpose hardware

  4. Data software

Show answer
Correct Option: B
Explanation:

Database management system (DBMS) may be defined as a general-purpose software system that facilitates the processes of defining, constructing and manipulating (or processing) databases for various applications, General-purpose software is defined as a set of programs, which are designed and developed for a community of users and not for any particular application with respect to a particular user.

The data type describing the types of values (such as text value, numeric values, data values, currency value, etc.) that can appear in each column is called a ________, which is a set of indivisible values.

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

  1. Tuple

  2. Domain

  3. Attriibute

  4. Row

Show answer
Correct Option: B
Explanation:

The data type describing the types of values (such as text value, numeric values, data values, currency value, etc.) that can appear in each column is called a domain. A domain is a set of indivisible values.

When a relation has more than one attribute with unique values, each such attribute is called:

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

  1. Multi-valued

  2. Full functional

  3. Half functional

  4. None of the above

Show answer
Correct Option: B
Explanation:

An attribute is fully functional dependent on another attribute, if it is Functionally Dependent on that attribute and not on any of its proper subset. For example, an attribute Q is fully functional dependent on another attribute P, if it is Functionally Dependent on P and not on any of the proper subset of P.

The four constraints that can be specified on relational databases are _____________________.

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

  1. Domain constraints, Key constraints, Entity integrity constraints and Referential integrity constraints.

  2. Key constraints, Database constraints, Normalisation constraints and Referential integrity constraints.

  3. Domain constraints, Database constraints, Normalisation constraints and Entity integrity constraints.

  4. None of these.

Show answer
Correct Option: A
Explanation:

There are four different constraints, which can be specified on relational databases. They are domain constraints; key constraints; entity integrity constraints and referential integrity constraints.

A __________ is a set of tuples wherein each tuple is an ordered list of values corresponding to attributes of relation.

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

  1. Data

  2. Relation

  3. Database

  4. Attribute

Show answer
Correct Option: B
Explanation:

A relation represents an entity type. A relation (or relation state) is a set of tuples wherein each tuple is an ordered list of values corresponding to attributes of relation.

Each row of a table is called a _________, in relational data model.

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

  1. Data record

  2. Data table

  3. Data system

  4. Data process

Show answer
Correct Option: A
Explanation:

The relational data model represents the database as collection of relations, which resembles a table of values (or data table). The table name and column names are used to help in interpreting the meaning of values in each row. Each row of a table is called a data record.

Each simple attribute of an entity type is associated with a value set called _____ of values.

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

  1. Liveware

  2. Timeware

  3. Entityware

  4. None of the Above

Show answer
Correct Option: B
Explanation:

Each simple attribute of an entity type is associated with a value set called timeware of values.

A __________ is a set of relation schemas and a set of integrity constraints.

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

  1. Relational database

  2. Relational database schema

  3. Relational schema

  4. Database schema

Show answer
Correct Option: B
Explanation:

A relational database schema is a set of relation schemas and a set of integrity constraints. A relational database state is a set of relation state such that every relational database state satisfies the integrity constraints specified on relational database schema.

Entity integrity constraint states that no ______ key value can be null because it is used to identify individual tuple in a relation.

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

  1. Secondary

  2. Primary

  3. Partial

  4. Particular

Show answer
Correct Option: B
Explanation:

Entity integrity constraint is one of the constraints on relational database. It states that no primary key value can be null because it is used to identify individual tuple in a relation. Null value implies that we cannot identify such tuples or identify these as alike. A failure to distinguish them means they are duplicates.