exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 90 discussion

Actual exam question from Microsoft's 70-464
Question #: 90
Topic #: 1
[All 70-464 Questions]

You have a Microsoft Azure SQL Database instance.
The database contains a disk-based table named ContentTable that has 1 million rows and a column named Fax. Fax allows null values.
You need to update Fax to meet the following requirements:
✑ Prevent null values from being used.
✑ Always use an empty string instead of a null value.
Which statement or statements should you execute? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
  • E. Option E
Show Suggested Answer Hide Answer
Suggested Answer: ABE 🗳️
E: First change the NULLs to ' '.
A: Then set the default to the column to ' '.
B: Finally add the NOT NULL constraint to the column.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Kepty
4 years, 6 months ago
Answers are correct, but the explanation is a bit wrong - you need to set NOT NULL first, then set default value
upvoted 1 times
LiamLin
3 years, 9 months ago
Should be DEFAULT FIRST to prevent new record will not null UPDATE EMPTY NOT NULL
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...