MENU
You are creating a table to store book information for a library. The boot has a reference number (ISBN_ID), as well as a unique identifier (BOOK_ID).
For the CDT to be created, which data type should you choose for the BOOK_ID? (Choose the best answer.)
Suggested Answer: B, C
Get Premium ACD200 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
ET
Ethan
10 months ago
B is too precise for a simple ID, stick with A!
LI
Lili
11 months ago
Wait, can we really use integers for BOOK_ID? Seems odd.
DE
Devora
11 months ago
No way, D would make more sense for a unique identifier.
RO
Rosio
11 months ago
I think A is the best choice too!
MI
Mickie
11 months ago
Definitely A, integers are perfect for IDs!
CA
Carlene
12 months ago
I don’t think Boolean makes sense here at all. It has to be a number, but I’m torn between Integer and Decimal.
ER
Ernest
12 months ago
I’m a bit confused about whether Decimal could be used, but I feel like it’s not necessary for an ID.
TE
Telma
12 months ago
I remember practicing a question like this, and I chose Integer for unique IDs. It seems like the most logical choice.
DE
Delbert
1 year ago
I think the BOOK_ID should be an Integer since it's a unique identifier, right? But I'm not entirely sure.
VE
Venita
1 year ago
I'm confident the answer is Number (Integer). It's a unique identifier, so an integer is the logical choice. The other options just don't seem appropriate for this use case.
ST
Stephane
1 year ago
A Date data type doesn't seem right for a unique book identifier. That's more for, well, dates. I'm leaning towards the Number (Integer) option.
MA
Maurine
1 year ago
Hmm, I'm a bit unsure about this one. I'm not sure if a Number (Decimal) would be better than an Integer for a unique identifier. I'll have to think about it a bit more.
AN
Annice
1 year ago
I think the best data type for the BOOK_ID would be a Number (Integer). It's a unique identifier, so an integer would be the most appropriate choice.
DO
Donte
1 year ago
The Find Children Activity sounds like it could be a good option. I'll have to try that and see if it returns all the anchor elements.
TR
Tricia
1 year ago
This is a tricky one. I know the GDPR is all about protecting user data, so I'm guessing the right answer has to do with companies trying to avoid strict data protection requirements. I'll go with option B.
KA
Kanisha
1 year ago
I'm just imagining someone trying to use a Boolean for a book ID. 'Is this book true or false?' Silly, just go with the integer!
MA
Margurite
1 year ago
User 3: Agreed, integer makes the most sense for a unique identifier.
LE
Leanora
1 year ago
User 2: Yeah, that would be confusing. Integer is the way to go.
NY
Nydia
1 year ago
User 1: Definitely not Boolean, that's for sure.
DE
Deandrea
1 year ago
Option C) Date? Really? Unless your library only has one book and it was published on a specific date, that's not gonna work. A) Number (Integer) is the clear winner here.
JI
Jill
1 year ago
Hmm, option B) Number (Decimal) is an interesting choice, but I think that's overkill for a simple book ID. I'd stick with the classic integer.
LA
Lauran
1 year ago
User 3: I think using a decimal for the BOOK_ID would just complicate things unnecessarily.
ST
Stefan
1 year ago
User 2: Yeah, keeping it simple with an integer makes the most sense for a unique identifier.
LE
Lenna
1 year ago
User 3: Decimal seems unnecessary for a book ID, integer is definitely the way to go.
TA
Talia
1 year ago
User 2: Yeah, using a whole number for the unique identifier makes sense.
LE
Lenora
1 year ago
User 1: I agree, option A) Number (Integer) is the best choice for the BOOK_ID.
RE
Ressie
1 year ago
User 1: I agree, option A) Number (Integer) is the best choice for the BOOK_ID.
SI
Sina
1 year ago
I agree, A) Number (Integer) is the way to go. Anything else would just be confusing and not fit the requirements of a unique book identifier.
TR
Tricia
1 year ago
I think A) Number (Integer) is the most suitable choice for the unique identifier.
TR
Tricia
1 year ago
A) Number (Integer)
RA
Raymon
1 year ago
Definitely go with option A) Number (Integer). A book's unique identifier should be a whole number, not a decimal or a date. Boolean wouldn't make sense either.
GE
Georgiann
2 years ago
I see both points, but I think Date would be the best data type for BOOK_ID. It can provide a unique timestamp for each book entry, ensuring no duplicates.
FR
France
2 years ago
I disagree, I believe the best data type for BOOK_ID should be Number (Decimal). This would allow for more flexibility in case we need to include non-integer identifiers in the future.
MO
Moon
2 years ago
I think the best data type for BOOK_ID would be Number (Integer). It should be a whole number to uniquely identify each book.