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
##################################
टिप्पणियाँ
एक टिप्पणी भेजें