Proper study guides for Updated Microsoft Microsoft Database Fundamentals certified begins with Microsoft 98-364 preparation products which designed to deliver the Pinpoint 98-364 questions by making you pass the 98-364 test at your first time. Try the free 98-364 demo right now.
2016 Jun 98-364 Study Guide Questions:
Q61. You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
A. Inherited delete
B. Cascade delete
C. Functional delete
D. Waterfall delete
E. Domino delete
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Q63. This question requires that you evaluate the underlined text to determine if it is correct.
A row holds information for a single record in a table.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
C. Data type
Rebirth database administration fundamentals mta exam 98-364 training:
Q64. The component that holds information for a single entry in a table is called a:
A. Data type
Q65. First normal form requires that a database excludes:
A. Foreign keys
B. Composite keys
C. Duplicate rows
D. Repeating groups
Q66. You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data:
You need to normalize the data to third normal form.
How many tables should you create?
Simulation microsoft 98-364 study guide:
Q67. Which two keys establish a relationship between two tables? (Choose two.)
Q68. You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?
Q69. You have a table named Employee that includes four columns.
You execute the following statement:
Which columns are returned?
A. all columns
B. only the last column
C. only the first column
D. only the first and last columns
Q70. You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
B. Relationally dependent
D. Functionally dependent