Download App

Computer MCQ

Working with Tables · Gujarat Board (GSEB) STD 11 Arts (GSEB - English Medium). 102 questions.

Questions · Page 1 of 3

MCQ

🎯

Test yourself on this topic

50 questions · timed · auto-graded

MCQ 11 Mark
There are$…..$options available to allow to maintain referentian integrity in database.
  • ✓
    $2$
  • B
    $3$
  • C
    $4$
  • D
    $5$
Answer
Correct option: A.
$2$
View full question & answer→
MCQ 21 Mark
$……..$Principal an statet as no unmatched foreign key valies should exist in the database.
  • A
    database principle
  • B
    user interface principle
  • ✓
    referential principle
  • D
    resource principle
Answer
Correct option: C.
referential principle
View full question & answer→
MCQ 31 Mark
there must not be any entry in the state table without a related in the country table the consept is known as$…….$
  • ✓
    referential integaty 
  • B
    resoure integrity
  • C
    refer integrity
  • D
    recalling integrity
Answer
Correct option: A.
referential integaty 
View full question & answer→
MCQ 41 Mark
Transaction able is also known as$…….$
  • A
    parent table
  • ✓
    child table
  • C
    master table
  • D
    all of these
Answer
Correct option: B.
child table
View full question & answer→
MCQ 51 Mark
Master table is also known as$…….$
  • A
    child table
  • B
    transaction table
  • ✓
    parent table
  • D
    all of these
Answer
Correct option: C.
parent table
View full question & answer→
MCQ 61 Mark
To create relationship between two table$………$
  • ✓
    double-click the line depicting relationship
  • B
    drag and drop table
  • C
    drag and drop relationshipline
  • D
    select table and edit
Answer
Correct option: A.
double-click the line depicting relationship
View full question & answer→
MCQ 71 Mark
How many option are shown based on delete option in referential intrgrity dialog box?
  • A
    no action
  • B
    delete cascade
  • C
    set null,set default
  • ✓
     all of these
Answer
Correct option: D.
 all of these
View full question & answer→
MCQ 81 Mark
which option are shown based on update options in referential  integrity dialog box ?
  • A
    no action
  • B
    upadate cascade    
  • C
    set null,set default               
  • ✓
    all of these
Answer
Correct option: D.
all of these
View full question & answer→
MCQ 91 Mark
which type of work options available to allow to maintain referential integrity in database ?
  • A
    update 
  • B
    delete
  • ✓
    both $(a)$ and $(b)$
  • D
    insret
Answer
Correct option: C.
both $(a)$ and $(b)$
View full question & answer→
MCQ 101 Mark
$…….$Is displayed the foreign key side to make relationship between two table.
  • A
    $i$
  • B
    $m$
  • ✓
    $n$
  • D
    anyone
Answer
Correct option: C.
$n$
View full question & answer→
MCQ 111 Mark
$……….$is displayed on the primary key side to make relationship between two table.
  • ✓
    $i$
  • B
    $m$
  • C
    $n$
  • D
    anyone
Answer
Correct option: A.
$i$
View full question & answer→
MCQ 121 Mark
to make relationship which table text are shown near the field ?
  • A
    $m,n$
  • ✓
    $i,n$
  • C
    $m,I$
  • D
    $i,m$
Answer
Correct option: B.
$i,n$
View full question & answer→
MCQ 131 Mark
when there is no relationship between two tables of the datatype of referencing field and referenced field then we will see$……$
  • ✓
    tool tip message 
  • B
    error massege
  • C
    relationship massege
  • D
    counting massege
Answer
Correct option: A.
tool tip message 
View full question & answer→
MCQ 141 Mark
To create a relationship between two tables the data type of $……$ must be same
  • A
    referencing field       
  • B
    referenced field
  • ✓
    both $(a)$ and $(b)$
  • D
    none of these
Answer
Correct option: C.
both $(a)$ and $(b)$
View full question & answer→
MCQ 151 Mark
where one vale of referred table is associated with multiple values in referencing table is called$…....$relationship.
  • A
    one to one
  • ✓
    one to many
  • C
    many to many   
  • D
    none of these
Answer
Correct option: B.
one to many
View full question & answer→
MCQ 161 Mark
Primary key repeated$………$ n number times in foreign key.
  • A
    only one time
  • B
    two time
  • C
    three time
  • ✓
    many time
Answer
Correct option: D.
many time
View full question & answer→
MCQ 171 Mark
To create relationship between two table text n is displayed on$……..$side.
  • A
    primary key
  • ✓
    foreign key
  • C
    $(a)$ or $(b)$         
  • D
    none of these
Answer
Correct option: B.
foreign key
View full question & answer→
MCQ 181 Mark
To create relationship between two table text 1 is displayed  on$……$ side.
  • ✓
    primary key
  • B
    foreign key
  • C
    $(a)$ or $(b)$
  • D
    none of these
Answer
Correct option: A.
primary key
View full question & answer→
MCQ 191 Mark
In Ordershipment table shippingstatus field is used to maintain the atatus of the product  delivery initial its data type is$ …………. $
  • A
    text
  • B
    integer
  • C
    memo
  • ✓
    Boolean
Answer
Correct option: D.
Boolean
View full question & answer→
MCQ 201 Mark
to make relationship between two tables, how many table text shown near the field ?
  • ✓
    $2$
  • B
    $3$
  • C
    $4$
  • D
    $ 5$
Answer
Correct option: A.
$2$
View full question & answer→
MCQ 211 Mark
to make relationship between two table$…….$ Connecting both field
  • A
    aeeow
  • B
    pencil
  • C
    box
  • ✓
    line
Answer
Correct option: D.
line
View full question & answer→
MCQ 221 Mark
to create a relationship just use$……$ opration.
  • A
    cut and paste 
  • B
    copy and paste  
  • ✓
    drag and drop
  • D
    drop and drag
Answer
Correct option: C.
drag and drop
View full question & answer→
MCQ 231 Mark
in relationship window to add it display with which information?
  • A
    data base
  • ✓
    field  
  • C
    record  
  • D
    all of these
Answer
Correct option: B.
field  
View full question & answer→
MCQ 241 Mark
you can click on$…….$button seen to  add tables dialog with list of tables created in the active database will be display.
  • A
    insert 
  • B
    new
  • ✓
    add
  • D
    put
Answer
Correct option: C.
add
View full question & answer→
MCQ 251 Mark
click on which button for adding table in relationship dialog box window?
  • A
    new tables
  • ✓
    add tables  
  • C
    insert tables    
  • D
    view tables
Answer
Correct option: B.
add tables  
View full question & answer→
MCQ 261 Mark
to insert a table in relationship dialog box which menu option can you use?
  • A
    file-add tables 
  • B
    view-add tables
  • ✓
    insert-add tables    
  • D
    toos-add tables
Answer
Correct option: C.
insert-add tables    
View full question & answer→
MCQ 271 Mark
To establish the appropriate relationship which menu-option is used ?
  • A
    file-relationship$….$
  • B
    insert-relationship$……$
  • C
    view-relationship
  • ✓
    tools-relationship$…….$
Answer
Correct option: D.
tools-relationship$…….$
View full question & answer→
MCQ 281 Mark
Which menu is used to established the appropriate relationship among the different tables of the database ?
  • A
    Insert  
  • ✓
    Tools     
  • C
    Edit  
  • D
    View
Answer
Correct option: B.
Tools     
View full question & answer→
MCQ 291 Mark
$…………$ can be defined as field or combination of fields whose values are borrowed from another table.
  • A
    Primary Key
  • ✓
    Foreign key
  • C
    Composite primary key
  • D
    composite foreign key
Answer
Correct option: B.
Foreign key
View full question & answer→
MCQ 301 Mark
Two tables are related to each other using a $…………….$
  • A
    user field 
  • B
    master field 
  • ✓
    common field
  • D
    different field
Answer
Correct option: C.
common field
View full question & answer→
MCQ 311 Mark
Establising relationship between tables we will restrict the user from entering garbage data in the field .
  • ✓
    Master
  • B
    Secondary
  • C
    Referenced
  • D
    all of these
Answer
Correct option: A.
Master
View full question & answer→
MCQ 321 Mark
Primary key symbol will be displayed in the $…………$ of the two selected rows.
  • A
    right 
  • ✓
    left
  • C
    up
  • D
    down
Answer
Correct option: B.
left
View full question & answer→
MCQ 331 Mark
The table which contains primary key is known as $…………..$
  • ✓
    Master table
  • B
    Child table
  • C
    Primary table 
  • D
    User table
Answer
Correct option: A.
Master table
View full question & answer→
MCQ 341 Mark
If we want to select two field simultaneuously in composite primary key, which key you have to press ?
  • A
    Ctrl 
  • ✓
    Shift
  • C
    Alt 
  • D
    Tab
Answer
Correct option: B.
Shift
View full question & answer→
MCQ 351 Mark
To eliminate redundant data from the database, we must take special care to organize the data$…………$
  • ✓
    size of the data stored in the table.
  • B
    property of the data stored in the table
  • C
    length of the data stored in the table
  • D
    stored in the table.
Answer
Correct option: A.
size of the data stored in the table.
View full question & answer→
MCQ 361 Mark
Combination of more than one field when designed as a primary key is also known as $……………..$
  • A
    Primary Key   
  • B
    Foreign key
  • ✓
    Composite primary key
  • D
    composite foreign key
Answer
Correct option: C.
Composite primary key
View full question & answer→
MCQ 371 Mark
What is the value of primary key ?
  • ✓
    Extra ordinary   
  • B
    Same   
  • C
    Empty
  • D
    All of these
Answer
Correct option: A.
Extra ordinary   
View full question & answer→
MCQ 381 Mark
The field which contains a primary key whose values is not $………………$
  • A
    duplicate
  • B
    empty
  • ✓
    both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: C.
both $(A)$ and $(B)$
View full question & answer→
MCQ 391 Mark
To create a realationship between two tables of primary key the data types of field is $…………….$
  • A
    different
  • ✓
    same    
  • C
    multiple
  • D
    anyone of these
Answer
Correct option: B.
same    
View full question & answer→
MCQ 401 Mark
When a master table has composite primary key than tables related with it will hold $……….$
  • A
    Primary Key  
  • B
    Foreign key    
  • C
    Composite primary key           
  • ✓
    composite foreign key
Answer
Correct option: D.
composite foreign key
View full question & answer→
MCQ 411 Mark
How many button are displayed for sorting the data in base table ?
  • A
    $2 $
  • ✓
    $3$
  • C
    $4$
  • D
    $5$
Answer
Correct option: B.
$3$
View full question & answer→
MCQ 421 Mark
By Which method you can arrange data which is residing in table ?
  • A
    Ascending 
  • B
    Descending
  • ✓
    Both $(A)$ and $(B)$
  • D
    None of these
Answer
Correct option: C.
Both $(A)$ and $(B)$
View full question & answer→
MCQ 431 Mark
If we click on $…………….$ Button, then the selected record will not be deleted from the table but it will be redisplayed in the view.
  • A
    Yes
  • ✓
    No
  • C
    OK
  • D
    cancel
Answer
Correct option: B.
No
View full question & answer→
MCQ 441 Mark
If we click on the $……………$ button, then the selected record will be deleted from the table permanently.
  • ✓
    Yes
  • B
    No
  • C
    OK 
  • D
    cancel
Answer
Correct option: A.
Yes
View full question & answer→
MCQ 451 Mark
What made data normalization ?
  • A
    Master relationship
  • B
    Secondary relationship
  • ✓
    Parent-child relationship
  • D
    User admin relationship
Answer
Correct option: C.
Parent-child relationship
View full question & answer→
MCQ 461 Mark
When you delete the record, base will display $…………….$
  • A
    Error
  • ✓
    Warning 
  • C
    Thanks
  • D
    Editing
Answer
Correct option: B.
Warning 
View full question & answer→
MCQ 471 Mark
Database designer attempt to eliminate it as far as possible  by using a technique called $……………..$
  • A
    Datastandard
  • ✓
    datanormalization 
  • C
    dataregulation   
  • D
    dataprocessing
Answer
Correct option: B.
datanormalization 
View full question & answer→
MCQ 481 Mark
Data Redundancy is $……………..$
  • A
    active
  • ✓
    inactive
  • C
    sometimesactive,sometimesinactive
  • D
    noneofthese
Answer
Correct option: B.
inactive
View full question & answer→
MCQ 491 Mark
Unnecessary duplication or repetition of data is called $………….$
  • A
    Datatruly  
  • ✓
    dataredundancy
  • C
    dataintegrity
  • D
    datanormalization
Answer
Correct option: B.
dataredundancy
View full question & answer→
MCQ 501 Mark
In the following what display data redundancy ?
  • A
    Decompositionoftable   
  • B
    Deletedata  
  • C
    relationshipoftable
  • ✓
    Repetitionofdata
Answer
Correct option: D.
Repetitionofdata
View full question & answer→
Generate Paper FreeAll Working with Tables topics
MCQ - Computer STD 11 Arts Questions - Vidyadip