Tag: concept of entity and relationship

Quizzes (0) Questions (43)

Questions Related to concept of entity and relationship

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

Which of the following statement is correct for queries object?
a. This object class allows a database designer to create the data tables with their respective field names.
b. This object class is meant to create the SQL compatible query statement with the help of Geometrical User Interface (GUI).

  1. Only a

  2. Only b

  3. Both a and b

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

Queries object class is meant to create the SQL compatible query statement with or without the help of Graphic User Interface (GUI) to define tables, store data and retrieves both data and information.

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

The need for which is anticipated, the information content of which may not be useful but casually required are known as casual reports.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The need for which is not anticipated, the information content of which may be useful but casually required are known as casual reports.These are adhoc reports and are generated casually by executing some simple queries without requiring much of professional assistance.

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

_________ reports are generated only on the triggering of some event.

  1. Scheduled

  2. Causal

  3. On demand

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

The reports, which are generated only on the triggering of some event are called On demand reports. Some examples of on demand reports are customer's statement of account, inventory re-order report, Stock in hand report for a selected group of items, etc.

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

The process of generating  accounting reports in access involves which of the following steps?

  1. Designing the report, Identifying accounting information queries, Using the record set of final MDB

  2. Designing the report, Identifying accounting information queries, Using the record set of final SQL

  3. Designing the report, Identifying data analysis, Using the record set of final SQL

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

The process of generating accounting reports in access involves three steps: Designing the report, Identifying the accounting information queries, and finally creating an accounting report by using such queries.

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

Every report is collection of related information for a particular need and purpose and must meet the twin objectives of reporting.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A report is prepared with a definite objective. Every report is collection of related information for a particular need and purpose and must meet the twin objectives of reporting: one to reduce the level of uncertainty that is faced by a decision-maker; second to influence the behavior (or positive actions) of the decision-maker.

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

The record set of final SQL that relies upon preceding SQL statement, is collection of report-oriented information. 

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The record set of final SQL that relies upon preceding SQL statement, is collection of report-oriented information. This record set need be embedded in the report being produced.

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

_________ are meant to create the SQL compatible query statement with or without the help of Graphic User Interface to define tables, store data and retrieve both data and information.

  1. Tables

  2. Queries

  3. Pages

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

Queries are the database objects used to retrieve, filter, and manipulate data from tables using SQL or graphical interfaces.

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

The object class meant to create data access pages, which can be posted on a website of an organisation using internet or sent via e-mail is called _________.

  1. forms

  2. tables

  3. reports

  4. pages
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data access pages are specialized HTML files created in older versions of MS Access to allow database interaction over the web or via email.

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

A positive net amount implies a _________ and _________ amount implies a credit.

  1. debit, positive

  2. debit, credit

  3. debit, negative

  4. credit, positive
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In accounting database models, positive values are typically assigned to debits, while negative values are assigned to credits to allow for simple summation.

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

__________ report design appears on the RHS of Database Window as object under reports.

  1. Balance sheet

  2. Trial balance

  3. Profit and loss

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

In the context of the specific database accounting model being referenced, the trial balance report is the object saved and displayed under the reports list.