java笔试 - 套题(5 答案在尾)

森！！仔

已于 2022-04-30 20:51:06 修改

阅读量926

点赞数 2

分类专栏： java笔试题文章标签： java 后端 database mysql 面试

于 2022-03-05 16:44:34 首次发布

本文链接：https://blog.csdn.net/zs1972551648/article/details/123297197

版权

试题

1，SQL

Table Name: Students
        Name                        Null?                                 Type
------------------------ ------------------------ ---------------------------------------------------
Student_ID                 NOT NULL                         NUMBER (10)
Student_Name           NOT NULL                         VARCHAR (25)
Gender                                                  VARCHAR (6)
Birthday                                                                   DATE
ID_Card_No               NOT NULL                         VARCHAR (20)
Nationality                                                             VARCHAR (25)
Native_Place                                                         VARCHAR (25)
Major                         NOT NULL                           VARCHAR (50)
Class_Grade                                                            VARCHAR (20)
Enrollment_Date                                                      DATE

Table Name: Student_Scores
Name                                 Null?                                 Type
------------------------ ------------------------ ---------------------------------------------------
Score_ID                         NOT NULL NUMBER (12)
Student_ID                      NOT NULL                         NUMBER (10)
Course_Name                 NOT NULL                           VARCHAR (50)
Teacher_Name                                                            VARCHAR (25)
Score                              NOT NULL                         NUMBER (3 , 2)
Exam_Date