Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    chapter 9 mcq

    Uploaded by

    benhurjijogr.6isa2020

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    chapter 9 mcq

    Uploaded by

    benhurjijogr.6isa2020
    1 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1 views3 pages

    chapter 9 mcq

    Uploaded by

    benhurjijogr.6isa2020

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Unit 3.

    Database Management System using LibreOffice Base

    Chapter 9. Starting with LibreOffice Base


    A. Multiple-choice questions.

    1:Which of the following is NOT a type of text data type?


    (a) Memo

    (b) Varchar

    (c) Float

    (d) Char
    Answer: (c) Float
    2:A currency data type can only store monetary data that is in dollars.
    (a) True

    (b) False
    (c) Neithera nor b
    (d) Both and b

    Answer: (b) False

    3:Which of the following data can a date data type store?


    (a) Date

    (b) Time
    (c) Both date and time
    (d) Neither date nor time Answer: (c) date and time

    4: Which of the following is true about Libre office Base?


    (a) It is a spreadsheet software
    (b) It is free and open-source software
    (c) It can store only character data

    (d) It is a licensed software.

    Answer: (b) It is free and open-source software


    5:Which of the following methods can be used to create a table in Base?
    (a) Using a table wizard

    (b) Design View

    (c) Both a and b


    (d) Neither a nor b Answer: (c) Both a and b

    6:The related objects of a database can be seen in pane of the Base Database window.

    (a) Database

    (b) Task
    (c) Title Bar

    (d) Menu Bar

    Answer: (a) Database


    7:Which is the shortcut key to open an existing database?
    (a) Ctrl+D
    (b) Ctrl+O

    (c) Ctrl+E

    (d) Ctrl+F
    Answer: (b)Ctrl+O
    8:The Design view of the Table Creation window in Libreoffice Base is divided into ________sections or
    panes.
    (a) 2 (b) 3 (c) 4 (d) 5

    Answer: (a) 2
    9:While entering records in a table, we can move to the next eld by pressing the key.
    (a) Tab

    (b) Ctrl

    (c) Enter

    (d) Shift

    Answer: (a) Tab

    10:Which of the following is true about the primary key of a table?


    (a) Every table must have a primary key

    (b) The data values in the primary key eld cannot be duplicated.
    (c) A primary key eld cannot be left blank

    (d) All of the above


    Answer: (d) All of the above
    B. State whether the following statements are True or False.
    1.The text data can contain special characters.Answer: True

    2.Memo data type can be used to store descriptive data. Answer: True

    3.A Boolean data type can have two or more than two values. Answer: False

    4.We cannot store audio data in Libreoffice Base. Answer: False

    5.The properties of a eld change according to the data type selected. Answer: True

    6.Field descriptions may or may not be entered while designing a table. Answer: True

    7: is pressed to move to the last record. Answer: False

    8: appears when the record is being edited. Answer: True

    9:A table once created in a database cannot be edited. Answer: False

    10:Sort dialog box can only help to sort data in ascending order. Answer: False
    C. Fill in the blanks.
    1:A_____________ refers to the type of data that will be stored in that particular field.
    Answer: Data Type
    2:The____________________data is a combination of letters, numbers or special characters.
    Answer: Text
    3:______________ data type can be used to store Aadhar number.
    Answer: Text
    4:The____________ data type is used to store digitized images.
    Answer: Binary
    5:The shortcut key to save a table is _.
    Answer: Ctrl + S
    6:_______________________on the Base Interface Window displays information about the type of
    view of the object in the database.
    Answer: Tasks Pane
    7:A________________icon appears before the eld name indicating that it is a primary key.
    Answer:Key
    8:The data can be entered in a table only in__________________view.
    Answer:Datasheet
    9:The black pointing arrow just before the field name in a table is called__________
    Answer: Record Pointer

    10:The process of arranging the records in a particular order on any field is called_______

    Answer: Sorting

    You might also like