Tag: objective in dbms

Questions Related to objective in dbms

The data storage structures are also called as _________.

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

  1. Database

  2. Data processing

  3. Data tables

  4. Data storage

Show answer
Correct Option: C
Explanation:

The data storage structure are also called as data tables, which are created as a part of structuring database for accounting.

A process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated is _______.

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

  1. ER design

  2. Refinement

  3. Reality

  4. Normalisation

Show answer
Correct Option: D
Explanation:

Normalisation is a process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated.

The steps required in data processing cycle, when thought of in the context of accounting are _____________________.

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

  1. Data capturing, Source documents, Data storage, Generating and Input of data.

  2. Source documents, Input of data, Data storage, Manipulation of data and Output of data.

  3. Source documents, Data capturing, Collecting, Manipulation of data and Interpreting.

  4. None of the above

Show answer
Correct Option: B
Explanation:

Data processing cycle, when thought of in the context of accounting, requires a series of steps that are source documents, input of data, data storage, manipulation of data and output of data.

Accounting transactions of an organisation are documented using a _________.

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

  1. Bill

  2. Invoice

  3. Voucher

  4. None of these

Show answer
Correct Option: C
Explanation:

The first step to capture accounting data from transaction(s) so as to prepare a document, is called voucher that expresses and document an accounting transaction.

Which one of the following is a DataBase Management System?

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

  1. MS Access

  2. MS Excel

  3. MS Outlook

  4. None of the above

Show answer
Correct Option: A
Explanation:

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. 

Which of the following has RDBMS?
i. Access
ii. Excel

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

  1. (i) and (ii)

  2. Only (i)

  3. Only (ii)

  4. None of the above

Show answer
Correct Option: B
Explanation:

Microsoft  Excel and Access are Microsoft's two different application software. They both handle tabular data, but there are still many differences between them. Excel is a spreadsheet application program, but Access is a database program. 

A representational data model through which ER design is transformed into inter-related data tables along with the restriction of rules specified to ensure the consistency and integrity of stored data is _________.

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

  1. Reality

  2. Relational Data Model

  3. ER design

  4. Refinement

Show answer
Correct Option: B
Explanation:

Relational Data Model is a representational data model through which ER design is transformed into inter-related data tables along with the restriction on the form of rules specified to ensure the consistency and integrity of stored data.

To manage a business well is to manage it's future and to manage the future is to manage information is termed as____________.

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

  1. Management information system

  2. Marketing information system

  3. Future information system

  4. General information system

Show answer
Correct Option: A
Explanation:

MIS is the acronym for Management Information Systems. In a nutshell, MIS is a collection of systems, hardware, procedures and people that all work together to process, store, and produce information that is useful to the organization.

The process of designing a database for accounting is best described through a ________.

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

  1. Tree diagram

  2. Flow chart

  3. Pictorial presentation

  4. None of the Above

Show answer
Correct Option: B
Explanation:

The process of designing a database for accounting is best described through a flow chart.

 A flowchart can also be defined as a diagrammatic representation of an algorithm, a step-by-step approach to solving a task.

_____________ is a formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality.

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

  1. ER Design

  2. Relational Data Model

  3. Reality

  4. Refinement

Show answer
Correct Option: A
Explanation:

A formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality is known as ER Design.