98-364 Exam
The Secret of 98-364 actual exam
Want to know Testking 98-364 Exam practice test features? Want to lear more about Microsoft Microsoft Database Fundamentals certification experience? Study Highest Quality Microsoft 98-364 answers to Latest 98-364 questions at Testking. Gat a success with an absolute guarantee to pass Microsoft 98-364 (Microsoft Database Fundamentals) test on your first attempt.
Q61. You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?
A. ALTER
B. INSERT
C. CREATE
D. UPDATE
Answer: A
Q62. 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.
Answer:
Q63. Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q64. The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
A. View
B. Function
C. Index
D. Stored procedure
E. Trigger
Answer: C
Q65. You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
A. VARCHAR (3, 30)
B. CHAR (3, 30)
C. VARCHAR (30)
D. CHAR (30)
Answer: C
Q66. What is one difference between an update statement and a delete statement?
A. An update statement can change only one row.
B. A delete statement cannot use a where clause.
C. An update statement does not remove rows from a table.
D. A delete statement works only within a stored procedure.
Answer: C
Q67. In which situation do you need to perform a restore on a database?
A. when data becomes corrupted in the database
B. when you need to roll back a transaction
C. when you encounter an error in your application
D. when data needs to be deleted from the database
Answer: A
Q68. You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operation is called a/an:
A. Intersection
B. Outer join
C. Equi-join
D. Cartesian product
Answer: D
Q69. HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Answer:
Q70. 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?
A. 1
B. 2
C. 3
D. 4
Answer: C