Question : Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following SQL statements is used to define
Answered by : homer-simpson
{"tags":[{"tag":"p","content":"b. Alter Table EXAMS Add Primary Key (SUB_NO); "}]}Source : | Last Update : Sun, 02 Apr 23
Question : Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents can’t be insert
Answered by : homer-simpson
{"tags":[{"tag":"textarea","content":"b.\n SUB_NO \t STUDENT_NO \t MARK \t DATE_TAKEN \nSUB1\tS1\t70\t05-23-2020\nSUB2\tS2\t85\t05-23-2020","code_language":"typescript"}]}Source : | Last Update : Sun, 02 Apr 23
Question : Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date, Primary Key (SUB_NO, STUDENT_NO) ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the followin
Answered by : homer-simpson
{"tags":[{"tag":"textarea","content":"d.\n SUB_NO \t STUDENT_NO \t MARK \t DATE_TAKEN \n1\t1\t89\t07-23-2020\n1\t1\t66\t06-23-2020","code_language":"typescript"}]}Source : | Last Update : Sun, 02 Apr 23
Question : Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date Not Null, Primary Key (SUB_NO, STUDENT_NO, DATE_TAKEN) ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table;
Answered by : homer-simpson
{"tags":[{"tag":"textarea","content":"a.\n SUB_NO \t STUDENT_NO \t MARK \t DATE_TAKEN \n1\t1\t\t05-23-2020\n1\t1\t\t05-23-2020\n","code_language":"typescript"}]}Source : | Last Update : Sun, 02 Apr 23
Question : Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents can’t be insert
Answered by : homer-simpson
{"tags":[{"tag":"textarea","content":"d.\n SUB_NO \t STUDENT_NO \t MARK \t DATE_TAKEN \n1\t\t85\t05-23-2020","code_language":"typescript"}]}Source : | Last Update : Sun, 02 Apr 23