You are sourcing feedback from students on college services. Each student can provide up to 10000 characters worth of feedback in an online form, which will then be stored in a database. Identify the correct SQL syntax to create the “Feedback” column.1 pointarticle CHAR(10000)article TEXT(10000)
Question
You are sourcing feedback from students on college services. Each student can provide up to 10000 characters worth of feedback in an online form, which will then be stored in a database. Identify the correct SQL syntax to create the “Feedback” column.1 pointarticle CHAR(10000)article TEXT(10000)
Solution
The correct SQL syntax to create the "Feedback" column which can store up to 10000 characters would be:
Feedback TEXT
In SQL, the TEXT data type can store a string with a maximum length of 65,535 characters. So, it is more than enough to store 10000 characters. The CHAR data type is fixed-length character type while the TEXT data type is a variable-length character type.
Note: You don't need to specify the length for TEXT data type.
Similar Questions
Mr. Carl Merkel wants to create another basic table in the cm_devices database to store the customers' feedback. This table must include three columns:● Feedback ID column, ● Feedback type column with a maximum of 100 characters, ● A comment column with a maximum of 500 characters. The feedback table is illustrated below.Feedback ID Feedback type Feedback comment Feed0001 Good It is a very good product but the delivery was not great. Feed0002 Very good No comment You are required to complete the following tasks:A. Declare the columns with the right data type for each.
A college database contains a table called “Students” that has three columns: username, full name and email address. The username column contains alphanumeric values such as “St001” and has a fixed length of five characters. Select the correct SQL syntax for the username column.1 pointusername CHAR(5)username VARCHAR(5)
Write the SQL statement that creates the feedback table.
Question 2Which of the following SQL statements uses the right syntax to create the Student table in a college database with character limits? 1 point123456CREATE TABLE students ( username CHAR(5), fullName VARCHAR(100), email VARCHAR(255));123456CREATE TABLE students ( username CHAR, fullName VARCHAR, email VARCHAR);
What should you avoid when giving feedback?Micro-yes questionData pointsImpact statementBlur words
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.