【简答题】对下列两个关系模式: 学生(学号,姓名,年龄,性别,家庭住址,班级号) 班级(班级号,班级名,班主任,班长) 使用GRANT语句完成下列授权功能: 1) 授予用户U1对两个表的所有权限,并可给其他用户授权。 2) 授予用户U2对学生表具有查看权限,对家庭地址具有更新权限。 3) 将对班级表查看权限授予所有用户。 4) 将对学生表的查询、更新权限授予角色R1。 5) 将角色R1授予用户U1,并且用户...
【简答题】单表数据检索 数据库为:xkxt 数据表:五张表 【检索表中所有的记录】: 1.检索学生表中所有学生的记录,并显示每条记录所有字段的数据 【检索指定字段的数据】: 2.检索学生表中所有学生的记录,每条记录仅显示“学号、学生名”两个字段的信息。 【检索符合条件的记录】: 3.检索学生表中,班级号为1的学生记录。 【利用关键字检索符合条件的记录】 4.检索选择表中,score字段的值为空值的记录。 5...
【简答题】Both of my parents insisted _______ a computer for me, but I don’t think it is necessary. A.to buy B.buying C.on buying D.in buying
【单选题】Both of my parents prefer news to foreign news when they listen to the radio..A.localB.locateC.i
A.
60. Both of my parents prefer news to foreign news when they listen to the radio.. A.local
【多选题】现有学生管理数据库,包含三个表,其结构如下,其中加下划线的字段或字段组合为主键。 学生表( 学号 ,姓名,性别,出生日期,班级) 课程表( 课程号 ,课程名,学分,教师号) 选课表( 学号,课程号 ,成绩) 下面语句的功能是:创建每门课平均成绩的视图ca,包括课程号和平均成绩两列。请将该语句补充完整。 CREATE VIEW ca( (1) ) AS SELECT 课程号, (2) FROM (...
【简答题】句型转换。 1. Both of my parents are teachers. (改为否定句) ________ of my parents ________ a teacher. 2. He borrowed the book a week ago. (改为同义句) He has ________ the book ________ a week ago. 3. I have ever be...
【简答题】完型填空There is an old saying that husbands and wives start to look and behave like each other after a time. I don't know if this was true of my mother and father.Both of my parents had brown hair and br...
【单选题】I called both of my parents yesterday. To my surprise, of them answered it.
【单选题】. Both of my parents insisted _______ a computer for me, but I don’t think it is necessary.
【单选题】Both of my parents insist ______ a computer for me, but I don’t think it is necessary.