MENU
Select the correct SQL statement to define a new data type.
Suggested Answer: E
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
RI
Rikki
10 months ago
I thought it was CREATE CLASS for some reason.
CO
Corinne
10 months ago
Wait, can you really create a new data type like that?
MA
Maryann
10 months ago
Yeah, E is definitely the right choice!
CA
Catalina
10 months ago
E makes the most sense, but I’m surprised it’s that simple!
SH
Sherron
10 months ago
Pretty sure it's E, CREATE TYPE.
LA
Lashon
11 months ago
I’m a bit confused; I thought "CREATE DATABASE" was for creating databases, not data types.
DE
Detra
11 months ago
I feel like "CREATE CLASS" might be related to object-oriented databases, but it doesn't sound right for defining a data type.
MI
Milly
11 months ago
I remember practicing a question about creating functions and types, and "CREATE TYPE" seems to fit this context.
JU
Juan
11 months ago
I think defining a new data type is usually done with "CREATE TYPE," but I'm not completely sure.
HE
Helga
12 months ago
I got this! The answer is CREATE TYPE. I'm feeling confident about that one.
RE
Regenia
12 months ago
CREATE TYPE, definitely. That's the SQL statement used to define a new data type.
JO
Jospeh
12 months ago
I'm a bit unsure on this one. Is it CREATE FUNCTION or CREATE TYPE? I'll have to review my notes.
SH
Shenika
1 year ago
Ah, I remember learning about this in class. I'm pretty sure the correct answer is CREATE TYPE.
GI
Gilberto
1 year ago
Hmm, this one looks tricky. I'll have to think carefully about the SQL syntax for defining new data types.
MA
Mari
1 year ago
I heard the exam was so tough, they had to CREATE GOD just to define a new data type.
LA
Laurel
1 year ago
You guys are overthinking this. Just create a new database and let the database engine handle the data types. Simple as that!
FA
Fatima
1 year ago
Yeah, I agree. Creating a new database is not the same as defining a new data type.
BE
Ben
1 year ago
I think the correct SQL statement to define a new data type is E) CREATE TYPE.
LE
Leonor
1 year ago
But creating a new database doesn't define a new data type.
IR
Ira
1 year ago
Wait, what? I thought we were supposed to CREATE FUNCTION to define a new data type. Oh well, guess I need to review my SQL syntax again.
JE
Jeniffer
1 year ago
Yeah, I agree with Keneth. CREATE TYPE is the way to go. Can't wait to use my custom data types in my next project!
JA
James
1 year ago
I'm excited to use my custom data types in my next project!
JE
Jennie
1 year ago
I agree, CREATE TYPE is the way to go for custom data types.
PA
Patria
1 year ago
I think CREATE TYPE is the correct SQL statement for defining a new data type.
WH
Whitley
1 year ago
I'm not sure, but I think CREATE DATABASE could also be used to define a new data type.
KE
Keneth
1 year ago
Hmm, I think the answer is E. CREATE TYPE. That's the one that allows us to define a new data type, right?
DA
Dahlia
1 year ago
I agree, CREATE TYPE is the right choice for defining a new data type.
MA
Madelyn
1 year ago
Yes, you're correct. CREATE TYPE is the correct SQL statement to define a new data type.
LA
Larue
1 year ago
I agree with Benedict, CREATE TYPE makes sense for defining a new data type.
BE
Benedict
1 year ago
I think the correct answer is E) CREATE TYPE.