QUESTION 26 The _____ consistency rule ensures that there is a 1-M relationship

Question

QUESTION 26

The _____ consistency rule ensures that there is a 1-M relationship from the parent to the child node.

first

second

third

fourth

QUESTION 27

The _____ consistency rule ensures that only one value is displayed on the main form and in each line of a subform.

first

second

third

fourth

QUESTION 30

No column is dependent on another non-key column. You do not have any redundant non-key information in a table. There are no calculated or derived fields in your table.

1st normal form

2nd normal form

3rd normal form

boyce-codd normal form

QUESTION 31

Meteorologists using the Hurricane database tend to write a lot of long running queries against the Temperatures table. Their queries are typically only reading and writing data from the past 30 days. In contrast, research scientists write a lot of long running queries against the Temperatures table, but they rarely look at data within the last 30 days. What can you do to optimize the Hurricane database for the meteorologists and research scientists?

Copy the database to a different drive on a regular basis for the research scientists, and delete the older data on the original drive for the meteorologists.

Use DDL triggers to move the older data to a different database.

Design a partitioning scheme to store the different data on different filegroups on different physical drives.

Create defaults on the Temperature table to automatically move data older than 30 days to an archive table.

QUESTION 36

A logical link between two or more tables that can be defined through a specific column or set of columns between the tables

attribute

relationship

OLTP

connection

first

second

third

fourth

QUESTION 27

The _____ consistency rule ensures that only one value is displayed on the main form and in each line of a subform.

first

second

third

fourth

QUESTION 30

No column is dependent on another non-key column. You do not have any redundant non-key information in a table. There are no calculated or derived fields in your table.

1st normal form

2nd normal form

3rd normal form

boyce-codd normal form

QUESTION 31

Meteorologists using the Hurricane database tend to write a lot of long running queries against the Temperatures table. Their queries are typically only reading and writing data from the past 30 days. In contrast, research scientists write a lot of long running queries against the Temperatures table, but they rarely look at data within the last 30 days. What can you do to optimize the Hurricane database for the meteorologists and research scientists?

Copy the database to a different drive on a regular basis for the research scientists, and delete the older data on the original drive for the meteorologists.

Use DDL triggers to move the older data to a different database.

Design a partitioning scheme to store the different data on different filegroups on different physical drives.

Create defaults on the Temperature table to automatically move data older than 30 days to an archive table.

QUESTION 36

A logical link between two or more tables that can be defined through a specific column or set of columns between the tables

attribute

relationship

OLTP

connection

Explanation / Answer

Question 26: First

Question 27: Second

Question 30: Third Normal Form

Question 31: Design a partitioning scheme to store the different data on different filegroups on different physical drives.

A partitioning scheme would allow the data to stille appear as one table, but could be optimized for both groups of users. Current data may be kept in one partition on one drive, while older data may be kept in a different partition in a different drive.

Copying the database to a different drive on a regular basis for the research scientists, and delete the older data on the original drive for the meteorologists will be difficult as both groups need to access to the full database even though they focus on portions of data.

Creating defaults on the Temperature table to automatically move data older than 30 days to an archive table cannot be applied in this situation. Defaults can be used only when data is not included.

DDL triggers can be applied only to DDl statements and this solution cannot be applied here.

QUESTION 36: Relationships

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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