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
D. insert a new table
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: C. A, B, C only
Explanation
INSERT can add one row, several rows (multi-row VALUES or INSERT … SELECT), or values for only specified columns. Creating a table needs CREATE TABLE.More Database Management Systems questions
- 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…
- Consider a relation schema R = (U, V, W, X, Y, Z), on which the following functional dependencies hold: {U → V, VW → X, Y → W, X → U}. The…
- Consider a schema R(P, Q, R, S) and the functional dependencies P → Q, Q → R, R → S, S → Q. Then the decomposition of R into R₁(P, Q), R₂(Q…