CISSP PRACTICE QUESTIONS – 20211225

Effective CISSP Questions

You are designing tables using a relational database to store customer orders. Which of the following is not a good practice to enforce database integrity? (Wentz QOTD)
A. Limit order total price to the decimal data type
B. Save OrderLineItems as a table related to its parent table, Orders
C. Store comma-separated values (CSV) in a cell to reduce relationships
D. Configure the primary key (PK) as an auto-increment field in each table

Kindly be reminded that the suggested answer is for your reference only. It doesn’t matter whether you have the right or wrong answer. What really matters is your reasoning process and justifications.

My suggested answer is C. Store comma-separated values (CSV) in a cell to reduce relationships.

Wentz’s book, The Effective CISSP: Security and Risk Management, helps CISSP and CISM aspirants build a solid conceptual security model. It is a tutorial for information security and a supplement to the official study guides for the CISSP and CISM exams and an informative reference for security professionals.

A table with a field, Color, that contains CSV

Storing comma-separated values (CSV) in a cell doesn’t conform to the first normal form (1NF); it results in duplicate data and inconsistency. There are three types of database integrity: semantic, referential, and entity integrity.

  • Limiting order total price to the decimal data type enforces semantic integrity.
  • Saving OrderLineItems as a table related to its parent table, Orders removes repeated data. Foreign key constraints and transactions enforce referential integrity.
  • Configuring the primary key (PK) as an auto-increment field in each table enforces entity integrity.

Reference


您正在使用關聯式資料庫來設計資料表以儲客戶訂單。 以下哪一項不是確保資料庫完整性的好做法? (Wentz QOTD)
A. 限制訂單的總價為十進制數據類型
B. 將訂單明細資料儲存為與其父訂單資料表相關的獨立表格
C. 在一個表格的儲存格中儲存以逗號分隔值 (CSV) 以減少關係
D. 將主鍵(PK)配置為每張表中的自動編號欄位



Leave a Reply