当前位置:国家开放大学(数据库基础与应用)题库

问题:

[问答题]

根据下面所给的AAA数据库,写出下列每条查询语句的执行结果,或者写出下列每条语句或程序段的功能。 假设存在名为AAA的数据库,包括Students(学号char(8),姓名varchar(8),年龄int,专业varchar(20),入学日期DateTime)和Score(学号char(8),课程名varchar(10),成绩numeric(5,2))两张表。

create procedure xxk1
as
begin
select *
from students x,score y
where x.学号=y.学号
end

良心 空气呼吸器使用前的检查,关闭气瓶开关,在()min内观察压力指针不下降一格(约2MPa),为供气系统气密性完好 ["2~5","5~10","10~15","15~20"] 液体燃料的主要可燃元素是() ["碳","氢","硫","氧"] 人的高级需要为人的选择和决策规定了最基本的目标。() Your network contains a database server named Server1. Server1 runs the 32-bit version of Windows Server 2003 Enterprise Edition Service Pack 2 (SP2) and has 16 GB of RAM. On Server1, you open Task Manager and discover that the total physical memory shows only 4 GB of RAM. You need to ensure that Server1 has access to all 16 GB of RAM. What should you do? () [" In the Boot.ini file, add the \/PAE switch and then restart the server."," In the Boot.ini file, add the \/3GB switch and then restart the server."," From Performance Options, set Memory Usage to Programs."," From Performance Options, change the initial size of the paging file to 16 GB and then restart the server."]

根据下面所给的AAA数据库,写出下列每条查询语句的执行结果,或者写出下列每条语句或程序段的功能。 假设存在名为AAA的数据库,包括Students(学号char(8),姓名varchar(8),年龄int,专业varchar(20),入学日期DateTime)和Score(学号char(8),课程名varchar(10),成绩numeric(5,2))两张表。

create procedure xxk1
as
begin
select *
from students x,score y
where x.学号=y.学号
end

参考答案:

  参考解析

本题暂无解析

在线 客服