VU VICKY Virtual University Assignment Solution, Past Papers, Handouts and other material

2         

The room ID + building ID determines the room schedule. This is written:

            A)        ROOM_ID, BUILD_ID ? ROOM_SCH

            B)        ROOM_ID + BUILD_ID ? ROOM_SCH

            C)        ROOM_ID, ROOM_SCH ? BUILD_ID

            D)        ROOM_ID, BUILD_ID ? ROOM_SCH

3

The database data storage standard requires that, with s
ome exceptions, data must occur in only one place at one time. What are the exceptions?

            A)        Foreign key and replicated data requirements

            B)        Transitive dependencies and foreign keys

            C)        Replicated data and primary keys

            D)        Transitive dependencies and primary keys

 www. .info

4                     

Data redundancies produce unusual and undesirable data management problems caused by __________.

            A)        transitive requirements

            B)        dependencies

            C)        normalization

            D)        data anomalies

5                     

Removing the __________ is part of the database design process.

            A)        foreign keys

            B)        primary key dependencies

            C)        recursive relationships

            D)        partial and transitive dependencies

The POS Database Design Process

1                     

In a POS system, what do the major transaction modules define?

            A)        Inventory management, shipping, invoice calculations, and product returns

            B)        Sales, inventory management, shipping, back ordering, and product returns

            C)        Sales, invoice calculations, back ordering, and product returns

            D)        Inventory management, shipping, invoice calculations, back ordering, and product returns

2

What are the fourth and fifth steps in developing a POS?

            A)        Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.

            B)        Develop business rules. Create the initial ERD segments.

            C)        Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.

            D)        Define the major transaction modules. Create the initial ERD segments.

 www. .info

3

After creating the initial ERD segments, the next step is to

            A)        define the major transaction modules.

            B)        perform the appropriate normalization checks based on the data dictionary contents.

            C)        create a basic data dictionary for all the components found in each ERD segment.

            D)        define the entities, attributes, relationships, connectivities, cardinalities, and constraints.

4

What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?

            A)        Available resources

            B)        Data environment

            C)        Current operations

            D)        Business objectives

5         

Which of the following is an advantage of having a precisely written set of current operations.

            A)        It clarifies the assignment of data types.

            B)        It highlights the best possible way to perform each task.

            C)        It forces careful assessment of the procedures.

            D)        It makes the creation of the data dictionary much easier.

Implementing the Database Design

1                     

You have created a table in Access, but not yet designated a PK. What happens if you save the table now?

            A)        The save fails because no PK is defined.

            B)        The save works as usual.

            C)        Access warns you that no primary key is defined, and forces you to define a PK before saving.

            D)        Access warns you that no primary key is defined, but lets you save the table if you want to.

2

You want to create a composite PK using the first and third fields in the table. How is this done?

            A)        Hold down the Shift key and click the first and third fields. Click the Key icon on the toolbar.

            B)        Hold down the Ctrl key and click the first and third fields. Click the Key icon on the toolbar.

            C)        Hold down the Shift key and click the first and third fields. Select Primary Key under the Table.

            D)        Hold down the Ctrl key and click the first and third fields. Select Primary Key under the Table.

3                     

What is required to establish a 1:1 relationship between two tables that do not contain a supertype and subtype?

            A)        1:1 relationships are only possible if the tables contain a supertype and subtype.

            B)        Make sure that the PK in the related table has unique values.

            C)        Make sure that the FK in the related table has an index property that specifies unique values.

            D)        Nothing special is required.

4         

In Access, how do you tell if referential integrity is enforced for a relationship?

            A)        The relationship lines are thick and dark, and the nature of the relationships is labeled.

            B)        The relationship lines are thin, and the nature of the relationships is labeled.

            C)        Right-click the relationship line to see if enforce referential integrity is checked.

            D)        Right-click the relationship line, select referential integrity, and look at the relationship's properties.

5

The relationship between STORE and EMPLOYEE is defaulted to mandatory, that is, the FK value in EMPLOYEE is required. How do you eliminate a record from STORE?

            A)        Delete the employees from the STORE to be deleted.

            B)        Permanently remove the referential integrity enforcement.

            C)        Open the EMPLOYEE table in the design format; then change the Required property of the EMPLOYEE's FK to No and make sure that its default value is set to null.

            D)        Delete all relationships between STORE and EMPLOYEE. Redesign the database to work without them.

Queries

1               www. .info      

What does Access use to handle SQL code generation?

            A)        SQL forms

            B)        Query Code Generator

            C)        Query by Example

            D)        SQL compiler

2                     

Two basic query types exist. They are

            A)        static and change queries.

            B)        static and action queries.

            C)        select and action queries.

            D)        select and change queries.

3

What criteria matches dates from January 1, 1996 to the present?

            A)        >= "01/01/1996"

            B)        >= 01/01/1996

            C)        >= #01/01/1996#

            D)        >= '01/01/1996'

4

EMP_DOB holds employee birth dates. Which format will display the month in number format, such as 01 or 11?

            A)        Month: Format([EMP_DOB],"m")

            B)        Month: Format([EMP_DOB],"mm")

            C)        Month: Format([EMP_DOB],"mmm")

            D)        Month: Format([EMP_DOB],"mmmm")

5                     

What does the wildcard ? match?

            A)        Zero or more of the preceding character

            B)        Any one character in the position held by the ?

            C)        Multiple characters in the position held by the ?

            D)        Any letter in the position held by the ?

Form Development

 www. s.info

1                     

Which of the following are not functions of forms?

            A)        Forms are used to tie together the database components through menu structures.

            B)        Forms extend data validation rules through queries, value lists, and other input control devices.

            C)        Forms are used to enter new data and to edit existing data.

            D)        Forms program and control user responses.

2

Which of the following correctly describes the relationship between forms and tables?

            A)        A form is based on exactly one table. The table must exist before the form is created.

            B)        A form is based on exactly one table. The table may be created before or after the form is created.

            C)        A form may be based on one or more tables. The table(s) must exist before the form is created.

            D)        A form may be based on one or more tables. The table(s) may be created before or after the form is created.

3

What is the most common form type?

            A)        A single-source form, based on a tabular format

            B)        A single-source form, based on a columnar format

            C)        A multi-source form, based on a tabular format

            D)        A multi-source form, based on a columnar format

4

What are the advantages of form-based dialog boxes?

            A)        They have more prompting options than dialog boxes generated by Access.

            B)        They allow the use of combo boxes.

            C)        Access-generated dialog boxes are likely to disrupt interface layout schemes, while form-based dialog boxes are not.

            D)        All of the above.

5

Which of the following is not an advantage of a menu driven database system?

            A)        Help make the database applications system user-friendly by eliminating the need to remember command languages.

            B)        Provide security though user-level logins.

            C)        Control access by providing only those options that allow people to do their jobs.

            D)        Create an environment that is tailored to specific types of applications and end users.

Reports and Labels

1                     

You want month names to be sorted in order (Jan, Feb, Mar, etc.) when they appear on a report. What do you need to do?

            A)        Sort by month name.

            B)        Sort by month number.

            C)        Define the field with the data type month and sort Ascending.

            D)        Define the field with the data type month and sort Descending.

2

What functions would you use to put the current time and data output in a report header?

            A)        Time() and Now()

            B)        Time() and CurrentDate()

            C)        CurrentTime() and Now()

            D)        CurrentTime() and CurrentDate ()

3

Which syntax will concatenate employee first and last names, with a space in between the names?

            A)        ([EMP_FNAME] & " " [EMP_FNAME])

            B)        ([EMP_FNAME] & " " & [EMP_FNAME])

            C)        ([EMP_FNAME] " " & [EMP_FNAME])

            D)        ([EMP_FNAME] " " [EMP_FNAME])

4

Which of the following accurately describes a crosstab query?

            A)        Crosstab queries have very limited summary capabilities.

            B)        Crosstab queries are seldom used to generate reports.

            C)        If you select row totals in the crosstab query, you cannot also select column totals.

            D)        You can select row totals and also column totals.

5

What kind of query works best with the Chart Wizard?

            A)        Append

            B)        Update

            C)        Action

            D)        Select

Macros and Macro Groups

1                     

Which of the following best describes a macro?

            A)        An SQL script

            B)        An instruction or a set of instructions that triggers one or more actions

            C)        A VBA program

            D)        A detailed set of actions that Access will invoke whenever a mouse click occurs

2

Macros are best placed in logical modules known as

            A)        macro sets.

            B)        macro groups.

            C)        code sets.

            D)        modules.

3

Which of the following statements best describes the use of freestanding macros?

            A)        They are best used for conditional statements.

            B)        They are best used for menu items.

            C)        They are best used to enter temporary values in a form.

            D)        Do not use freestanding macros.

4

What action hides or shows the results of a macro while it runs.

            A)        Reveal

            B)        Echo

            C)        Hide

            D)        Show

5

What macro will be executed automatically when you open the database?

            A)        Autoexec

            B)        AutoStart

            C)        Startup

            D)        AutoRun

Access and the Internet

1                     

What standard must a basic HTML-based web page conform to?

            A)        TCP/IP

            B)        ASCII

            C)        XML

            D)        SQL

2

Which cannot be dragged to a Data Access Page using the Controls Wizard?

            A)        Tables

            B)        Controls

            C)        Macros

            D)        Queries

3

When inserting a field in the footer, what is the default prefix is

            A)        TotalOf <Fieldname>

            B)        SumOf <Fieldname>

            C)        MaximumOf <Fieldname>

            D)        MinimumOf <Fieldname>

4

A record set is exactly the same as

            A)        a query

            B)        a data access page

            C)        a table

            D)        a macro

5                     

What's the maximum number of different fields that can you sort in the Page Wizard?

            A)        1

            B)        2

            C)        3

            D)        4

Database Security

1         

In a database security environment, a form, table, query, report, macro, or module in the database is a(n)

            A)        object.

            B)        permission.

            C)        operation.

            D)        group.

2

What file does Access use to lock a database in a shared environment?

            A)        The LDB file

            B)        The PID file

            C)        The MDE file

            D)        The MDB file

3

Which of the following accurately describes workgroup files?

            A)        You can only create one workgroup file per computer.

            B)        You can create many workgroup files, but you can use only one workgroup file at a time.

            C)        You can create many workgroup files, and you can use more than one workgroup file at a time.

            D)        You can create many workgroup files, but are limited to using two at a time.

4

What does Access use to manage database locking in a multiuser database environment?

            A)        Jet Database Engine

            B)        PID files

            C)        MDW files

            D)        Access Lockout Protocol (ALP)

5

What permission allows the user to open a database, form or report, or run a macro?

            A)        Open

            B)        Open/Run

            C)        Administer

            D)        Run