皮皮学，免费搜题
登录
搜题
【单选题】
在已打开数据库的情况下，利用SQL创建一个包含姓名、课程名称和成绩字段的xsview视图，正确的语句是（ ）。 查看材料A.
CREATE VIEW xsview ASSELECT学生．姓名，课程．课程名称，成绩．成绩FROM学生INNER JOIN成绩INNER JOIN课程WHERE成绩．课程编号：=课程．课程编号 AND学生．一成绩．
B.
CREATE VIEW xsview As（SELECT学生．姓名，课程．课程名称，成绩．成绩FROM学生INNERJOIN成绩INNER JOIN课程ON成绩．课程编号=课程．课程编号ON学生．=成绩．）
C.
CREATE VIEW xsview ASELECT学生．姓名，课程．课程名称，成绩．成绩WHERE学生INNER JOIN成绩INNER JOIN课程ON成绩．课程编号=课程．课程编号ON学生．=成绩．
D.
CREATE VIEw Xsview ASELECT学生．姓名，课程．课程名称，成绩．成绩FROM学生INNER JOIN成绩INNER JOIN课程ON成绩．课程编号=课程．课程编号ON学生．=成绩．
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】A. It's killing me. B. dentists C. You have already delayed too long. D. I'm not feeling so good. E. since yesterday morning. A: Hey, big brother. You don't look well today. B: ##1## A: What's the mat...
【单选题】听力原文：M: I' ve just brought your mower back. Thanks for lending it to me. Where shall I leave it? W: Just put it behind the door. Use the mower again anytime you need it. Q: What's the relationship bet...
A.
Relative.
B.
Roommates.
C.
Colleagues.
D.
Neighbors.
【简答题】《安全生产法》第三条规定“安全生产管理，坚持（ ）的方针”。
【单选题】听力原文：W: Why, you're back so early! It's just 10: 30. M: I just could not focus on the books. I was so sleepy in the class because last night the noise from the construction site near our house kept me...
A.
The classroom was under construction.
B.
He couldn't focus on the class due to the noise.
C.
He felt that his studying was not effective.
D.
He went back to get the book left at home.
相关题目：