Which of the following is a valid SQL statement for adding a new row of data to a SQL database table?

A. INSERT INTO users (firstname, lastname) values (‘George’, ‘Washington’);
B. INSERT (‘George’, ‘Washington’) INTO users (firstname, lastname);
C. ALTER TABLE users SET firstname = ‘George’, lastname = ‘Washington’;
D. UPDATE users SET firstname = ‘George’, lastname = ‘Washington’;


Answer: A

Computer Science & Information Technology

You might also like to view...

The ____________ allows the user to browse the system and select a location and name for a file that is about to be saved.

a. Save As dialog box b. Save File dialog box c. Select Source dialog box d. Open dialog box

Computer Science & Information Technology

To avoid a cluttered desktop, you can create a ________ to store related files

Fill in the blank(s) with correct word

Computer Science & Information Technology

Apple's macOS and Microsoft Windows are examples of ________ software.

A. utility B. application C. operating system D. communication

Computer Science & Information Technology

In the user-defined functions shown in the accompanying figure, the box labeled _____ indicates a function name.

A. ?A B. ?B C. ?C D. ?D

Computer Science & Information Technology