exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 137 discussion

Actual exam question from Microsoft's 98-364
Question #: 137
Topic #: 1
[All 98-364 Questions]

This question requires that you evaluate the underlined text to determine if it is correct.
A relational database management system employs the concept of an attribute to ensure that data entered into a field in a column is valid.
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. a primary key
  • C. a constraint
  • D. an index
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
drx
Highly Voted 4 years, 8 months ago
"SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation between the constraint and the data action, the action is aborted. Constraints can be column level or table level. Column level constraints apply to a column, and table level constraints apply to the whole table. The following constraints are commonly used in SQL: NOT NULL - Ensures that a column cannot have a NULL value UNIQUE - Ensures that all values in a column are different PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Uniquely identifies each row in a table FOREIGN KEY - Uniquely identifies a row/record in another table CHECK - Ensures that all values in a column satisfies a specific condition DEFAULT - Sets a default value for a column when no value is specified INDEX - Used to create and retrieve data from the database very quickly"
upvoted 13 times
...
dzoni68
Most Recent 2 years, 11 months ago
The correct answer is Constraints. Option C.
upvoted 1 times
...
Praveen2249
3 years, 2 months ago
Answer C
upvoted 1 times
...
pypaul
3 years, 11 months ago
I believe this should be CONSTRAINTS
upvoted 2 times
...
estherjq
4 years ago
Underlined text: an attribute
upvoted 2 times
...
test048
4 years, 3 months ago
Answer: C
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago