MCQ Questions with detailed solutions of Accounting System Using Database

-

  MCQ Questions with detailed solutions of  Accounting System Using Database ##################################



1. In a table “Supplier”, there are fields called “Scode”, “Supplier Name”, “Supplier Address”. …………….. filed should be taken as-

 (a Primary key for being unique. 

(b) Supplier Address 

(c) Supplier 

(d) Scode 


2. A JPEG or an MP3 file will be stored undo …………… data type.

 (a) Binary 

(b) Calendar

 (c) Image 

(d) Music 


3. Base gives us …………….. options to start working with database.

 (a) One

 (b) Two 

(c) Three

 (d) Four


 4. The Table Wizard of Base software which consists of ready made tables divided into ……………. categories.

 (a) One

 (b) Two

 (c) Three 

(d) Four


 5. Tables like Photographs, Recipes, Plants etc are available under ……………. tables list.

 (a) Personal 

(b) Business

 (c) Samples

 (d) Availabl 


6. Text[VARCHAR], Text (fix) [CHAR], Number [Numeric] are all kinds of …………… types. 

(a) Name

 (b) Properties

 (c) Description 

(d) Field


 7. While defining each field, it is associated with _ terms.

 a) One 

b) Two 

c) Three 

d) Four 


8. Creating tables using __ view is more beneficial.

 a) Design

 b) Wizard

 c) Personal 

d) Name 


9. To designate a Primary key_______ click on the field o open a sub-menu. 

a) Left 

b) Right

 c) Top 

d) Bottom 


10. All kinds of facts, figures and details related of people, places, things or events is known as____ 

a) Information 

b) Data 

c) Decisions 

d) Process 


11. _______ can be described as the required result obtained from processing of data. 

a) Information 

b) Data 

c) Decisions 

d) Process 


12 . _______ is nothing but processed data. 

a) Information

 b) Data 

c) Decisions

 d) Process 


13. _______ is a collection of related data items stored in an organized manner. 

a) Data 

b) Office

 c) Database

 d) Library 


14. ________ arrangement of things always makes searching easier as and when required.

 a) Database

 b) Information 

c) Simple 

d) Logical 


15. The underlying structure of database is known as _______. 

a) Data design 

b) Data model 

c) Data structure 

d) None of these 


16. To work with computerized database, a.......... has to be first defined and created. 

a) Field 

b) Table

 c) Database 

d) Query


 17. All tasks related to database handling is known as________


 a) Work system 

b) Tasks

 c) Data transaction

 d) Database management system


 18. Oracle, Ingress, DB2, SQL Server, MS Access are examples of____ 

a) HDD 

b) DBMS

 c) OpenOffice

 d) Base 


19. To keep the database ready with latest up-to-date data, _____ tasks are expected to be performed regularly.

 a) Adding data into database

 b) Editing the content

 c) Removing unnecessary data

 d) All of these 


20. OpenOffice Base is based on a ________ 

a) Relational data model 

b) Relational table 

c) Office model 

d) None of these


 21. Base is a collection of related data objects known as _____ 

a) Tables 

b) Queries 

c) Reports 

d) All of these 


22. ______ is the basic unit for storing data in database. 

a) Desk

 b) Chair

 c) Table

 d) Report 


23. ________ are real world objects about which information is to be stored in database. 

a) Tables

 b) Entities 

c) Queries 

d) Reports 


24. Attributes of an entity are represented in the form of______ 

a) Columns 

b) Rows 

c) Tables 

d) Fields


 25.  Attributes of an entity are also termed as_______

 a) Columns 

b) Rows

 c) Tables 

d) Fields 


##################################

Answers

##################################

1.  (d) Scode

 2.  (a) Binary

 3.  (b) Two 

4.  (b) Two 

5.  (c) Samples 

6.  (d) Field 

7.  (d) Four

 8.  (a) Design 

9.  (b) Right

 10. l (b) Data 

11.  (a) Information 

12.  (a) Information 

13.  (c) Database

 14.   (d) Logical 

15.   (b) Data model 

16.  (c) Database

 17.  (d) Database management system 

18.  (b) DBMS 

19.  (d) All of these 

20.  (a) Relational data mode

l 21.  (d) All of these 

22.  (c) Table 

23.  (b) Entities 

24.  (a) Columns 

25.  (d) Fields

##################################

टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

RESEARCH TOPICS IN SOCIOLOGY

-
चित्र
  RESEARCH TOPICS IN SOCIOLOGY Effects of divorce on children How cross-racial adoption affect children and society? To what extent should parents influence a child’s behavior? How does dingle parenting affect a child? Social programs for children who experience difficulties in communication with parents The changing landscape of gender norms: a sociological perspective on gender identity in modern society. The evolution of the modern family: a sociological investigation into changing family dynamics. Is it possible to raise a healthy child in an unconventional family? Peculiarities of parenting at LGBT families Gender studies for children: should children learn it from childhood or is it too much? Social success middle-class children achieve Sociology of familes and marriage The work of nannies and expectations of employers How to give up helicopter parenting? How did international marriages change within time? How did international marriages influence the national consciousness of th
और पढ़ें

PAPER-BUSINESS ORGANISATION QUESTION BANK

-
चित्र
 PAPER-BUSINESS ORGANISATION QUESTION BANK 1-किसी व्यावसायिक संस्था की स्थापना करते समय किन किन बातों का ध्यान रखा जाना चाहिए? (What are the things to be kept in mind while setting up a business organization?) 2-व्यावसायिक पर्यावरण के विभिन्न घटकों का वर्णन कीजिए।(Describe the various components of business environment.) 3-संयुक्त स्कन्ध कंपनी से आप क्या समझते हैं? एक संयुक्त स्कन्ध कंपनी की स्थापना के संबंध में विभिन्न औपचारिकताओं का वर्णन कीजिए। (What do you understand by Joint Stock Company?  Describe the various formalities regarding the formation of a Joint Stock Company.) 4-संयन्त्र अभिन्यास से आप क्या समझते हैं? इसके उद्देश्य क्या है? संयन्त्र अभिन्यास के विभिन्न प्रकार बताइए। What do you mean by plant layout? What are its objectives? Explain various types of Plant Layouts. 5- व्यावसायिक संगठनों के विभिन्न स्वरूपों का संक्षेप में वर्णन कीजिए। (Briefly describe the various forms of business organizations.) 6-व्यवसाय, पेशा, उद्योग तथा रोजगार की अवधारणा को उदाहरण के साथ स्पष्ट कीजि
और पढ़ें

What do you understand by business? Describe different types of business activities with examples.

-
चित्र
 Questions -What do you understand by business? Describe different types of business activities with examples. Answer -Business refers to the organized effort of individuals or organizations to produce and sell goods or services with the goal of earning a profit. Different types of business activities include: 1. Production: Creating goods or services, e.g., manufacturing, farming, or software development. 2. Distribution: Moving goods or services from the producer to the consumer, e.g., logistics, transportation, or wholesaling. 3. Marketing: Promoting and selling goods or services, e.g., advertising, sales, or branding. 4. Finance: Managing money and investments, e.g., banking, accounting, or investing. 5. Human Resources: Managing employee relations, training, and benefits, e.g., recruitment, talent management, or employee engagement. 6. Research and Development: Creating new products, services, or processes, e.g., innovation, product design, or scientific research. 7. Operations: M
और पढ़ें