中国大学MOOC: 已知SC(S#, C#, Score)关系的元组，如下所示{,,, , , , , , , }。关于“SELECT S# FROM SC WHERE C#= ‘C1’ and C#= ‘C3’；”下列说法正确的是_____。
举一反三
- 【其它】1. 给定关系 R 和 S : R 1 2 3 4 A1 B1 C1 D1 A1 B1 C2 D2 A1 B1 C3 D3 A2 B2 C1 D1 A2 B2 C2 D2 A3 B3 C1 D1 S 1 2 C1 D1 C2 D2 试求下列结果: (1) p 3,4 (R) ∪S (2) p 3,4 (R) -S (3) p 3,4 (R) ∩S (4)R ∞ S c=(R.3=S.1)and (R.4=S.2) (5) s 1=a2 (R) (6) ( p 1,2 (R) ́ S) - R c
- 查询选修了课程号为“C1”的学生的姓名和年龄，若用下列SQL的SELECT语句表达时，错误的是( )。 A: SELECT SNAME，AGE FROM S WHERE B: S#=(SELECT S C: S#FROM SC WHERE D: C#='C1') E: SELECT SNAME，AGE FROM S，SC WHERE F: S#=S G: S# AND S H: C#='C1' I: SELECT SNAME，AGE FROM S，SC WHERE J: S#=S K: S# AND S L: C#='C1' ORDERBY M: S# N: SELECT SNAME，AGE FROM S WHERE O: S#=(SELECT S P: S# FROM SC WHERE S Q: C#='C1')
- 39号元素钇的核外电子排布式是下列排布中的（ ） A: 1 s 2 2 s 2 2 p 6 3 s 2 3 p 6 3 d 10 4 s 2 4 p 6 4 d 1 5 s 2 B: 1 s 2 2 s 2 2 p 6 3 s 2 3 p 6 3 d 10 4 s 2 4 p 6 5 s 2 5 p 1 C: 1 s 2 2 s 2 2 p 6 3 s 2 3 p 6 3 d 10 4 s 2 4 p 6 4 d 2 5 s 1 D: 1 s 2 2 s 2 2 p 6 3 s 2 3 p 6 3 d 10 4 s 2 4 p 6 5 s 2 5 p 1
- 查询选修了课程号为'C2'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的？（） A: SELECT S#，SNAME FROM S WHERE S# = (SELECT SS# FROM SC WHERE C# = 'C2' ) B: SELECT S#，SNAME FROM S，SCWHERE S# = SS# AND C# = 'C2' C: SELECT S#，SNAME FROM S，SC WHERE S# = SS# AND C# = 'C2' ORDER BY S# D: SELECT S#，SNAME FROM S WHERE S# IN (SELECT SS# FROM SC WHERE C# ='C2' )
- 试判断原子态：1s1s3S1,1s2p3P2,1s2p1D1,2s2p3P2中，下面哪组是存在的？ A: 1s1s3S1,1s2p3P2; B: 1s2p3P2,1s2p1D1; C: 1s2p3P2,2s2p3P2; D: 1s1s3S1,1s2p1D1;