MENU
Select two suitable statements regarding creating a new table.
Suggested Answer: A
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
32 comments · newest first
JA
Janey
11 months ago
Row names being limited to 16 characters seems a bit odd.
EL
Elbert
11 months ago
Wait, can you really use any characters for a table name?
BR
Britt
12 months ago
Totally agree, the 'CREATE TABLE' statement is a must!
FR
Freida
12 months ago
I thought there was a limit on columns?
KA
Kathrine
12 months ago
A newly created table is indeed empty and has 0 rows.
MA
Mable
1 year ago
I thought table names could include numbers and underscores, so I'm not sure about option C being true.
NI
Nicholle
1 year ago
I remember practicing a question about the 'CREATE TABLE' statement, so I think option E is also a suitable choice.
IR
Irma
1 year ago
I'm not sure about the limit on columns; I feel like there might be a maximum, but I can't remember the exact number.
BO
Bo
1 year ago
I think option B is definitely correct since a new table starts empty with 0 rows.
HO
Howard
1 year ago
This question seems straightforward, I think I can handle it.
LE
Leonida
1 year ago
I've got this! The TOGAF Architecture Content Framework clearly defines a Catalog as a type of artifact that presents lists of things. That's the answer I'm going with.
CR
Crissy
1 year ago
I think A is also a correct statement. There's no hard limit on the number of columns in a table, as long as you don't exceed the overall database size limit. But B and E are the clear winners here.
RO
Roslyn
1 year ago
I think B and E are the most important points to remember when creating a new table.
PA
Patrick
1 year ago
E is crucial, the 'CREATE TABLE' statement is essential for creating a new table.
TI
Timothy
1 year ago
Definitely, B is important to remember. A new table starts with 0 rows until you add data.
HA
Harris
1 year ago
I agree, A is a valid statement. You can have as many columns as you need in a table.
GE
Gennie
1 year ago
I think B and E are the key points to remember when creating a new table.
CA
Candra
1 year ago
True, A is important to note. But B and E are essential for creating a new table.
SH
Sherill
1 year ago
Definitely, B and E are the most important. A new table starts empty and the 'CREATE TABLE' statement is crucial.
MA
Marguerita
1 year ago
I agree, A is a valid statement. You can have as many columns as needed.
GL
Glory
1 year ago
Haha, imagine trying to create a table with just 16 character row names. That would be a nightmare! But B and E are definitely the right answers here.
JI
Jimmie
1 year ago
Yeah, B and E are definitely the correct statements when creating a new table.
KR
Kristofer
1 year ago
I agree, having a limit of 16 characters for row names would be tough.
LO
Lonna
1 year ago
I'm not sure about the upper limit on columns, but I know the table name can use alphanumeric characters, not just alphabetic. And the row name length limit is definitely longer than 16 characters.
IV
Ivan
2 years ago
B and E seem correct to me. A table is definitely created empty with 0 rows, and the CREATE TABLE statement is used to create a new table.
SH
Shoshana
1 year ago
It's important to use alphabetic characters for a table name.
EF
Effie
1 year ago
That's right. There is no upper limit to the number of columns in a table.
FI
Fidelia
1 year ago
Yes, the CREATE TABLE statement is used to create a new table.
SH
Shelia
1 year ago
B and E are correct. A table starts empty with 0 rows.
RO
Ronald
2 years ago
I'm not sure about statement A. Isn't there a limit to the number of columns a table can have?
ME
Meghann
2 years ago
I agree with you, Trinidad. Statement A makes sense because a table can have as many columns as needed, and statement B is true because a new table starts with 0 rows.
TR
Trinidad
2 years ago
I think statement A and B are suitable for creating a new table.