Informatics Practices
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.
SQL Queries
1 Like
Answer
A is false but R is true.
Explanation
The VARCHAR and CHAR data types are not the same, as they differ in how they store string data. The VARCHAR data type stores variable-length string, while the CHAR data type stores strings as fixed-length character strings.
Answered By
2 Likes
Related Questions
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.
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.
How are SQL commands classified ?
Differentiate between DDL and DML commands.