单选题 已知关系模式:R(a, b, c)和S(d, e, f),创建如下视图: CREATE VIEW theView AS SELECT a,’cs145’ AS class,f FROM R,S WHERE R.b = S.e; 并执行下列查询Q: SELECT a FROM theView WHERE theView.f>10; 以下哪个查询与Q结果相同? A、SELECT a FROM R,S WHERE R.class =’cs145’ AND S.f>10; B、SELECT a FROM R NATURAL JOIN S WHERE S.f>10; C、SELECT a FROM R, S WHERE R.b= S.e AND S.f>10; D、SELECT a FROM theView,S WHERE S.f>10.
【正确答案】 C
【答案解析】