下面哪个是合法的序列化数据格式?() A: O:7:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";s:25;} B: O:7:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";i:25;} C: O:8:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";s:25;} D: O:8:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";i:25;}
下面哪个是合法的序列化数据格式?() A: O:7:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";s:25;} B: O:7:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";i:25;} C: O:8:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";s:25;} D: O:8:"Student":2:{s:4:"name";s:4:"qian";s:3:"age";i:25;}
学生表s有4个字段分别为:sno,sname,sex,age,要在表s中删除字段age,可选用的SQL语句是( )。 A: delete age from s; B: alter table s delete age; C: update s age; D: alter table s drop age;
学生表s有4个字段分别为:sno,sname,sex,age,要在表s中删除字段age,可选用的SQL语句是( )。 A: delete age from s; B: alter table s delete age; C: update s age; D: alter table s drop age;
若要删除基本表S中的Age列,应该选用的SQL语句是( )。 A: DELETE Age FROM S B: ALTER TABLE DROP Age C: UPDATE S Age D: ALTER TABLE S ‘Age’
若要删除基本表S中的Age列,应该选用的SQL语句是( )。 A: DELETE Age FROM S B: ALTER TABLE DROP Age C: UPDATE S Age D: ALTER TABLE S ‘Age’
在“学生-选课-课程”数据库中的3个关系如下:S(SNO, SNAME, SEX, AGE);SC(SNO, CNO, GRADE); C(CNO, CNAME, TEACHER),查找选修“不学C2”这门课程学生的学生名,若用关系代数表达式来表示为( )。 A: πSNAME,AGE(σCno≠‘2’(S∞SC)) B: πSNAME,AGE(S)-πSNAME,AGE(σCno='2'(S∞SC)) C: πSNAME,AGE(σCno≠‘2’(C∞SC)) D: πSNAME,AGE(σCno≠‘2’(S∞C))
在“学生-选课-课程”数据库中的3个关系如下:S(SNO, SNAME, SEX, AGE);SC(SNO, CNO, GRADE); C(CNO, CNAME, TEACHER),查找选修“不学C2”这门课程学生的学生名,若用关系代数表达式来表示为( )。 A: πSNAME,AGE(σCno≠‘2’(S∞SC)) B: πSNAME,AGE(S)-πSNAME,AGE(σCno='2'(S∞SC)) C: πSNAME,AGE(σCno≠‘2’(C∞SC)) D: πSNAME,AGE(σCno≠‘2’(S∞C))
1, It’s natural to spend one’s time alone at the age of 12.
1, It’s natural to spend one’s time alone at the age of 12.
假定有学生关系S,结构为S(SID, SNAME, AGE),其中SID为学号,SNAME为姓名,AGE为年龄。查询所有比“李军”年龄大的学生的姓名、年龄,正确的SQL语句是( )。 A: SELECT SNAME, AGE FROM S WHERE AGE > ( SELECT AGE FROM S WHERE SNAME = '李军' ) B: SELECT SNAME, AGE FROM S WHERE AGE >( SNAME= '李军' ) C: SELECT SNAME, AGE FROM S WHERE AGE > ( SELECT AGE WHERE SNAME='李军' ) D: SELECT SNAME, AGE FROM S WHERE AGE>李军.AGE
假定有学生关系S,结构为S(SID, SNAME, AGE),其中SID为学号,SNAME为姓名,AGE为年龄。查询所有比“李军”年龄大的学生的姓名、年龄,正确的SQL语句是( )。 A: SELECT SNAME, AGE FROM S WHERE AGE > ( SELECT AGE FROM S WHERE SNAME = '李军' ) B: SELECT SNAME, AGE FROM S WHERE AGE >( SNAME= '李军' ) C: SELECT SNAME, AGE FROM S WHERE AGE > ( SELECT AGE WHERE SNAME='李军' ) D: SELECT SNAME, AGE FROM S WHERE AGE>李军.AGE
姓名、性别、年龄。要在表S中删除一个属性“年龄”,可选用的SQL语句是()。 A: UPDATE S Age B: DELETE Age from S C: ALTER TABLE S ‘Age’ D: ALTER TABLE S DROP Age
姓名、性别、年龄。要在表S中删除一个属性“年龄”,可选用的SQL语句是()。 A: UPDATE S Age B: DELETE Age from S C: ALTER TABLE S ‘Age’ D: ALTER TABLE S DROP Age
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是() A: DELETE FOR AGE>30 B: DELETE FROM S WHERE AGE>30 C: DELETE S FOR AGE>30 D: DELETE S WHERE AGE>30
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是() A: DELETE FOR AGE>30 B: DELETE FROM S WHERE AGE>30 C: DELETE S FOR AGE>30 D: DELETE S WHERE AGE>30
假设有三个基本表:学生表S、课程表C、学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SQL语句是( )。 A: SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=”王华”) B: SELECT SN,AGE,SEX FROM S WHERE SN=”王华” C: SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=”王华”) D: SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE
假设有三个基本表:学生表S、课程表C、学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SQL语句是( )。 A: SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=”王华”) B: SELECT SN,AGE,SEX FROM S WHERE SN=”王华” C: SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=”王华”) D: SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE
Certificate of Vessel’s Age
Certificate of Vessel’s Age