Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Introduction and starting LibreOffice base MCQ

    Uploaded by

    bindugopakumar70

    Copyright:

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

    Introduction and starting LibreOffice base MCQ

    Uploaded by

    bindugopakumar70
    8 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Introduction and starting LibreOffice base MCQ

    Uploaded by

    bindugopakumar70

    Copyright:

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

    Chapter 8 .

    Introduction to Database

    1. Which of the following cannot be considered as an example of a database?


    (a) Dictionary (b) Telephone directory
    (c) Marks Register (d) Newspaper Ans : (d)

    2. Which of the following is NOT a DBMS?


    (a) MS Access (b) Open Office Base
    (c) MS Excel (d) MySQL Ans : (c)
    3. DBMS stands for ______________________.
    (a) Data and Books Management System
    (b) Database Management System
    (c) Duplicate Books Management System
    (d) Data Management Multi System Ans : (b)
    4. Which of the following data models sets a relation between the two or more
    tables?
    (a) Relational Data Model (b) Network Data Model
    (c) Hierarchical Data Model (d) Connection Data Model Ans : (a)
    5. The details associated with an entity are called ____________.
    (a) Table (b) Attributes (c) Records (d) Primary key Ans : (b)
    6. A __________ is represented as rows in a table.
    (a) field (b) attribute (c) record (d) candidate key Ans : (c)
    7. In which of the following forms can a data value be represented?
    (a) Numeric (b) Character (c) Alphanumeric (d) All of the above
    Ans : (d)
    8. Which of the following uniquely identifies a row in a table?
    (a) Primary key (b) Alternate key (c) Foreign key (d) Candidate key
    Ans : (a)
    9. A ___________is a feature of a database using which we can enter data in a table
    in an easy and user friendly manner.
    (a) query (b) report (c) form (d) field Ans : (c)
    10. A _____________ is a question asked from a database.
    (a) query (b) report (c) form (d) field Ans : (a)
    B. State whether the following statements are True or False
    1. A database cannot be organised. F
    2. Data is the collection of raw facts. T
    3. A table can be created without a primary key. F
    4. Two tables can be related in a network data model F
    5. MS Access is an example of a database. T
    C. Fill in the blanks
    1. The raw facts constitutes _____________. Data
    2. An _____________ is a real world object about which information is to be stored
    in a database entity
    3. The output of a query may be displayed in the form of ________. report
    4. The data values for all the fields related to a person or object is called a
    _________. record
    5. All the field values that are eligible to be the primary key are the ___________
    keys for that table. candidate

    Chapter 9 - Starting with LibreOffice Base


    Multiple choice questions
    1. Which of the following is NOT a type of text data type?
    (a) Memo (b) Varchar (c) Float (d) Char Ans : (c)
    2. A currency data type can only store monetary data that is in dollars.
    (a) True (b) False (c) Neither a nor b (d) Both a and b Ans : (b)
    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 Ans : (c)
    4. Which of the following is true about LibreOffice 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. Ans : (b)
    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 Ans : (c)
    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 Ans : (a)
    7. Which is the shortcut key to open an existing database?
    (a) Ctrl+ D (b) Ctrl+O (c) Ctrl+E (d) Ctrl+F Ans : (b)
    8. The Design view of Table Creation window in LibreOffice Base is divided into
    ______ sections or panes.
    (a) 2 (b) 3 (c) 4 (d) 5 Ans : (a)
    9. While entering records in a table, we can move to the next field by pressing the
    _________ key.
    (a) Tab (b) Ctrl (c) Enter (d) Shift Ans : (a)
    10. Which of the e following is true about primary key of a table?
    (a) Every table must have a primary key
    (b) The data values in primary key field cannot be duplicated.
    (c) A primary key field cannot be left blank
    (d) All of the above Ans (d)

    You might also like