Reading Mode - 11th(ENG)

MCQ 1 Entry Required

Which of the following property is equivalent to NOT NULL?

A Length

B Default

C Required

D Format

MCQ 2 Entry Required

Which of the following operations cannot be performed on a record in database?

A Insert

B Delete

C Hide

D Update

MCQ 3 Entry Required

Which of the following represents maximum levels of sorting provided by Base Wizard?

A 3

B 4

C 5

D 6

MCQ 4 Entry Required

Which of the following refers to data redundancy?

A Deletion of data

B Repetition of data

C Decomposition of tables

D Relationships of tables

MCQ 5 Entry Required

Given a relation, Teacher-Subject (Tcode, Scode, Standard), which of the following fields can be an appropriate foreign key field?

A Tcode

B Scode

C Tcode,Standard

D Tcode,Scode

MCQ 6 Entry Required

Which of the following statement is incorrect?

A Every table must have a primary key.

B Primary key can be combination of fields.

C Data type of Primary key and foreign key should be same.

D Names of Primary key and foreign key should be same.

MCQ 7 Entry Required

Which of the following type of relationship exists between Student and Teacher in a school?

A One to One

B One to Many

C Many to Many

D No relationship exists

MCQ 8 Entry Required

Which of the following type of relationship exists between Student and Class Teacher in a school?

A One to One

B One to Many

C Many to Many

D No relationship exists

MCQ 9 Entry Required

Which of the following options are possible to implement referential integrity?

A No Action

B Set Null

C Delete table

D Update Cascade

MCQ 10 Entry Required

AutoValue property can be set for field with which of the following datatype?

A Text

B Image

C Integer

D Boolean

MCQ 11 Entry Required

Which of the following statement is true for Default field property in Base?

A Default value can be numeric value only.

B Default value once set can be changed later.

C Default value cannot be greater than 500.

D Default value should be greater than value set in Length.

MCQ 12 Entry Required

To get the correct information at right time; database have to prepare and perform various operations like

A inserting data

B editing the previously and wrong data

C delete unnecessary and wrong data

D all of the above

MCQ 13 Entry Required

In Base, the line consisting of field names is known as..................

A Heading line

B Title line

C Main line

D Description line

MCQ 14 Entry Required

In front of the first field there is a small box that contain a pointing arrow sign . This box is known as......................

A Record Selector Box

B Record Deletion Box

C Record Icon

D Record Filling Box

MCQ 15 Entry Required

The black pointing arrow icon is known as the .............that indicate current record of the table at any given moment of time.

A record pointer

B record mover

C record selector

D record hider

MCQ 16 Entry Required

Which icon with flash is the end of the table mark.

A Black

B Green

C Red

D Yellow

MCQ 17 Entry Required

The pencil icon is an...........Icon.

A Edit

B Add

C Insert

D Delete

MCQ 18 Entry Required

To keep our database precise and meaningful,it is very much necessary to ..... unnecessary or incorrect record from the table.

A delete

B edit

C insert

D none of them

MCQ 19 Entry Required

To delete a record press.............key after selecting the record.

A Del

B Esc

C Ctrl

D Alt

MCQ 20 Entry Required

While deleting the record, Base will display a dialog box with a ...........message.

A warning

B update

C upload

D save

MCQ 21 Entry Required

To sort the field , select the required field and then click on .......... button.

A Sort Ascending

B Sort Descending

C A or B

D none of them

MCQ 22 Entry Required

Database designers attempt to criminate redundant data as far as possible by using a technique

A Data Normalization

B Data Abstraction

C Polymorphism

D None of them

MCQ 23 Entry Required

which is a process that suggests decomposition of single table into multiple tables, thus creating a parent-child relationship.

A Normalization

B Abstraction

C polymorphism

D None of them

MCQ 24 Entry Required

The table which contains primary key is known as ............... table.

A Master

B Transaction

C Multiple

D Main

MCQ 25 Entry Required

which key can be defined as field or combination of fields whose values are borrowed from another table.

A Primary

B Foreign

C Composite

D Master

MCQ 26 Entry Required

which key can be defined as combination of fields whose values are borrowed from another table.

A Primary

B Foreign

C Composite

D Master

MCQ 27 Entry Required

Under which menu Relationship option is available ?

A File

B Relation

C Create

D Tools

MCQ 28 Entry Required

What operation should be carried out to create relationship ?

A drag and drop

B right click

C double click

D none of them

MCQ 29 Entry Required

In what type of relationship , one value of referred table is associated with multiple values in referencing table ?

A One to Many

B One to One

C Many to Many

D Many to One

MCQ 30 Entry Required

Which option states that a user should not be allowed to delete or update any record exists in some other table ?

A No Action

B Update cascade

C Set null

D set default

MCQ 31 Entry Required

Which option states if user deletes or updates the referenced field , all the related records will hold null value in the related field ?

A No Action

B Update cascade

C Set null

D set default

MCQ 32 Entry Required

How many types of relationship can be created between tables of the database ?

A one

B two

C three

D four

MCQ 33 Entry Required

Which type of relationship is created between Chair and Person ?

A One to One

B One to Many

C Many to one

D Many to Many

MCQ 34 Entry Required

Which type of relationship is created between class teacher and student ?

A One to One

B One to Many

C Many to one

D Many to Many

MCQ 35 Entry Required

Which type of relationship is created between state and city ?

A One to One

B One to Many

C Many to one

D Many to Many

MCQ 36 Entry Required

which relationship occurs in the case or 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 one

D Many to Many

MCQ 37 Entry Required

In the field of information technology , the data in the raw material used to produce finished goods known as what?

A Data

B Information

C Table

D Row

MCQ 38 Entry Required

To prevent mistakes , base provides a special facility called what?

A Row Level Validation

B Field Level Validation

C Table Level Validation

D Database Level Validation

MCQ 39 Entry Required

Field Properties can be decided at the time of .......... the structure of the table.

A data entry

B designing

C deleting

D updating

MCQ 40 Entry Required

What is the default length for Text data type ?

A 8

B 16

C 32

D 50

MCQ 41 Entry Required

Which field properly allow to specify field size as per requirement?

A Auto Value

B Size

C Length

D Default Size

MCQ 42 Entry Required

Which field property store some predefined default value automatically in a particular field at the time of entering a new record in the table?

A Auto Value

B Size

C Length

D Default Size

MCQ 43 Entry Required

Which field properly specifies the format for displaying and printing the data entered in the field ?

A Format

B Display

C Show

D None of them

MCQ 44 Entry Required

What is the format code for displaying date in the format Dec 31 ,2022?

A MMM D , YY

B MMM DD , YY

C MM DD , YY

D Mmm DD , YYYY

MCQ 45 Entry Required

Which option states that if user is allowed to delete or update referenced values , all the related records will hold null value in the related field ?

A No action

B Update cascade or Delete cascade

C Set null

D set default

MCQ 46 Entry Required

Each unique value stored in primary key field may be repeated a number of times in.....key.

A composite primary

B foreign

C master

D primary

MCQ 47 Entry Required

Select.........to open Add Tables dialog box in relationship window.

A Insert -> Add Tables

B Add-> Tables

C Add Tables -> Insert

D Edit-> Add Tables

MCQ 48 Entry Required

In warning message , clicking on which button will delete the selected record permanently?

A yes

B No

C Ok

D Cancel

MCQ 49 Entry Required

The process of correcting the data entered previously is known as............

A Editing

B Inserting

C Deleting

D None of them

MCQ 50 Entry Required

In Base, the line consisting of field names is known as..................

A Heading line

B Title line

C Main line

D Description line

MCQ 51 Inserting Data in the Table

Which of the following operations cannot be performed on a record in database?

A Insert

B Delete

C Hide

D Update

MCQ 52 Inserting Data in the Table

Which of the following represents maximum levels of sorting provided by Base Wizard?

A 3

B 4

C 5

D 6

MCQ 53 Inserting Data in the Table

Which of the following refers to data redundancy?

A Deletion of data

B Repetition of data

C Decomposition of tables

D Relationships of tables

MCQ 54 Inserting Data in the Table

Which of the following statement is incorrect?

A Every table must have a primary key.

B Primary key can be combination of fields.

C Data type of Primary key and foreign key should be same.

D Names of Primary key and foreign key should be same.

MCQ 55 Inserting Data in the Table

Which of the following type of relationship exists between Student and Teacher in a school?

A One to One

B One to Many

C Many to Many

D No relationship exists

MCQ 56 Inserting Data in the Table

Which of the following type of relationship exists between Student and Class Teacher in a school?

A One to One

B One to Many

C Many to Many

D No relationship exists

MCQ 57 Inserting Data in the Table

Which of the following options are possible to implement referential integrity?

A No Action

B Set Null

C Delete table

D Update Cascade

MCQ 58 Inserting Data in the Table

AutoValue property can be set for field with which of the following datatype?

A Text

B Image

C Integer

D Boolean

MCQ 59 Inserting Data in the Table

Which of the following statement is true for Default field property in Base?

A Default value can be numeric value only.

B Default value once set can be changed later.

C Default value cannot be greater than 500.

D Default value should be greater than value set in Length.

MCQ 60 Inserting Data in the Table

Which of the following property is equivalent to NOT NULL?

A Length

B Default

C Required

D Format

📖 Reading Mode: 11th(ENG) - GSEB Board

Which of the following property is equivalent to NOT NULL?

Which of the following operations cannot be performed on a record in database?

Which of the following represents maximum levels of sorting provided by Base Wizard?

Which of the following refers to data redundancy?

Given a relation, Teacher-Subject (Tcode, Scode, Standard), which of the following fields can be an appropriate foreign key field?

Which of the following statement is incorrect?

Which of the following type of relationship exists between Student and Teacher in a school?

Which of the following type of relationship exists between Student and Class Teacher in a school?

Which of the following options are possible to implement referential integrity?

AutoValue property can be set for field with which of the following datatype?

Which of the following statement is true for Default field property in Base?

To get the correct information at right time; database have to prepare and perform various operations like

In Base, the line consisting of field names is known as..................

In front of the first field there is a small box that contain a pointing arrow sign . This box is known as......................

The black pointing arrow icon is known as the .............that indicate current record of the table at any given moment of time.

Which icon with flash is the end of the table mark.

The pencil icon is an...........Icon.

To keep our database precise and meaningful,it is very much necessary to ..... unnecessary or incorrect record from the table.

To delete a record press.............key after selecting the record.

While deleting the record, Base will display a dialog box with a ...........message.

To sort the field , select the required field and then click on .......... button.

Database designers attempt to criminate redundant data as far as possible by using a technique

which is a process that suggests decomposition of single table into multiple tables, thus creating a parent-child relationship.

The table which contains primary key is known as ............... table.

which key can be defined as field or combination of fields whose values are borrowed from another table.

which key can be defined as combination of fields whose values are borrowed from another table.

Under which menu Relationship option is available ?

What operation should be carried out to create relationship ?

In what type of relationship , one value of referred table is associated with multiple values in referencing table ?

Which option states that a user should not be allowed to delete or update any record exists in some other table ?

Which option states if user deletes or updates the referenced field , all the related records will hold null value in the related field ?

How many types of relationship can be created between tables of the database ?

Which type of relationship is created between Chair and Person ?

Which type of relationship is created between class teacher and student ?

Which type of relationship is created between state and city ?

which relationship occurs in the case or some specific record , which has to be stored more than once in both the tables

In the field of information technology , the data in the raw material used to produce finished goods known as what?

To prevent mistakes , base provides a special facility called what?

Field Properties can be decided at the time of .......... the structure of the table.

What is the default length for Text data type ?

Which field properly allow to specify field size as per requirement?

Which field property store some predefined default value automatically in a particular field at the time of entering a new record in the table?

Which field properly specifies the format for displaying and printing the data entered in the field ?

What is the format code for displaying date in the format Dec 31 ,2022?

Which option states that if user is allowed to delete or update referenced values , all the related records will hold null value in the related field ?

Each unique value stored in primary key field may be repeated a number of times in.....key.

Select.........to open Add Tables dialog box in relationship window.

In warning message , clicking on which button will delete the selected record permanently?

The process of correcting the data entered previously is known as............

In Base, the line consisting of field names is known as..................

Which of the following operations cannot be performed on a record in database?

Which of the following represents maximum levels of sorting provided by Base Wizard?

Which of the following refers to data redundancy?

Which of the following statement is incorrect?

Which of the following type of relationship exists between Student and Teacher in a school?

Which of the following type of relationship exists between Student and Class Teacher in a school?

Which of the following options are possible to implement referential integrity?

AutoValue property can be set for field with which of the following datatype?

Which of the following statement is true for Default field property in Base?

Which of the following property is equivalent to NOT NULL?

⚠️ Report Question Issue