Informatics Practices
Assertion. INSERT, UPDATE, DELETE, SELECT are the DML commands.
Reason. The DML commands manipulate the data stored in the database tables.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
2 Likes
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
INSERT, UPDATE, DELETE, and SELECT are the DML (Data Manipulation Language) commands in SQL. These commands manipulate the data stored in the database tables. INSERT adds new records, UPDATE modifies existing records, DELETE removes records, and SELECT retrieves data based on specified criteria.
Answered By
2 Likes
Related Questions
Assertion. The INSERT INTO statement can skip some columns' values.
Reason. Only the columns allowing the NULL values or have default-value-defined, can be skipped in INSERT INTO statement of SQL.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. The PRIMARY KEY can be defined only once in the CREATE TABLE command.
Reason. If the PRIMARY KEY is a composite key, then it is not defined with the individual columns but at the end of the table definition as a table constraint.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. The PRIMARY KEY and FOREIGN KEY constraints are similar.
Reason. The FOREIGN KEY constraint links a column of a table with the PRIMARY KEY constraint of another table.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion. Data types varchar and char are the same as they both represent the string data.
Reason. The VARCHAR datatype stores variable string length while CHAR datatype stores the string always as fixed length strings.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.