QUESTION 131
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 |
Correct Answer: B
QUESTION 132
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 |
Correct Answer: A
QUESTION 133
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 |
Correct Answer: D
QUESTION 134
You need to delete a database table. Which data definition language (DDL) keyword should you use?
A. |
ALTER |
B. |
DELETE |
C. |
DROP |
D. |
TRUNCATE |
Correct Answer: C
QUESTION 135
This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
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. |
INTERSECT |
C. |
ALL |
D. |
UOIN |
Correct Answer: B
QUESTION 136
You need to store the contact information for each student in your school database. You should store each student’s information in a:
A. |
Stored procedure |
B. |
Function |
C. |
Row |
D. |
Variable |
Correct Answer: C
QUESTION 137
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. |
Correct Answer: A
QUESTION 138
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.
Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Correct Answer:
QUESTION 139
This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a database.
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. |
UPDATE |
C. |
INSERT |
D. |
CREATE |
Correct Answer: D
QUESTION 140
This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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. |
GRANT SELECT |
C. |
LET HEAD |
D. |
PERMIT READ |
Correct Answer: B
Free VCE & PDF File for Microsoft 98-364 Real Exam
Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF