Which of the following commands can be used to modify data in an SQL table?
A. INSERT
B. DELETE
C. UPDATE
D. SELECT
Choose the correct answer from the options given below:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. A, B, C only
Explanation
INSERT, DELETE and UPDATE are DML commands that change table data. SELECT only reads data.More Database Management Systems questions
- Which of the following tables contains the primary information in a data warehouse?
- The INSERT command is used to A. add a single tuple to a relation B. add multiple tuples to a relation C. add values to specific attributes…
- Match List I with List IIList I List II A. Hadoop Distributed File System I. Trust B. Veracity II. Facebook C. Apache Pig III. Name-Node D.…
- The degree of a relation in a database is
- Match List I with List IIList I List II A. Project Join Normal Form I. Concurrency B. The lost update problem II. Fifth Normal Form C. Disc…
- In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic values. F = {CH → G, A → BC, B → CFH, E → A, F → EG} is a set o…