Devry BIS245/BIS245 week 2 Quiz latest 2016 may

    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