TCO 1) All of the following filters work EXCEPT (Points : 5) filter by selection

Question

TCO 1) All of the following filters work EXCEPT (Points : 5)

filter by selection with an equal condition.

filter by selection with a comparison operator.

filter by selection with an edit operator.

filter by form with a comparison operator.

Question 5. 5. (TCO 1) Which of the following is NOT one of the query wizards in Access? (Points : 5)

Find Duplicates Query Simple Query Multi-Tabular Query Crosstab Query

Question 6. 6. (TCO 2) Which of the following is NOT a database system? (Points : 5) Hierarchical Network Relational SQL

Question 7. 7. (TCO 2) Which of the following is supported by a primary key? (Points : 5) Changeable over time May be null Unique Updateable

Question 8. 8. (TCO 3) A property that provides a user friendly name to a column in Datasheet view is a(n) (Points : 5) caption. default value. input mask. rule.

Question 9. 9. (TCO 3) A functional dependency is (Points : 5) a logical relationship between attributes of a table. a logical primary key. a composite key. a unique identifier.

Question 10. 10. (TCO 3) Which of the following does NOT apply to the following relationship image? Image Description: Three Tables are pictured: Table 1: Suppliers with a primary key of SupplierID and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductID and fields: ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a primary key of CategoryID and fields: Categoryname, Description, and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. (Points : 5)

A one-to-many relationship is applied. The display is showing the Design view of relationships. One table is not joined to the other two tables. A join exists on two primary keys.

Question 11. 11. (TCO 4) Which of the following does NOT describe the following one-to-one relationship? Image Description: There are two tables. Table number 1 is named Employees and has a primary key of EmpID with fields: LastName, FirstName, and Salary. Table number 2 is named NewEmployees and has a primary key of EmpID with fields of LastName, FirstName, and Hiring Expenses. The two tables are related with a line. The line has no symbols. (Points : 5) The tables must have exactly the same fields. The Employees and NewEmployees tables use the same primary key. More tables can be joined to either table. It may be used for security reasons to protect data availability.

Explanation / Answer

(5)

In the case of Access one of query is not supported query wizards that is Multi tabular query.

The above queries perform operations on wizard and Multi tabular query is not perform operation on wizards.

Thus the correct option is Multi tabular query

(6)

The following are data base systems       

SQL is not data base systems, because of SQL is structured query language.

Thus the correct option is SQL.

(7)

Unique feature, it supported to the key exist in the database as unique that means there is no duplicate.

Thus the correct option is Unique

(8)

Caption , it provides a user friendly name to a column in Datasheet view.

Thus the correct option is caption.

(9 )

Functional dependencies maintain the relation between the tables in the database.

·         It is depends on the key that is unique in the table.

·         Unique key of the one table will be placed in other table to maintain the relationship between the two tables.

·         The relationship is comes under the functional dependencies between the tables.

Thus the correct option is unique.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.