Tag: accountancy

Questions Related to accountancy

Which of the following statements are correct for Relational Data Model (RDM):
a. Relational Data Model (RDM) is the most popular and widely used in actual practice.
b. Relational data model represents the database as collection of relations, which resembles  a table of values. 

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

  1. Only "a" is correct.

  2. Only "b" is correct.

  3. Both "a" and "b" are correct.

  4. None of the above is correct.

Show answer
Correct Option: C
Explanation:

The relational data model represents the database as collection of relations, which resembles 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. Among several representational models, Relational Data Model (RDM) is the most popular and widely used in actual practice. 

The value of each attribute of a relation must be an indivisible value and drawn out of possible values associated with its ________. 

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

  1. Entity

  2. Key

  3. Domain

  4. Referential

Show answer
Correct Option: C
Explanation:

The domain is one of the constraints, which can be specified on relational databases. The value of each attribute of a relational must be an indivisible value and drawn out of possible values associated with its domain. The value of an attributed, therefore, must conform to the data type associated with the domain.

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

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

  1. Accounting database

  2. Relational database

  3. data management

  4. Database technology

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 is a set of relation states such that every relational database state satisfies the integrity constraints specified on relational database schema.

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

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

  1. relational data

  2. entity integrity

  3. referential integrity

  4. entity relationship

Show answer
Correct Option: A

While key and entity constraints are specified on individual relation, the referential integrity constraints is specified between _________ relations. 

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

  1. one or more

  2. two or more

  3. one or two

  4. none of the above

Show answer
Correct Option: B
Explanation:

While key and entity constraints are specified on individual relation, the referential integrity constraints is specified between two or more relations. This constraint is specified to maintain consistency among the tuples of such relations.

The two categories of operations on relational model are ______ and ______.

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

  1. Insert, Delete

  2. Updates, Retrieval

  3. Updates, Delete

  4. Retrieval, Insert

Show answer
Correct Option: B
Explanation:

A relational database schema is a set relation schemas and integrity constraints. It is a set of relation states such that relational database state satisfies the integrity constraints specified on relational database schema. There are two categories of operations on relational model: updates and retrieval. Update operation are of three basic types i.e. insert, delete and modify. Retrieval operation on relational data model does not cause violation of any integrity constraints.

__________ is the object class used to create various reports., the source of information content of which is based on tables, queries or both.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Forms

  2. Tables

  3. Pages

  4. Reports

Show answer
Correct Option: D

The object class which allows a database designer to create the data tables with their respective field names, data types is called ________.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. queries

  2. tables

  3. forms

  4. reports

Show answer
Correct Option: B

A _________ is a list of macro-oriented actions that run as a unit. 

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. report

  2. page

  3. table

  4. macro

Show answer
Correct Option: D

______ reports contain information useful for decision-making situations that the user have anticipated to occur. 

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Scheduled

  2. Programmed

  3. Protected

  4. Unprotected

Show answer
Correct Option: B
Explanation:

Programmed reports contain information useful for decision-making situations that the user have anticipated to occur. There are two types of reports within this reports type: Scheduled and on demand.