WK4

In which of the following ways can a string criteria expression in a query be written? Each correct answer represents a complete solution. Choose two.

"View" VIEW

Which of the following operators is used to concatenate two strings?

&

You want to see the records of employees who have joined your organization from January 1, 2017 to April 30, 2017. Which of the following is the correct expression to accomplish the task?

(JoiningDate >= 1/1/2017) And (JoiningDate <= 4/30/2017)

Click to select the order of precedence of mathematical operators, and then drag them into the correct order.

1 Exponentiation 2 Negation 3 Integer division 4 Modulus division 5 String concatenation

Click to select the order of precedence of Boolean operators, and then drag them into the correct order.

1 Not 2 And 3 Or 4 Xor 5 Eqv 6 Imp

Which of the following is a comparison operator?

<>

Which of the following action queries adds records to a table based on the definitions and criteria a user specifies in the query?

Append

Which of the following action queries is used to add records to a table based on the definitions and criteria specified in the query?

Append

Which of the following is not a primary view of a query design window?

Data

What tasks can a user perform with the help of Access queries? Each correct answer represents a complete solution. Choose all that apply.

Obtain information from a single table or from many tables that are related by some common data. Select records on the basis of some defined criteria. Display fields from a table with their data.

Which of the following rows of the Query by Example (QBE) grid allows to add multiple query criteria?

Or

Which of the following holds the field names involved in a query and any criteria used to select records?

QBE grid

Which of the following are necessary conditions to auto-join two tables? Each correct answer represents a complete solution. Choose all that apply.

Both tables have fields with the same name. The same-named fields should be of the same data type. One of the fields is defined as a primary key in the table.

Which of the following types of queries or fields of a table cannot be updated? Each correct answer represents a complete solution. Choose all that apply.

SQL-specific queries Calculated field Totals query

Indicate if each of the given statements about wildcard characters are true or false.

T F F T

Indicate whether the statements regarding the guidelines for creating a crosstab in the query grid is true or false.

T F T T

Which of the following Boolean operators returns TRUE when either Expression1 or Expression2 is true, but not both?

Xor

Drag the Boolean operator to its description.

Xor: Returns TRUE when either Expression1 or Expression2 is true, but not both Imp: Performs bitwise comparisons of identically positioned bits in two numerical expressions Eqv: Returns TRUE when both Expression1 and Expression2 are either true or false Or: Returns TRUE when either Expression1 or Expression2 is true

The filtering rules applied to data as they're extracted from the database is known as:

selection criteria.

Which of the following logical operators returns TRUE when both Expression1 and Expression2 are true or both are false?

Eqv

Which operator determines whether an expression's value is same as any value within a list?

In

Which of the following is the reason of losing records during the append process?

Key violation

Which of the following are reasons of lost records that occur during an append process? Each correct answer represents a complete solution. Choose two.

Key violation Type conversion failure

Fill in the blank by selecting the appropriate term related to the failure of an append query from the list.

LOCK violation occurs when the destination table is open in the Design view or is opened by another user on the network

Which of the following is the correct expression to find all records in the contacts field who live in any city with a name beginning with any letter except J, A, or M?

Like "[!JAM]*"

Drag the action query to the matching description.

Make-table: Creates a hard table and captures the result of a query in its own table Append: Affixes records to a table based on the definitions and criteria specified Delete: Affects a group of records that meet a specified criteria applied Update: Amends or changes the records based on the condition and criteria provided

By using which of the following queries a user can modify multiple rows in the underlying tables as a single operation?

Action

Which of the following represents the steps required to create a crosstab query using the query design grid?

Create the aggregate query. On the Design tab, click Crosstab. Under each field in the Crosstab row, select whether the field will be a row heading, a column heading, or a value. Run the query.

Which of the following primary views displays the records returned by the query?

Datasheet view

Which three of the following are primary views of the query design window?

Design Datasheet SQL