CBSE Class 11 Computer Science Working With Table MCQs

Refer to CBSE Class 11 Computer Science Working With Table MCQs provided below. CBSE Class 11 Computer Science MCQs with answers available in Pdf for free download. The MCQ Questions for Class 11 Computer Science with answers have been prepared as per the latest syllabus, CBSE books and examination pattern suggested in Class 11 by CBSE, NCERT and KVS. Multiple Choice Questions for Working With Table are an important part of exams for Class 11 Computer Science and if practiced properly can help you to get higher marks. Refer to more Chapter-wise MCQs for CBSE Class 11 Computer Science and also download more latest study material for all subjects

MCQ for Class 11 Computer Science Working With Table

Class 11 Computer Science students should refer to the following multiple-choice questions with answers for Working With Table in Class 11. These MCQ questions with answers for Class 11 Computer Science will come in exams and help you to score good marks

Working With Table MCQ Questions Class 11 Computer Science with Answers

 

Question : To insert records into the table, the user has to open the _______ first.

a) Table

b) Form

c) Report

d) Record

Answer : Table

 

Question : To open a table, right click on the desired table and select the _______ option from the sub menu visible.

a) Close

b) Open

c) Copy

d) OK

Answer : Open

 

Question : The field names are displayed in a ______ line.

a) Vertical

b) Horizontal

c) Upright

d) All of these

Answer : Horizontal

 

Question : The line consisting of field names is known as _______ line.

a) Horizontal

b) Name

c) Title

d) Field

Answer : Title

 

Question : There are row of_________ boxes below the Title line.

a) Square

b) Empty

c) Filled up

d) None of these

Answer : Empty

 

Question : The job of filling all the empty boxes with appropriate data is known as ______

a) Data Entry

b) Data processing

c) Data filling

d) Data job

Answer : Data Entry

 

Question : In the table datasheet view,there is a small box containing pointing arrow sign in front of the first field.The box is called _____

a) Record Icon Box

b) Field Icon Box

c) Record Selector Box

d) Field Selector Box

Answer : Record Selector Box

 

Question : The black pointing arrow icon in the Record Selector Box is known as the __________.

a) Record arrow

b) Record pointer

c) Record selector

d) Rack pointer

Answer : Record pointer

 

Question : The green icon with flash is the _______ of the table mark.

a) End

b) Beginning

c) Center

d) None of these

Answer : End

 

Question : To add a new record in Datasheet View, scroll to the last row, then _________.

a) Right-click

b) Left-click

c) Click

d) Press enter

Answer : Click

 

Question : The pencil icon is the _______ icon.

a) File

b) Tool

c) Insert

d) Edit

Answer : Edit

 

Question : When the cursor is moved to another record, the correction is automatically...........

a) Removed

b) Saved

c) Restored

d) Inserted

Answer : Saved

 

Question : The bar at the bottom of datasheet view window is called the _____ bar.

a) Vertical

b) Navigation

c) View Record

d) Previous

Answer : Navigation

 

Question : In the _____ type of data type, a square box will be shown in the field.

a) Boolean

b) Numeric

c) Text

d) Integer

Answer : Boolean

 

Question : The process of correcting the data entered previously is known as _____

a) Changing

b) Removing

c) Editing

d) Processing

Answer : Editing

 

Question : A record can be deleted using _______ ways.

a) Four

b) Three

c) Two

d) One

Answer : Two

 

Question : Arranging data systematically in groups or separate according to type is called _____

a) Arranging

b) Separating

c) Grouping

d) Sorting

Answer : Sorting

 

Question : Data______ is a term used for unnecessary duplication or repetition of data.

a) Redundancy

b) Repetition

c) Duplication

d) Sorting

Answer : Redundancy

 

Question : ______ is a process that suggests decomposition of single table into multiple tables.

a) Redundancy

b) Normalization

c) Separation

d) Relationship

Answer : Normalization

 

Question : Decomposition of single table into multiple tables leads to creation of a parent-child _______.

a) Redundancy

b) Normalization

c) Separation

d) Relationship

Answer : Separation

 

Question : The table which contains primary key is known as _____ table.

a) Master

b) Main

c) Sub

d) Primary

Answer : Master

 

Question : ______ can be defined as field or combination of fields whose values are borrowed from another table.

a) Primary Key

b) Composite Key

c) Foreign Key

d) Main Key

Answer : Foreign Key

 

Question : ______ field cannot contain a value that does not exist in its related primary key field.

a) Primary Key

b) Composite Key

c) Foreign Key

d) Main Key

Answer : Foreign Key

 

Question : Combination of more than one field when designated, as a primary key, is also known as ______ primary key.

a) Designated

b) Composite

c) Foreign

d) Main

Answer : Composite

 

Question : Data type for Sale Price field should be selected as ______.

a) Integer

b) Text

c) text fix[CHAR]

d) Decimal

Answer : Decimal

 

Question : The meaning of 'Record 4 of 4 ' is that the table has total ______ records.

a) 8

b) 4

c) 12

d) 0

Answer : 4

 

Question : The data entry in Base is controlled and restricted based on the data type and field ______.

a) Type

b) Property

c) Description

d) Name

Answer : Property

 

Question : The field is _______ if the Boolean type square box is marked with a tick.

a) True

b) False

c) Delete

d) Remove

Answer : True

 

Question : A record can be deleted by using _______ key.

a) Edit

b) Backspace

c) Delete

d) Remove

Answer : Delete

 

Question : is a record deletion ______ box.

a) Message

b) Table

c) Alert

d) Option

Answer : Alert

 

Question : _______ can be done in two ways, ascending and descending.

a) Sorting

b) Organizing

c) Arranging

d) Shuffling

Answer : Sorting

 

Question : Data _______ leads to wastage of storage space and is inefficient for several reasons.

a) Sorting

b) Organizing

c) Fields

d) Redundancy

Answer : Redundancy

 

Question : Final aim of creating and maintaining database is to find ______ as and when needed.

a) Data

b) Database

c) Tables

d) Information

Answer : Information

 

Question : A pin code can be used to _______ identify city and area within city.

a) Differentiate

b) Uniquely

c) Individually

d) None of these

Answer : Differentiate

 

Question : Which out of the Field names like Country ID, County Area and Country Name, can be a primary key ?

a) Country ID

b) County Area

c) Country Name

d) None of these

Answer : Country ID

 

Question : When a master table has composite primary key, tables related with it will hold composite _______ key.

a) Designated

b) Composite

c) Foreign

d) Main

Answer : Foreign

 

Question : Data type for Quantity field should be selected as ________.

a) Integer

b) Text

c) Text fix[CHAR]

d) Decimal

Answer : Integer

 

Question : The user has to press _______ key to select more than two rows simultaneously.

a) Shift

b) Ctrl

c) Alt

d) Page up

Answer : Ctrl

 

Question : The symbol for primary key is in the shape of a

a) Table

b) Row

c) Column

d) Key

Answer : Key

 

Question : Data type for Address Line field should be selected as _________.

a) Integer

b) Text

c) Text fix[CHAR]

d) Text[VARCHAR_IGNORECASE

Answer : Text[VARCHAR_IGNORECASE

 

Question : Establishing ________ between tables restricts the user from entering garbage data in the referenced fields.

a) Connection

b) Restriction

c) Relationship

d) Composite Key

Answer : Relationship

 

Question : The Relationship option is available under the ________ menu.

a) Insert

b) Tools

c) Help

d) File

Answer : Tools

 

Question : To create a relationship between two tables, the data types of the referencing field and the referenced field should be ________.

a) Same

b) Different

c) Compatible

d) Error free

Answer : Same

 

Question : When no unmatched foreign key values exist in the database, the principle is called______.

a) Connection Integrity

b) Restriction Integrity

c) Composite Integrity

d) Referential Integrity

Answer : Referential Integrity

 

Question : There are ________ options available to allow us to maintain referential integrity in database.

a) One

b) Two

c) Three

d) Four

Answer : Four

 

Question : Of the following options _______ is not available in Enforcing referential integrity.

a) Set null

b) No action

c) Set default

d) Add tables

Answer : Add tables

 

Question : The ______ option states that if user is allowed to delete or update referenced values, all the related records should be automatically deleted or updated.

a) Update cascade

b) No Action

c) Set default

d) Set null

Answer : Update cascade

 

Question : There are _________ major types of relationship between any tables of database.

a) One

b) Two

c) Three

d) Four

Answer : Three

 

Question : ______ relationship indicates that one specific record of a particular table has one and only one corresponding record in the other table of the database.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to One

 

Question : A Chair and a Person is a ______ Relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to One

 

Question : One State belonging to multiple cities is a _______ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to Many

 

Question : The ______ relationship occurs in the case of some specific record, which has to be stored more than once in both the tables.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : Many to Many

 

Question : In the field of information technology, the data is the raw material used to produce finished goods is known as ________.

a) Data

b) Description

c) Processing

d) Information

Answer : Information

 

Question : To prevent mistakes in data entry, Base provides a special facility called _____validation.

a) Field Name

b) Field Level

c) Data type

d) Data Text

Answer : Field Level

 

Question : Field _______ determine how the values in the field are stored and displayed.

a) Properties

b) Level

c) Type

d) Text

Answer : Properties

 

Question : _______ property has a combo box next to it stating two values of 'yes' and 'no'

a) Entry Required

b) Auto Value

c) Length

d) Both (A) and (B)

Answer : Both (A) and (B)

 

Question : ________ property is suitable for Text data type.

a) Entry Required

b) Auto Value

c) Length

d) Default value

Answer : Length

 

Question : A _______ property value displays automatically when the user adds a new record to the table.

a) Entry Required

b) Auto Value

c) Length

d) Default value

Answer : Default value

 

Question : ________ property specifies the format for displaying and printing data that a user enters in the field.

a) Auto Value

b) Format

c) Length

d) Default Value

Answer : Format

 

Question : Base provides some _______ formats for Number, Date/Time and Yes/No data types.

a) Predefined

b) Regular

c) Valid

d) Character

Answer : Predefined

 

Question : This icon is used to Add ______ to the active database.

a) Forms

b) Tables

c) Reports

d) Queries

Answer : Tables

 

Question : To create a relationship, use _____ operation to bring the tables into the window.

a) Drag and Drop

b) Drag and Pull

c) Drag

d) Drop

Answer : Drag and Drop

 

Question : In a relationship, a line connecting two fields with label text_____ and _____ are displayed.

a) 1 and m

b) 1 and 1

c) 1 and n

d) 1 and a

Answer : 1 and n

 

Question : Label text 1 is displayed on the side of die _____ key.

a) Composite

b) Foreign

c) Primary

d) Unique

Answer : Primary

 

Question : Label text 1 is displayed on the side of the ______ key.

a) Composite

b) Foreign

c) Primary

d) Unique

Answer : Foreign

 

Question : In the above figure Country lD of the Country table is known as the _____ field.

a) Referenced

b) Referencing

c) Main

d) Refer

Answer : Referenced

 

Question : In the above figure, Country lD of the State table is known as the_______field.

a) Referenced

b) Referencing

c) Main

d) Refer

Answer : Referencing

 

Question : Master records can also be called ____ records.

a) Child

b) Children

c) Transaction

d) Parent

Answer : Parent

 

Question : Transaction records can also be called ______ records.

a) Child

b) Children

c) Teacher

d) Parent

Answer : Child

 

Question : The Relationship line becomes _______ when selected, which helps in Editing the relationship.

a) Visible

b) Invisible

c) Thickened

d) Thin

Answer : Thickened

 

Question : A Class and Class Teacher is an example of ______ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to One

 

Question : Class Teacher and Student is an example of _______ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to Many

 

Question : The most common type of relationship between the tables is_______

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : One to Many

 

Question : An employee with multiple designations or a single designation belonging to multiple employees is an example of ______ relationship.

a) One to One

b) One to Many

c) Many to Many

d) Many to One

Answer : Many to Many

 

Question : To define a field for any table,______ had to be performed.

a) Specify a field name

b) Choose a proper data type

c) Write Description

d) All of these

Answer : All of these

 

Question : Data ______ restricts the values entered in a particular field.

a) Checking

b) Validation

c) Confirmation

d) Restriction

Answer : Validation

 

Question : The Text data type for a particular field is automatically takes the predefined size of______.

a) 30

b) 40

c) 50

d) 60

Answer : 50

 

Question : Base automatically assigns some predefined field size to ______ data types.

a) Numeric

b) Date/Time

c) Yes/No

d) All of these

Answer : All of these

 

Question : The ________ property determines whether the user must enter a value for a particular field to complete record entry.

a) Entry Required

b) Auto Value

c) Length

d) Default value

Answer : Entry Required

 

Question : If a table is not decomposed, _______ values will be populated in all the fields.

a) Null

b) Some

c) Default

d) Random

Answer : Null

More Study Material

CBSE Class 11 Computer Science Working With Table MCQs

We hope students liked the above MCQs for Working With Table designed as per the latest syllabus for Class 11 Computer Science released by CBSE. Students of Class 11 should download the Multiple Choice Questions and Answers in Pdf format and practice the questions and solutions given in above Class 11 Computer Science MCQs Questions on daily basis. All latest MCQs with answers have been developed for Computer Science by referring to the most important and regularly asked topics which the students should learn and practice to get better score in school tests and examinations. Studiestoday is the best portal for Class 11 students to get all latest study material free of cost.

MCQs for Computer Science CBSE Class 11 Working With Table

Expert teachers of studiestoday have referred to NCERT book for Class 11 Computer Science to develop the Computer Science Class 11 MCQs. If you download MCQs with answers for the above chapter daily, you will get higher and better marks in Class 11 test and exams in the current year as you will be able to have stronger understanding of all concepts. Daily Multiple Choice Questions practice of Computer Science and its study material will help students to have stronger understanding of all concepts and also make them expert on all critical topics. You can easily download and save all MCQs for Class 11 Computer Science also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the MCQs which have been developed as per latest course books also refer to the NCERT solutions for Class 11 Computer Science designed by our teachers

Working With Table MCQs Computer Science CBSE Class 11

All MCQs given above for Class 11 Computer Science have been made as per the latest syllabus and books issued for the current academic year. The students of Class 11 can refer to the answers which have been also provided by our teachers for all MCQs of Computer Science so that you are able to solve the questions and then compare your answers with the solutions provided by us. We have also provided lot of MCQ questions for Class 11 Computer Science so that you can solve questions relating to all topics given in each chapter. All study material for Class 11 Computer Science students have been given on studiestoday.

Working With Table CBSE Class 11 MCQs Computer Science

Regular MCQs practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Working With Table concepts. MCQs play an important role in developing understanding of Working With Table in CBSE Class 11. Students can download and save or print all the MCQs, printable assignments, practice sheets of the above chapter in Class 11 Computer Science in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 11 Computer Science MCQ Test for the same chapter

CBSE MCQs Computer Science Class 11 Working With Table

CBSE Class 11 Computer Science best textbooks have been used for writing the problems given in the above MCQs. If you have tests coming up then you should revise all concepts relating to Working With Table and then take out print of the above MCQs and attempt all problems. We have also provided a lot of other MCQs for Class 11 Computer Science which you can use to further make yourself better in Computer Science

Where can I download latest CBSE MCQs for Class 11 Computer Science Working With Table

You can download the CBSE MCQs for Class 11 Computer Science Working With Table for latest session from StudiesToday.com

Can I download the MCQs of Working With Table Class 11 Computer Science in Pdf

Yes, you can click on the links above and download topic wise MCQs Questions PDFs for Working With Table Class 11 for Computer Science

Are the Class 11 Computer Science Working With Table MCQs available for the latest session

Yes, the MCQs issued by CBSE for Class 11 Computer Science Working With Table have been made available here for latest academic session

How can I download the Working With Table Class 11 Computer Science MCQs

You can easily access the links above and download the Working With Table Class 11 MCQs Computer Science for each topic

Is there any charge for the MCQs with answers for Class 11 Computer Science Working With Table

There is no charge for the MCQs and their answers for Class 11 CBSE Computer Science Working With Table you can download everything free

How can I improve my MCQs in Class 11 Computer Science Working With Table

Regular revision of MCQs given on studiestoday for Class 11 subject Computer Science Working With Table can help you to score better marks in exams

What are MCQs for Class 11 Computer Science Working With Table

Multiple Choice Questions (MCQs) for Working With Table Class 11 Computer Science are objective-based questions which provide multiple answer options, and students are required to choose the correct answer from the given choices.