CBSE Class 11 Computer Science Working With Table MCQs

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