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)

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);

Student Relation Student_ID   Student_Name   Dept_Name 0000 AAAAA Computer Science1111 BBBBB Computer Science2222 CCCCC  Business Administration Question 13Select one:a.CREATE TABLE Student(   Student_ID int,   Student_Name char(20),   Dept_Name char(20),);b.CREATE TABLE Student(   Student_ID int,   Student_Name varchar(100),   Dept_Name varchar(100),);c.CREATE TABLE Student(   Student_ID int,   Student_Name char(100),   Dept_Name char(100),);d.CREATE TABLE Student(   Student_ID char(20),   Student_Name char(100),   Dept_Name char(100),);

Which database feature can be used to list the names of the male students from a particular class?*1 pointFormTableReportQuery

Problem StatementIn a university's academic department, a database table named "students" that stores information about students, including their student ID, name, enrolled course, and scores obtained in different subjects.The university administration wants to analyze the performance of students and identify those who scored above a certain threshold. To facilitate this analysis, you are tasked with creating a stored procedure named "GetHighScorers".The following table is already created, and the records are inserted into the table.TABLE: students student_id INT PRIMARY KEY, student_name VARCHAR(50), course VARCHAR(50), score INT

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)