Devry BIS245/BIS245 week 2 Quiz latest 2016 may

    0

    Question
    devry bis245 week 2 Quiz latest 2016 may
    1. Question : (TCO 2) When building a database you should first
    create and input the design of the table and reports at the same time.
    determine the input and then design the tables.
    determine the output and then design the tables.
    input the data and then design the reports.
    Question 2. Question : (TCO 2) All of the following describe a large database system EXCEPT
    different users may have different levels of access to data in the database.
    simultaneous logging into a database is not recommended.
    multiple users in the database are common.
    the database could be split into a front and back end.
    Question 3. Question : (TCO 2) Columns in an Access table are called
    fields.
    records.
    relation.
    tuples.
    Question 4. Question : (TCO 3) A relational table includes the following conditions EXCEPT
    column entries and attributes must be the same data type.
    rows must be in order.
    cells contain a single data value.
    columns or attributes have a well defined range of values.
    Question 5. Question : (TCO 3) In Access a query result that contained the date November 12 2011 could have had which of the following query criteria?
    11/12/2011
    12/11/2011
    #12/11/2011#
    Between #10/01/2011# And #11/12/2011#
    Question 6. Question : (TCO 3) Which data type will increment automatically each time a new record is entered into a table?
    AutoNumber
    Currency
    Date/Time
    Number
    Question 7. Question : (TCO 3) All of the following are true about a property EXCEPT
    a Datasheet View is used to display properties.
    referenced as an attribute.
    changes can be made with a property sheet.
    tables forms queries and reports can have properties.
    Question 8. Question : (TCO 4) Which of the following is NOT an example of a primary key?
    ISBN number for a textbook
    Last name
    Social Security Number
    Student ID
    Question 9. Question : (TCO 4) Which of the following is NOT an Access data type?
    Text
    Currency
    Name
    Date/Time
    Question 10. Question : (TCO 2) In Access which item below is NOT considered a logical operator?
    Equal
    And
    Not
    Or

                                                                                                                                      Order Now