1 CREATE TABLE Student (2 StudentID INT NOT NULL,3 FirstName VARCHAR(40),4 LastName DATETIME,5 DegreeID INT,6 PRIMARY KEY (StudentID),7 FOREIGN KEY (DegreeID) );Which line will cause a syntax error?Group of answer choices7456231

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

Create Table EXAMS (        SUB_NO integer Not Null,        STUDENT_NO integer Not Null,        MARK decimal (3),        DATE_TAKEN date);This SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents cannot be inserted to the EXAMS table (assume date format is correct)?Question 5Select one:a. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 S1 62 2 S2 85 b. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 72 05-23-20202 2 85 c. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 05-23-20202 2 85 05-23-2020d. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 98.5 05-23-20201 1 85 05-23-2020

Which of the following statements will execute successfully? [Choose any TWO]INSERT INTO Student(Id, Name, Gender, DOJ) VALUES(1, 'Alice', 'F', NULL);INSERT INTO Student(Id, Gender) VALUES( 1, 'F');INSERT INTO Student(Id, Name) VALUES(1, 'Alice');INSERT INTO Student(Id, Name, Gender, DOJ) VALUES (1,NULL, 'F', '20-JAN-15');

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

Select the correct answerAnswer the correct and legal expression in SQL?OptionsSELECT NAME FROM STUDENT_DATA;SELECT NULL FROM STUDENT_DATA;SELECT * FROM STUDENT_DATA WHEN SNAME = NULL;SELECT # FROM STUDENT_DATA;