Proper study guides for Refresh Microsoft Microsoft Database Fundamentals certified begins with Microsoft 98-364 preparation products which designed to deliver the Best Quality 98-364 questions by making you pass the 98-364 test at your first time. Try the free 98-364 demo right now.
NEW QUESTION 1
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
- A. Cohort
- B. Relationally dependent
- C. Deterministic
- D. Functionally dependent
- E. Compositional
Answer: D
NEW QUESTION 2
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?
- A. UPDATE
- B. CHANGE
- C. SELECT
- D. INSERT
Answer: A
NEW QUESTION 3
Denormalization is performed in order to:
- A. Reduce redundancy.
- B. Eliminate repeating groups.
- C. Create smaller tables.
- D. Improve query performance.
Answer: D
NEW QUESTION 4
HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
- A. Mastered
- B. Not Mastered
Answer: A
Explanation: 
NEW QUESTION 5
One reason to create a stored procedure is to:
- A. Improve performance.
- B. Minimize storage space.
- C. Bypass case sensitivity requirements.
- D. Give the user control of the query logic.
Answer: A
NEW QUESTION 6
You need to enable a new employee to authenticate to your database. Which command should you use?
- A. ALLOW USER
- B. CREATE USER
- C. ADD USER
- D. INSERT USER
- E. ALTER USER
Answer: B
NEW QUESTION 7
You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?
- A. READ
- B. SELECT
- C. OUTPUT
- D. GET
Answer: B
NEW QUESTION 8
You have the following table definition:
CREATE TABLE Product
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantity INTEGER)
The Product table contains the following data.
You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL How many rows are returned?
- A. 1
- B. 2
- C. 3
- D. 4
Answer: D
NEW QUESTION 9
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
- A. INTEGER
- B. DOUBLE
- C. COUNT
- D. FLOAT
Answer: A
NEW QUESTION 10
In SQL, an insert statement is used to add a:
- A. User to a database.
- B. Row of data to a table.
- C. Table to a database.
- D. Column to a table definition.
Answer: B
NEW QUESTION 11
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
- A. Recover
- B. Restore
- C. Commit
- D. Attach
Answer: B
NEW QUESTION 12
You develop a database to store data about textbooks. The data must be stored to process at a later time.
Which database object should you use to store the data?
- A. View
- B. Table
- C. Function
- D. Stored procedure
Answer: D
NEW QUESTION 13
You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?
- A. JOIN
- B. INSERT
- C. CREATE
- D. UPDATE
Answer: B
NEW QUESTION 14
Which statement deletes the rows where the employee's phone number is not entered?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: A
NEW QUESTION 15
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
- A. 3
- B. 6
- C. 9
Answer: D
NEW QUESTION 16
HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
- A. Mastered
- B. Not Mastered
Answer: A
Explanation: 
NEW QUESTION 17
Which statement creates a composite key?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 18
This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.
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
- B. Table
- C. Index
- D. Row
Answer: D
NEW QUESTION 19
You need to disable User1's access to view the data in the Customer table. Which statement should you use?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: C
NEW QUESTION 20
You execute the following statement:
This statement is an example of a/an:
- A. Subquery
- B. Union
- C. Outer join
- D. Cartesian product
Answer: A
NEW QUESTION 21
......
P.S. Easily pass 98-364 Exam with 130 Q&As Exambible Dumps & pdf Version, Welcome to Download the Newest Exambible 98-364 Dumps: https://www.exambible.com/98-364-exam/ (130 New Questions)
