00:01
In this question, let's see some true and false.
00:04
So, answer to first one is false.
00:11
Why? in sql, the change command does not exist.
00:16
To modify values in existing data, you would typically use the update statement in sql.
00:24
Like this.
00:30
But change is not there.
00:39
Next one is true.
00:47
Because theoretically, databases could store instances in columns and characteristics in rows, instead of conventional way of storing characteristics in column and instances in row.
01:02
This concept is known as columnar storage or column -oriented databases like this.
01:11
So these are the relations or the table of our database.
01:16
And in columns, these are called attributes.
01:29
And here we store the instances.
01:35
And in these rows, we store characteristics.
01:55
However, traditional relational databases follow the row -oriented storage model.
02:04
But in this, this is the column -oriented, which is theoretical.
02:42
But in real life, we do the other way...