Study

database

  •   0%
  •  0     0     0

  • What is a database?
    A system for drawing pictures.
    A place to store physical books.
    A single file with mixed information.
    A collection of data composed of one or more tables.
  • You are designing a new database table. Which action aligns best with effective data organization?
    Use only primary data.
    Collect all data as text.
    Mix all data types in one field.
    Define clear data types for each field.
  • If data was collected by someone else for a different purpose, what is it called?
    Secondary data
    Primary data
    Original data
    New data
  • Why is understanding data types important for data collection?
    It makes data collection much faster.
    It prevents anyone from seeing the data.
    It ensures data is collected in the preferred format.
    It helps to hide sensitive data.
  • What is the main purpose of a data type in a computer system?
    To hide data from users.
    To show if data is new or old.
    To describe the color of data.
    To tell the system how to interpret data's value.
  • What is the main type of data identified for numbers in a computer system?
    Numeric
    Text/Alphanumeric
    Date/Time
    Boolean
  • What makes data 'primary data'?
    It was collected for a different reason.
    It is stored in a very old format.
    It is original and collected for the first time for a specific purpose.
    It was found online by someone else.
  • If a store database needs to record customer satisfaction as '50% satisfied', what data type would be most appropriate?
    Numeric
    Text
    Currency
    Percentage
  • You want to record if a student has paid their fees (yes/no). What data type should you use?
    Boolean
    Date/Time
    Text
    Numeric
  • A school wants to store a student's date of birth. Which data type is best?
    Numeric
    Date/Time
    Text/Alphanumeric
    Boolean
  • If you are creating a field for 'Age' in a database, what data type would be most suitable?
    Date/Time
    Numeric
    Boolean
    Text
  • Which part of a database table is described as the horizontal part?
    Records
    Fields
    Attributes
    Datatypes
  • The term 'Currency' as a data type is specifically used to represent what kind of information?
    Textual information
    Date and time values
    True/False statements
    Monetary values
  • If a data type could wear a costume to represent itself, which costume would clearly show it is a 'Text' data type?
    A light switch for 'on/off'
    A calendar date
    A sign that says 'HELLO WORD'
    A giant number '100'
  • After learning about data types, how might you personally approach organizing your own information more effectively?
    I would think about the type of data before storing it.
    I would avoid using any databases.
    I would only use numbers for all my personal data.
    I would put all my data in one big file.
  • A student claims '22 miles' should be a Numeric data type. Why is this incorrect based on the reading?
    It contains both numbers and text, making it Alphanumeric.
    Only whole numbers are Numeric.
    It is a measurement, not a number.
    Miles are a unit of distance, not a data type.
  • In a database table, what are the vertical parts that store actual data?
    Fields
    Databases
    Tables
    Records