Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA Exam DS0-001 Topic 4 Question 40 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 40
Topic #: 4
[All DS0-001 Questions]

A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table?

A)

B)

C)

D)

Show Suggested Answer Hide Answer
Suggested Answer: B

The query that the administrator should use to create the table is option B. This query uses theCREATE TABLEstatement to define a new table namedXYZwith three columns:ID,Name, andAge. Each column has a data type and a constraint, such asNOT NULL,PRIMARY KEY, orCHECK. The other options either have syntax errors, use incorrect keywords, or do not specify the table name or columns correctly.Reference:CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify and apply database structure types.


by Alise at May 05, 2025, 07:15 AM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Carlee
3 days ago
I'm gonna have to go with Option B. It's a bit more verbose, but I like how it explicitly specifies the column definitions.
upvoted 0 times
...
Zita
8 days ago
Option C looks good to me. It's concise and covers all the necessary elements for creating a table.
upvoted 0 times
...
Anika
28 days ago
I think the correct query to create table XYZ is Option B.
upvoted 0 times
...

Save Cancel