Chapter 15-Accounting System Using Database Management System

Important MCQ questions for Class 11 Accountancy Chapter 15-Accounting System Using Database Management System

Get Important MCQ questions for Class 11 Accountancy Chapter 15-Accounting System Using Database Management System with a detailed explanation of all the MCQ questions asked from Chapter 15-Accounting System Using Database Management System prepared by the experts. Find below Selected MCQ-based questions Sets with Answer keys and detailed solutions for Chapter 15-Accounting System Using Database Management System, to find the explanation click on the Answer. 

MCQ Questions for Chapter 15-Accounting System Using Database Management System class 11 Accountancy (Questions set-1) 

Accounting - MCQ on Accounting System Using Database Management System

Class XI

Q. . 1 A collection of interrelated data is called

a. database.

b. database management system.

c. MS-ACCESS.

d. information.

Answer:

(a)

Explanation: All the interrelated data is stored in the form of a table in a database.

Q. 2 The most common database software is

a. Structured Query Language.

b. table.

c. MS-ACCESS.

d. record.

Answer:

(c)

Explanation: Microsoft access is the database software, which can manage all the relevant data. MS-ACCESS is the most common used software, as it is very easy to learn and does not require any programming.

Q. 3 In MS-ACCESS the data is stored in the form of

a. rows.

b. columns.

c. records.

d. tables.

Answer:

(d)

Explanation: In MS-ACCESS the data to be stored is organised in the form of special storage containers called tables.

Q. 4 The components created using ACCESS are called

a. classes.

b. objects.

c. data.

d. files.

Answer:

(b)

Explanation: In Microsoft access data is divided into components, called objects. Such similar objects when grouped together form a class.

Q. 5 The object class used to define tables, store and access information is called

a. forms.

b. pages.

c. queries.

d. macros.

Answer:

(c)

Explanation: Query is an object class used to create tables in order to store information. The stored data can be added, deleted or updated with the help of queries.

Q. 6 Data is organised into information in the form of

a. reports.

b. macros.

c. pages.

d. files.

Answer:

(a)

Explanation: Reports are designed according to the needs of end-user. They act as a source of information content based on tables and queries.

Q. 7 In MS-ACCESS, the object class that allows the designer to create a user interface, is called

a. page.

b. macro.

c. module.

d. form.

Answer:

(d)

Explanation: A form allows a user to interact with the back end of the database with the help of tables and queries.

Q. 8 The functions and subroutines when grouped together form a

a. method.

b. module.

c. class.

d. object.

Answer:

(b)

Explanation: Modules form the base of any database application as they allow users to form a set of instructions to be executed in the form of functions and

sub-routines.

Q. 9 A database can be created in MS-ACCESS by choosing File from menu bar and then

a. clicking at New.

b. clicking at Open.

c. clicking at Edit.

d. clicking at Save as web page.

Answer:

(a)

Explanation: When New is clicked, it opens the task pane to create a new database.

Q. 10 When a table is created in design view, then the three columns provided in the table window are

a. column name, table name and description.

b. field name, data type and description.

c. row number, column number and record.

d. record, page, form.

Answer:

(b)

Explanation: The upper part of the table window contains the above three columns to define the schema of the table being created. The schema is the data stored in a table at a particular instance of time.

Q. 11 The column that is optional in a table is

a. data type.

b. field name.

c. description.

d. record.

Answer:

(c)

Explanation: A table should always contain a field name, which is used to identify each column separately and data type defines the type of data stored. But, description is optional.

Q. 12 Text, memo, number, date/time, currency, yes/no, OLE object and hyperlink all belong to

a. properties.

b. fields.

c. data type.

d. description.

Answer:

(c)

Explanation: All these form the data types provided by a database to store data. Each field name is specified with a data type, which defines the type of data stored in a field.

Q. 13 The range of integers for number data type is

a. -32768 to 32767.

b. -2147483648 to 2147483647.

c. -32767 to 32768.

d. 0 to 255.

Answer:

(a)

Explanation: The number data type can store integers ranging from –32768 to 32767.

Q. 14 OLE stands for

a. Object Loading Execution.

b. Object Linked Embedding.

c. Object Loaded Embedding.

d. Object Linking Embedding.

Answer:

(d)

Explanation: OLE refers to an object that could be a photograph, bar code image or another document created in another software application.

Q. 15 URL stands for

a. United Resource Limited.

b. Union Resource Location.

c. Universal Resource Locator.

d. Universal Reservation Locator.

Answer:

(c)

Explanation: URL is an abbreviation of Uniform Resource Locator, which is the global address of documents and other resources on the World Wide Web.

Q. 16 The property used to label a field in a datasheet is known as

a. field name.

b. caption.

c. input mask.

d. allow name.

Answer:

(b)

Explanation: Caption is a label used for a field in a database to uniquely identify that field.

Q. 17 Format for data entry includes

a. symbols.

b. default value.

c. operators.

d. placeholders and punctuations.

Answer:

(d)

Explanation: Input masks are the format for data entry that includes placeholders and punctuations. It works only for text and date type of fields.

Q. 18 If the caption property is set to blank, the field name becomes

a. default caption.

b. null.

c. blank.

d. caption.

Answer:

(a)

Explanation: The field name becomes the default caption and is used to label the field.

Q. 19 The property applicable to text fields only is

a. Input mask.

b. Format.

c. Required and Indexed.

d. Allow Zero Length.

Answer:

(d)

Explanation: Setting this property to yes/no determines whether a text string with zero length is acceptable or not.

Q. 20 When a list of values are defined to be displayed in a combo or list box, then values must be separated by a

a. .

b. ,

c. /

d. \

Answer:

(b)

Explanation: The values separated by comma indicate the options in a list.

Q. 21 When more than one columns serve as primary key, then they can be selected by

a. pressing Ctrl key and then clicking the fields, which do not serve as a primary key.

b. pressing the Shift key and selecting those columns, which serve as primary key.

c. pressing Ctrl key and selecting the fields, which will serve as primary key.

d. highlighting the columns serving as primary key with a different colour in the table.

Answer:

(c)

Explanation: A primary key helps to uniquely identify table. If more than one column serve as a primary key, then select first field by pressing and holding Ctrl key and click other fields, one by one in the order in which they constitute the primary key.

Q. 22 If we consider the Account Type table for simple transaction vouchers, then the columns describing the attributes of this table will be

a. Code and Name.

b. Type and Code.

c. Employee_id and Account_number.

d. Catid and Category.

Answer:

(d)

Explanation: The Account Type table has two columns: Catid and Category.

The first column specifies the identification value of the category of accounts. This field is the primary key of the table. The second column stores the string of characters, representing the category name.

Q. 23 The data entered in the ‘category’ column of ‘Account Type’ table should be

a. integer.

b. text.

c. memo.

d. OLE object.

Answer:

(b)

Explanation: The category column stores a string of characters, so the data entered in it, should be of text type.

Q. 24 The reference or foreign key used in the Accounts table is

a. Type.

b. Name.

c. Code.

d. Catid.

Answer:

(a)

Explanation: This field is a foreign key to reference Catid field of Account Type table. Its data type and other properties must be same as that of Catid field.

Q. 25 Since, Type is a foreign key for Accounts table, therefore all its properties must be same as Catid. The Index property of Type

a. should be same as that of Catid.

b. can be set to YES.

c. can be set to NULL.

d. can be given any value.

Answer:

(b)

Explanation: This is because Type value in the Accounts table cannot be unique as a number of accounts might belong to a particular category of Account Type table.

Q. 26 The columns in the Employee table of a database for simple transaction vouchers will be

a. Employee_id, Fname, Mname, Lname.

b. Employee_id, Employee_name, Phone_number.

c. Employee_id, Fname, Phone_number.

d. Employee_id, Fname, Mname, Lname, Phone_number, Super_id.

Answer:

(d)

Explanation: This table stores the data pertaining to employees of the organisation and therefore, should have the following columns.

Q. 27 The primary key of the Employee table is

a. Employee_id.

b. Fname.

c. Phone_number.

d. Super_id.

Answer:

(a)

Explanation: A primary key is a key that helps to uniquely identify an object or a row in a table. Thus, Employee_id helps to distinguish an employee from another employee.

Q. 28 The Required and Zero length property of Fname can be set to

a. No and Yes.

b. Null and Yes.

c. Yes and No.

d. Yes and Null.

Answer:

(c)

Explanation: Required property is set to Yes, as an employee would always have a first name and zero length property should be no, as empty field cannot be allowed in first name.

Q. 29 The indexed property of any column, if set to yes, indicates that

a. duplicates are allowed.

b. duplicates are not allowed.

c. each row is assigned a separate index to identify it.

d. each column is indexed in that table.

Answer:

(b)

Explanation: If the indexed property of any column is set to yes, it means that particular column should have a unique value for each row. For a primary key column, the indexed property should always be set to yes.

Q. 30 The allow zero length property of the Phone_number column can be set to

a. yes.

b. no.

c. null.

d. default value.

Answer:

(a)

Explanation: The allow zero length property of this column can be set to yes, as many people may not have phone numbers.

MCQ Questions for Chapter 15-Accounting System Using Database Management System class 11 Accountancy (Questions set-2) 

Q. 31 The Super_id column of Employee table specifies the

a. number referring an employee’s position.

b. number referring position of a superior of an employee.

c. refers to the employee id of the supervisor or immediate superior of the employee.

d. refers to the department id of the supervisor.

Answer:

(c)

Explanation: This column of Employee table refers to the id of the immediate senior of the employee. Its data type is same as that of Employee id.

Q. 32 The table having the columns Vno, Debit and Amount is

a. Voucher Debit.

b. Voucher Credit.

c. Voucher Account.

d. Voucher.

Answer:

(d)

Explanation: This table has been designed to store the transaction data, as contained in a voucher.

Q. 33 The data type of Vdate column is

a. time.

b. date/time.

c. text.

d. memo.

Answer:

(b)

Explanation: Its data type is set to date/time with format set to medium date

(dd-mm-yy), with default value set to Now() to imply current date in Real Time Clock of the computer system.

Q. 34 The two tables maintained under the Compound Vouchers database are

a. Vouchers Name and Vouchers Details.

b. Vouchers Main and Voucher Details.

c. Vouchers Number and Voucher Type.

d. Voucher Number and Prep by.

Answer:

(b)

Explanation: The Vouchers Main table is created to store one record for every transaction and the Voucher Details table is used to store those data items of the voucher, which appear in the grid of debit or credit vouchers.

Q. 35 For a table, its domain is

a. the set of values existing in a column.

b. the set of names of the relations.

c. the set of possible values in a column.

d. the product of number of rows and columns.

Answer:

(c)

Explanation: The domain (or replacement set) of a given function is the set of "input" values” for which the function is defined.

Q. 36 A primary key

a. is the first column of a relation.

b. can have only unique values.

c. can hold only numeric values.

d. stores NULL for unknown values.

Answer:

(b)

Explanation: A primary key distinguishes each row with the help of the values stored in it. Therefore, the values stored in it should be unique.

Q. 37 DBMS stands for

a. Database Management System.

b. Digital Based Mapping System.

c. Database Manipulation Software.

d. Database Mapping System.

Answer:

(a)

Explanation: DBMS is system software, which consists of interrelated databases and operations to manage databases.

Q. 38 The properties of forms are divided into three categories namely

a. format, data and others.

b. decimal places, caption and visible.

c. font colour, line spacing and display when.

d. style, size and colour.

Answer:

(a)

Explanation: Forms have various properties, which are grouped under three classes: format properties, data properties and other properties.

Q. 39 The visible property of a form comes under the category of

a. data properties.

b. other properties.

c. style properties.

d. format properties.

Answer:

(d)

Explanation: The visible property specifies whether the control embedded on the form would be visible or not, when the form is opened.

Q. 40 A small window containing a collection of control objects to be placed on the form is called

a. toolkit.

b. toolbox.

c. property window.

d. control box.

Answer:

(b)

Explanation: A toolbox is a collection of controls that are placed or embedded on the form to provide some meaning or functionality.

Q. 41 You are designing a form and it is necessary for the user to type in, his name. The control used for inputting the user’s name is

a. text box.

b. label.

c. command button.

d. check box.

Answer:

(a)

Explanation: This control is used to provide a blank area for entering the data with or without default values.

Q. 42 A bank needs help to design a form for the various services that they offer. The control that can be used to display the services, and to allow the customers to choose one or more items, is

a. option buttons.

b. text boxes.

c. check boxes.

d. name boxes.

Answer:

(c)

Explanation: Checkboxes are those controls, which gives us an option to select, say, Yes/No or True/False. A checkbox is clicked to select and clicked again to deselect some option. When a checkbox is selected, a check (a tick mark) appears indicating a selection.

Q. 43 HDFC bank provides many services. But, a customer can avail only three services at a time. So, the control that will be used to define the set of values is

a. combo box.

b. check box.

c. radio button.

d. list box.

Answer:

(d)

Explanation: This control allows a user to make a limited choice from a given set of values.

Q. 44 The property used to control the appearance of text within a control is

a. font properties.

b. format.

c. font size.

d. text align.

Answer:

(a)

Explanation: Font properties are meant to control the appearance of text within a control. These are capable of affecting font, its point size, thickness and also whether the text is underlined or italicized.

Q. 45 The data property, which when set to No, makes a control to appear dimmed is

a. validation.

b. enabled and locked.

c. control sequence.

d. input mask.

Answer:

(b)

Explanation: This property is meant to determine whether focus is allowed on the control or not.

Q. 46 The three types of controls in MS-ACCESS are

a. format, list and caption.

b. validation, zero length and default value.

c. bound, unbound and calculated.

d. count, font, colour.

Answer:

(c)

Explanation: These controls directly appear in the form specified in its display control property and inherit many of the properties assigned to the filed.

Q. 47 SELECT vdate, amount

FROM vouchers

WHERE debit=’7110’

is an example of

a. summary query.

b. parameterized query.

c. parameter query.

d. simple query.

Answer:

(d)

Explanation: A simple query is a query that does not involve use of any query function to produce a summary of data.

Q. 48 SELECT code, name, sum(amounts)

FROM vouchers INNER JOIN accounts

ON ( accounts.code= vouchers.debit)

is an example of

a. simple query.

b. summary query.

c. parameter query.

d. count query.

Answer:

(b)

Explanation: A summary query is a query, which uses a function to obtain the aggregate data.

Q. 49 PARAMETERS accountno text (225)

SELECT name

FROM accounts

WHERE code=accountno

The PARAMETERS clause in the above query

a. will declare the variable accountno.

b. will display the accountno.

c. will display code equal to accountno.

d. will return an error.

Answer:

(a)

Explanation: A parameter query prompts a user to enter parameters or criteria through an input box.

Q. 50 The clause used to enable sorting of records is

a. GROUP BY.

b. ASCEND.

c. DESCEND.

d. ORDER BY.

Answer:

(d)

Explanation: The ORDER BY clause is used to display the record in a particular sequence.