nerdexam
CompTIA

DA0-001 · Question #97

Daniel is using the structured Query language to work with data stored in relational database. He would like to add several new rows to a database table. What command should he use?

The correct answer is C. INSERT. The INSERT command is used to add new records to a database table. The SELECT command is used to retrieve information from a database. It's the most commonly used command in SQL because it is used to pose queries to the database and retrieve the data that you're interested in…

Data Concepts and Environments

Question

Daniel is using the structured Query language to work with data stored in relational database. He would like to add several new rows to a database table. What command should he use?

Options

  • ASELECT.
  • BALTER.
  • CINSERT.
  • DUPDATE.

How the community answered

(51 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    88% (45)
  • D
    8% (4)

Explanation

The INSERT command is used to add new records to a database table. The SELECT command is used to retrieve information from a database. It's the most commonly used command in SQL because it is used to pose queries to the database and retrieve the data that you're interested in The UPDATE command is used to modify rows in the database. The CREATE command is used to create a new table within your database or a new database on your server.

Topics

#SQL#Relational Databases#INSERT statement#Data Manipulation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice