Cyber Monday 2023! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: CM25OFF
Welcome to Pass4Success

- Free Preparation Discussions

ECDL Exam ECDL-ADVANCED Topic 2 Question 7 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam
Question #: 7
Topic #: 2

Which of the following characteristics is the most important characteristic of a field that is elected as a primary key in a table?

Show Suggested Answer Hide Answer
Suggested Answer: B

A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column.

Answer option D is incorrect. It is not important to consider the size of a primary key.

Answer option C is incorrect. For using a database, it is not necessary to remember record keys.

Answer option A is incorrect. A simple datatype is helpful in the key indexing, but it is not a primary characteristic.


Objective: Table Design


Currently there are no comments in this discussion, be the first to comment!

Save Cancel