ExamGecko
Search Search Login
Home Home / CompTIA / FC0-U61
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A user opens an application that is installed locally on a PC. The application connects directly to a database that is located on a server in a data closet in the same building. Which of the following application architecture models does this describe?
A user is selecting software to visually display information in a marketing meeting. Which of the following software types should the user select?
A database administrator has created a primary table and must ensure the date column in the table only accepts date values. Which of the following does the administrator need to set?
Which of the following is a quality of solutions created by web browsers?
On which of the following distinct numbers of digits is the hexadecimal numbering system based?
A customer wants to buy a new laptop with a 2.5Gbps processor. Which of the following best describes the device the salesperson should suggest?
Which of the following is most likely managed directly by the operating system?
Which of the following backup types is most likely to allow restoration of a fully bootable computer on new hardware?
Which of the following is the best way to prevent malicious code from executing on a laptop based on attack signatures?
After purchasing a flash drive, the buyer notices that the packaging had already been opened. Which of the following is this is an example of?

Question 283 - FC0-U61 discussion

Report
Export

A database administrator needs to add a column to an existing table. Which of the following statements should the administrator use?

A.
CREATE
Answers
A.
CREATE
B.
UPDATE
Answers
B.
UPDATE
C.
ALTER
Answers
C.
ALTER
D.
DROP
Answers
D.
DROP
Suggested answer: C

Explanation:

To add a column to an existing table, the database administrator should use the ALTER TABLE statement with the ADD COLUMN clause. This statement allows modifying the structure of a table by adding, deleting, or changing columns and constraints. The CREATE statement is used to create a new table, not to modify an existing one. The UPDATE statement is used to modify the data in a table, not the structure. The DROP statement is used to delete a table or a column, not to add a new column.Reference:

CompTIA IT Fundamentals (ITF+) Certification Guide, page 307

SQL ADD COLUMN - Add One or More Columns To a Table

Show Answer
asked 02/10/2024
Ariel Acosta
35 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms