upgraded _生活经验

“apt-get update” 和 “upgrade”的区别是什么？“apt-get update” 和 “upgrade”的区别：1、update是下载源里面的metadata的. 。包括这个源有什么包,每个包什么版本之类的；2、upgrade是根据update命令下载的metadata决定要更新什么包(同时获取每个包的位置)3、安装软件之前, 可以不upgrade, 但是要update；4、因为旧的信息指向了旧版本的包, 但是源的服务器更新了之后旧的包可能被新的替代了, 于是你会遇到故障。更新“apt-get update”的原因：1、Linux 和 Windows 不一样，同一发行版（比如 Ubuntu) 的不同版本（比如 14.04, 14.10 ）用的软件仓库是不一样的，所以有仓库 (repository ) 这样的概念，自然就有了要更新仓库信息的逻辑；2、一般来说你不更新仓库信息， upgrade 就在本地的旧仓库转悠一圈发现并没有要更新的，但实际上本地仓库已经过时了；3、这也是为什么用 apt 查找某个包的命令是 apt-cache search xxx 的原因，用的是本地 cache 了仓库信息。
update和upgrade有何区别update

英 [ʌp'deɪt]
美 [,ʌp'det]
n. 更新；现代化
vt. 更新；校正，修正；使现代化
upgrade

英 [ʌp'greɪd]
美 [,ʌp'ɡred]
n. 升级；上升；上坡
vt. 使升级；提升；改良品种
adj. 向上的
adv. 往上

linux 升级命令 update upgrade dist-upgrade的区别update更新软件列表信息,包括版本,依赖关系等

upgrade在不改变现有软件设置的基础上更新软件
dist-upgrade会改变配置文件,改变旧的依赖关系

更新版本实际上就是更新软件包,debian采用滚动升级,所以dist-upgrade仅用来升级软件,ubuntu则用dist-upgrade来版本(版本升级会修改大量配置文件)

Linux中的update和upgrade分别是更新什么

文章插图

sudo apt-get update下载最新的软件列表。从软件源（也就是服务器）下载最新的软件包列表文件，更新本地软件包缓存信息（包含软件名，版本，校验值，依赖关系等）。具体下载文件在目录：/var/lib/apt/listssudo apt-get upgrade安装更新。下载最新软件包，并替换系统上过时的软件。具体下载文件在目录：/var/cache/apt/archives 。扩展资料：系统内核的路由转发：Linux操作系统嵌入了TCP/IP协议栈，协议软件具有路由转发功能。路由转发依赖作为路由器的主机中安装多块网卡，当某一块网卡接收到数据包后，系统内核会根据数据包的目的IP地址，查询路由表。然后根据查询结果将数据包发送到另外一块网卡，最后通过此网卡把数据包发送出去。此主机的处理过程就是路由器完成的核心功能。通过修改Linux系统内核参数ip_forward的方式实现路由功能，系统使用sysctl命令配置与显示在/proc/sys目录中的内核参数。首先在命令行输入：cat/proc/sys/net/ipv4/ip_forwad，检查Linux内核是不是开启IP转发功能。如果结果为1，表明路由转发功能已经开启；如果结果为0，表明没有开启。出于安全考虑， Linux内核默认是禁止数据包路由转发的。在linux系统中，有临时和永久两种方法启用转发功能。参考资料来源：百度百科-linux
apt-get的update和upgrade的区别update

update 是同步 /etc/apt/sources.list 和 /etc/apt/sources.list.d 中列出的源的索引，这样才能获取到最新的软件包。

upgrade

upgrade 是升级已安装的所有软件包，升级之后的版本就是本地索引里的，因此，在执行 upgrade 之前一定要执行 update, 这样才能是最新的。

An update should always be performed before an upgrade or dist-upgrade.

upgrade is used to install the newest versions of all packages
currently installed on the system from the sources enumerated in
/etc/apt/sources.list. Packages currently installed with new versions
available are retrieved and upgraded.

modernized是什么意思modernized
[英]['mɒdə(:)naɪzd][美]['mɒdə(:)naɪzd]
v.
使现代化，使适应现代需要( modernize的过去式和过去分词 ); 现代化，使用现代方法;
网络
现代化的; 使现代化;
形近词：modernisermodernizer

1
Helicopters have been upgraded and modernized.
直升机已经更新换代，装配了现代化设备。

upgraded version是什么意思upgraded version是
升级版的意思

upgraded storage 是什么意思upgraded storage
升级存储

双语例句

1
The interior of the console offers upgraded cable management as wellas flexible storage arrangements.
内部的定制控制台可以提供升级版的线缆管理以及灵活的存储安排。

2
Calculation of wake field and couple impedance of upgraded and oldRF cavity in Hefei electron storage ring
合肥电子储存环上新旧高频腔的尾场及耦合阻抗的计算

storage是什么意思storage英[ˈstɔ:rɪdʒ]美[ˈstɔrɪdʒ, ˈstor-]
n.贮存; 贮藏; 储藏处，仓库; 贮存器，蓄电（瓶）
[例句]The coated strip is protected by new colorless non-poisonous chemical passivation and oiling free from corrosion in transportation and storage.
采用新的化学无色、无毒钝化工艺以及涂油方法对镀带进行再保护，以防止在运输、贮存过程中腐蚀。
[其他]复数：storages 形近词： moorage foorage

upgraded version是什么意思upgraded version
网络升级版;
[例句]Gold Shark: Ocean Star is an upgraded version.
金色狂鲨：是海洋之星的升级版。

update和upgrade的区别？update和upgrade的区别：1、update 强调时间上的更新。2、upgrade 强调技术/等级上的更新。拓展资料update的用法1、He was back in the office, updating the work schedule on the computer 他已回到办公室，正在电脑上更新工作日程。2、She had heard the news-flash on a TV channel's news update. 她在一家电视台的新闻快讯中听到了这则简明新闻。3、We'll update you on the day's top news stories 我们将为您提供当天的重要新闻。4、Airlines would prefer to update rather than retrain crews. 航空公司更愿意换新员工而不是对旧员工重新进行培训。5、I would just update them on any news we might have. 我们一有新消息我就会告诉他们。upgrade的用法1、Helicopters have been upgraded and modernized 直升机已经更新换代，装配了现代化设备。2、He was upgraded to security guard. 他被擢升为保安。3、You can upgrade from self-catering accommodation to a hotel. 您可以将自理膳食旅店升级为酒店。4、Medical facilities are being reorganized and upgraded. 正在对医疗设施进行重组和升级。5、They upgrade, install, and virtualize servers and applications. 他们升级、安装和虚拟化服务器与应用程序。
Linux中的update和upgrade分别是更新什么yum -y update升级所有包同时也升级软件和系统内核yum -y upgrade只升级所有包，不升级软件和系统内核

Linux中的update和upgrade分别是更新什么apt-get是某些linux发行版使用的一个“包管理器”（还有别的发行版使用yum等，以及brew等其他平台上的包管理器，工作原理类似）。
包管理器的作用是从源（Source）服务器那里下载最新的软件包列表，然后在你需要安装某个软件包（apt-get install）的时候从列表里面查询这个软件包的版本信息、系统要求、翻译、依赖项（该软件正常运行必须安装的其它软件）并且添加到同时安装的列表里面，再查询所有安装列表里面的软件包的.deb文件下载地址，最后批量下载，自动分析安装顺序然后安装完成。
但是这个软件包列表是不会被自动下载的，需要用户使用apt-get update更新。这样，apt-get才能知道每个软件包的最新信息，从而正确地下载最新版本的软件。
至于apt-get upgrade，则是对已经安装的软件包本身进行更新的过程。由于确定要更新的软件包需要对本地安装的版本和列表的版本进行比较，所以要在update以后运行这一条。
要求在install操作之前执行update和upgrade ，实际上是确保本地软件列表信息和已安装软件均为最新的过程。这样做可以最大限度地确保新安装的软件包正常工作。

一般来说， update和upgrade不需要每次安装软件之前都运行，安装新软件的话一天左右运行一次即可，不安装软件的时候隔十天半个月运行一下来更新软件包，服务器系统如果没有安全性更新就别乱更新了，稳定最重要。

PS：软件源服务器地址可以在/etc/apt/sources.list里面看到。

apt-get update 和 upgrade 的区别1、apt-get update是同步 /etc/apt/sources.list 和 /etc/apt/sources.list.d 中列出的源的索引，这样才能获取到最新的软件包。2、apt-get update只是更新了apt的资源列表，没有真正的对系统执行更新。如果需要，要使用apt-get upgrade来更新。

apt-get update 和 upgrade 的区别apt-get dist-upgrade 什么作用？apt-get update对应的就是第一步。apt-get upgrade 与apt-get dist-upgrade对应的是第二步。由于包与包之间存在各种依赖关系。upgrade只是简单的更新包，不管这些依赖，它不和添加包，或是删除包。而dist-upgrade可以根据依赖关系的变化，添加包，删除包。一般在运行upgrade或dist-upgrade之间，要运行update.

fully upgraded a skin什么意思fully upgraded a skin
完全巩固皮肤
焕肤精华

upgraded succuessfully，是什么意思upgraded　successfully

升级成功

fully-licensed是什么意思？按国内的情况翻译的话就是
四证齐全

We should upgade a house or two to make room for new smurfs.是什么意思？我们应该upgade （你应该是抄错了）一到两间房间以便给新的蓝精灵（根据你给的词语翻译）腾出空间。

希望帮到你！

Gade是什么意思？盖德

bedook的翻译是：什么意思没有查到bedook这个单词，近似拼写的英语单词是：betook
betook
英[bɪˈtʊk]美[bɪ'tʊk]
v.去，往，到（某处、某人处）( betake的过去式 );
[例句]He betook himself to hard study.
他专心苦读。
[其他]原型： betake

gcrues的翻译是：什么意思

文章插图

gcrues女装(简称gc），是宝熙国际旗下快时尚女装品牌。gcrues（gc女装），上海宝熙服饰有限公司旗下快时尚女装品牌。打造个性、潮流、混搭的时尚产品。gcrues打破常规，从设计到工艺、从颜色到板型、从细节到搭配，展现其细腻的手法。gcrues女装将田园、生活、艺术完美结合，营造艺术、时尚、轻松自然的购物环境，艺术与商业的完美融合，是gcrues散发无限魅力的源泉。扩展资料：gcrues，源自以时装、红酒闻名于世的法国。它的产品主要针对19-31岁的时尚女性。gcrues目前已在全国开设34家店铺，分布在江苏，山东，河北区域。目前品牌有进入银泰城，和谐广场，万达广场系统。gcrues girl的年龄在19-31岁左右，她们乐于拥有独特的个性，她们喜欢逛街、旅行、艺术、工作。gcrues girl是一群张扬个性、追求自由、散发活力和尽享都市时尚炫彩生活的新新人类。gcrues为她们生活场合中的职场、休闲、娱乐、聚会带来了独特的设计和品质。参考资料来源：百度百科-GCRUES
ATN的翻译是：什么意思ATN是augmented transition network的缩写形式，翻译成中文是：[计] 扩充转移网络augmented transition network英[ɔ:ˈɡmentid trænˈziʃən ˈnetwə:k]美[ɔɡˈmɛntɪd trænˈzɪʃən ˈnɛtˌwɚk][词典]扩充转移网络;[例句]Syntactic analysis is an important part in natural language processing (NLP). This paper mainly discusses the syntactic analysis methods used inNLP, such as context-free grammars, transformational grammar, parsing,transition network, augmented transition network etc. 语法分析是自然语言处理中的关键环节，本文就自然语言处理中应用到的上下文无关语法、转换语法、剖析、转换网络和扩充转换网络等语法分析方法进行了论述。
交互设计专业到底是干什么的随着现在设计专业的划分越来越细致，许多新兴专业也逐渐崛起，其中就包括
交互设计

但是对于交互设计，许多同学们都不太了解，甚至因为同样涉及到产品，因此容易和工业设计混为一谈，今天我们就来跟大家详细讲一讲
交互设计与工业设计的区别
工业设计是一个很宽泛的概念，它的设计构思上需要考虑到产品整体外型线条、各种细节特征的相关位置、颜色、材质、音效、人因工程等；产品范围上包括杯子、电脑、交通工具等实体产品。认为「工业设计」是与「互联网产品设计」并行的概念，行业性较强。

交互设计是一种设计方法，或者理念：它定义人造物的行为方式相关的界面，包括目标用户、使用流程与结果；并且考虑到有用性、可用性、情感因素等。

不管是工业设计，还是互联网产品设计，以用户为中心的设计模式和理念都越来越流行，因此也越来越重视「交互设计」，一些团队的职能分工上有专门的「交互设计师」。因此简单地说，「交互设计」是「工业设计」整体过程中需要考虑的一个环节。
工业设计和交互设计从其历史和目前现状看，差异很大，分属不同范式。但未来双方必定互相融合。

二者的差异
1、产品特点差异：工业产品的特点“形式即功能” 。而交互产品功能多，操作复杂，使用层级多，形式和功能关系不大。
2、产品成本的差异：交互产品开发成本、购买成本低，开发时间短，但客户使用投入的机会成本高，因此其成败在于客户的使用体验。工业产品，购买成本高，因此其造型很重要。
3、设计方法上差异：目前交互设计还处与“以用户的目标为导向”的设计阶段，交互设计的目的就是帮助用户快捷方便的达到目标。如果将“帮助用户达到目标”看做交互产品的功能，那么交互设计还处于“形式追随功能”的现代主义阶段。

交互能给工业设计带来什么
1、包豪斯的失败：为什么形式追随功能会在工业产品中失败呢，原因在于这个原则的自相矛盾。如果将形式和功能看做一种映射关系，那么一种形式应该具有一种功能，工业品应该是标准化的。但如果将功能看做形式的约束条件的话，那么仅有一种功能的工业品，其形式的可能性是无限的。这样就造成了一种矛盾。
2、交互的馈赠：交互产品是功能集约产品。在未来，智能产品将不仅限于计算机，而将广泛的嵌人日常工业品。这样日常工业品的功能势必增加，那么就会打破前文所述的矛盾。

最有趣，脑洞最大的艺术公开课，
ROSSO等你来哦！▼▼▼▼▼

交互设计要学什么？随着现在设计专业的划分越来越细致，许多新兴专业也逐渐崛起，其中就包括交互设计但是对于交互设计，许多同学们都不太了解，甚至因为同样涉及到产品，因此容易和工业设计混为一谈，今天我们就来跟大家详细讲一讲交互设计与工业设计的区别工业设计是一个很宽泛的概念，它的设计构思上需要考虑到产品整体外型线条、各种细节特征的相关位置、颜色、材质、音效、人因工程等；产品范围上包括杯子、电脑、交通工具等实体产品。认为「工业设计」是与「互联网产品设计」并行的概念，行业性较强。交互设计是一种设计方法，或者理念：它定义人造物的行为方式相关的界面，包括目标用户、使用流程与结果；并且考虑到有用性、可用性、情感因素等。不管是工业设计，还是互联网产品设计，以用户为中心的设计模式和理念都越来越流行，因此也越来越重视「交互设计」，一些团队的职能分工上有专门的「交互设计师」。因此简单地说，「交互设计」是「工业设计」整体过程中需要考虑的一个环节。工业设计和交互设计从其历史和目前现状看，差异很大，分属不同范式。但未来双方必定互相融合。二者的差异1、产品特点差异：工业产品的特点“形式即功能” 。而交互产品功能多，操作复杂，使用层级多，形式和功能关系不大。2、产品成本的差异：交互产品开发成本、购买成本低，开发时间短，但客户使用投入的机会成本高，因此其成败在于客户的使用体验。工业产品，购买成本高，因此其造型很重要。3、设计方法上差异：目前交互设计还处与“以用户的目标为导向”的设计阶段，交互设计的目的就是帮助用户快捷方便的达到目标。如果将“帮助用户达到目标”看做交互产品的功能，那么交互设计还处于“形式追随功能”的现代主义阶段。交互能给工业设计带来什么1、包豪斯的失败：为什么形式追随功能会在工业产品中失败呢，原因在于这个原则的自相矛盾。如果将形式和功能看做一种映射关系，那么一种形式应该具有一种功能，工业品应该是标准化的。但如果将功能看做形式的约束条件的话，那么仅有一种功能的工业品，其形式的可能性是无限的。这样就造成了一种矛盾。2、交互的馈赠：交互产品是功能集约产品。在未来，智能产品将不仅限于计算机，而将广泛的嵌人日常工业品。这样日常工业品的功能势必增加，那么就会打破前文所述的矛盾。最有趣，脑洞最大的艺术公开课，ROSSO等你来哦！▼▼▼▼▼
交互设计和服务设计的区别交互设计（英文Interaction Design, 缩写IXD) ，是定义、设计人造系统的行为的设计领域，它定义了两个或多个互动的个体之间交流的内容和结构，使之互相配合，共同达成某种目的。交互设计努力去创造和建立的是人与产品及服务之间有意义的关系，以“在充满社会复杂性的物质世界中嵌入信息技术”为中心。交互系统设计的目标可以从“可用性”和”用户体验“两个层面上进行分析，关注以人为本的用户需求[1] 。中文名交互设计外文名Interaction Design又称互动设计定义设计人造系统的行为的设计领域专业技能丨交互设计专业解析453播放快速导航起源创作流程主要内容相关信息界面设计设计原则混乱因素行业发展人机交互设计原则与准则设计流程设计规范相关学者概述交互设计的思维方法建构于工业设计以用户为中心的方法，同时加以发展，更多地面向行为和过程，把产品看作一个事件，强调过程性思考的能力，流程图与状态转换图和故事板等成为重要设计表现手段，更重要的是掌握软件和硬件的原型实现的技巧方法和评估技术[1] 。交互设计在于定义人造物的行为方式(the "interaction",即人工制品在特定场景下的反应方式）相关的界面。交互设计作为一门关注交互体验的新学科在二十世纪八十年代产生了，它由IDEO的一位创始人比尔·摩格理吉（Bill Moggridge）在1984年一次设计会议上提出，他一开始给它命名为“软面（Soft Face）” ，由于这个名字容易让人想起和当时流行的玩具“椰菜娃娃（Cabbage Patch doll）”，他后来把它更名为“Interaction Design”，即交互设计。

想请问下什么是交互设计？交互设计师以创造有用且实用的产品及服务为宗旨。以用户为中心作为设计的基本原理，交互设计的实际操作必须建立在对实际用户的了解之上：包括他们的目标、任务、体验、需求等等。
以用户为中心的角度出发，同时努力平衡用户需求、商业发展目标和科技发展水平之间的关系，交互设计师为复杂的设计挑战提供解决方法，同时定义和发展新的交互产品和服务动画是交互的一小小部分，这只是一个表象，这其中包含了很多背后的科学调研和组织架构的梳理，才让以一个简单轻松的样子被看到。

从深层次来讲，交互设计是以目标为导向的设计，通过研究创建用户模型。在设计过程中，遵循用户心理模型，以用户体验为核心，构建和谐的组织，让用户直面目标，减少工作，消除负担。
如果没有合理安排好每一步的行为，没有合理的反馈和指导，用户就会迷失在过程中，很有挫败感，再也不会尝试使用了。

mass storage是什么意思mass storage
1. [计] 大容量存储器
海量存储器
大容量存储
2.短语
mass network storage system 海量网络存储系统
mass spectra storage disc 大容量存储磁盘
mass selective storage 质量选择存储

storage的意思贮存器

在主板里的storage是表示什么意思?storage
存储(器,空间);【动】存储;〔储存器〕
1. The retention of data in a storage device.
数据保存在存储设备中的现象。2.The action of placing data into a storage device. | 将数据放入存储设备中的动作。3.A storage device.一种存储设备。4.In word processing, a unit into which recorded text can be entered, in which it can be retained and processed, and from which it can be retrieved. | 字(词)处理技术中的一种装置,记录的正文可送入其中,可在其中保存和处理,而且可从其中检索出来。5.A computer section used primarily for storing information in electrostatic, ferroelectric, magnetic, acoustic,optical, chemical, electronic, electrical, mechanical, etc., form. Such a section is sometimes called a memory, or a store (in British terminology). | 计算机的一种部件,主要用于以静电、铁电、磁、声、光、化学、电子、电、机械等方式存储信息。这种部件有时称 memory 或store(英国术语) 。6. A device, or part of a device, that can retain data. | 一种可以保存数据的设备或设备中的一部分。参阅associative storage, auxiliary storage, buffer storage, capacitor storage, cathode ray storage, circulating storage, core storage,cryogenic storage, delay line storage, direct access storage, dynamic storage, electrostatic storage,erasable storage, external storage, first

clearstorage是什么意思？【upgraded】clear storage是“清除储存器”的意思。

多普达手机storage是什么意思，多普达手机storage就是手机的rom即(手机自带内存)

在手机里或同步电脑后,资源管理的根目录就可以看到这个storage的文件夹了.

你安装的软件要求你放到这个storage文件夹里的,你装好后storage里面有其他子文件夹的,你说的目录就是这些子文件夹里的,你按照提示把文件从相应文件夹里复制粘贴到指定的文件夹操作就可以了.

（主题在themes里）
就是你下载的软件解压缩后子文件夹当中的一个,你一个个打开查找就可以看到了.
另外storage card是外置储存卡,例如SD卡或TF卡等

使用myeclipse时，导入一个项目时，出现这样的语句，The following projects must be upgraded to work你工程里的插件和使用的插件冲突了

myeclipse导入项目， the follwing projects must be upgraded to work correctly with MyEclispe 9&above家里的电脑用的Myeclipse10.6，办公室用的是8.6，后来我把办公室电脑换用10.6后，也报个这错误，就有点不解了。
后来无意中发现，新建Maven项目时，有2个，一个是自己安装的插件，另一个是Myeclipse自带的Maven4MyEclipse 。后来把自己安装的Maven插件删除后就没有问题了。
这个问题出现的很神奇，估计是插件冲突造成的吧。

在Myeclipse新建的工程出现这样错误，怎么解决？？谢谢刚刚琢磨出来了……坑死人了……
别用MyEclipse的jdk，自己重新配置一个外部的jdk，我MyEclipse原本的jdk少了很多的jar包，不知道你是不是这个原因

DB2 730 题库？1.
A UDT is a data type which:
A.must contain unique values.
B.cannot be CAST to other data types.
C.is created using the CREATE DISTINCT command.
D.contains a value that was automatically calculated from values in other
columns.
2.
Which of the following statements allows USER1 to take away read access on the table
ORG. TAB1 from USER2?
A.REVOKE SELECT FROM user2 ON TABLE org.tab1
B.REVOKE SELECT ON TABLE org.tab1 FROM user2
C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
3.
Which of the following resources can be referenced in the LOCK statement?
A.Row
B.Table
C.Column
D.Table space
4.
Given the following table definition:
STOCK:
itemVARCHAR (30)
statusCHAR (1)
quantityINT
priceDEC ( 7,2 )
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and
PRICE to zero, which of the following statements would be used to update the STOCK
table to indicate that all the items whose description begins with the letter "S" are out of
stock?
A.UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE
'S%'
B.UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item
LIKE 'S%'
C.UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0
WHERE item LIKE 'S%'
D.UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item
LIKE 'S%'
5.
Given that tables T1 and T2 contain the following rows:
Table Ti:Table T2:
C1C2C1C2
------------------------------
1411
1312
1213
Which of the following queries will return only those rows that exist in both T1 and T27
A.SELECT*FROM tl
UNION
SELECT*FROM t2
B.SELECT*FROM tl
UNION DISTINCT
SELECT*PROM t2
C.SELECT*FROM tl
INTERSECT
SELECT*FROM t2
D.SELECT*FROM tl WHERE(cl,c2)=(SELECT cl,c2FROM t2)
6.
A user utilizing an alias to update a subset of columns in a table must have UPDATE
privileges on which of the following DB2 objects?
A.Table
B.Columns
C.Table and Alias
D.Columns and Alias
7.
In which situation is shredding XML data recommended?
A.When the data is naturally tabular
B.When the number of nodes are volatile
C.When the data by nature has sparse attributes
D.When the data is of Iow volume and requires a complex star-schema topology
8.
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A.An application process acquires at least a share lock on the current row of
every cursor.
B.Any row that is read during a unit of work cannot be changed by other
application processes until the unit of work is complete.
C.Any row changed by another application process can be read, even if the
change has net been committed by that application process.
D.An application process that issues the same query more than once in a unit
of work will net see additional rows caused by other application processes appending new
information to the database.
9.
Which of the following DB2 products are required on an iSeries or System i server to
enable an application running on that server to retrieve data from a DB2 database on a
Linux server?
A.DB2 for i5/OS
B.DB2 Runtime Client
C.DB2 Connect Enterprise Edition
D.DB2 for i5/OS SQL Development Kit
10.
A user needs to create a trigger that will update table T2 whenever a row is added to table
T1. Assuming the user has all appropriate privileges for table T2, which privilege is
required on table T1 to create the trigger?
A.REFERENCES
B. SELECT
C. UPDATE
D. ALTER
11.
Application A is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE employee SET salary = salary *1.1 WHERE empno='000010'
UPDATE department SET deptname ='NEW dept'WHERE deptno='A00'
Application B is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE department SET deptname = ' OLD DEPT ' WHERE deptno= ' A00 '
UPDATE employee SET salary = salary *0.5 WHERE empno=' 000010'
Application A and application B execute their first SQL statement at the same time. When
application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?
A.The database manager will rollback the transaction in both applications.
B.The database manager will rollback the transaction in one of the two applications.
C.Application B will successfully update the EMPLOYEE and DEPARTMENT
tables; Application A will be placed in a lock wait state.
D.Application A will successfully update the EMPLOYEE and DEPARTMENT
tables; Application B will terminate when the lock timeout value is reached.
12.
If application A issues the following SQL statement, which of the following statements
about concurrency is true?
SELECT deptno,deptname,mgrno
FROM dept
WHERE admrdept='A00'
FOR READ ONLY WITH RS
A.Rows accessed by application A can be seen by other applications.
B.Rows accessed by application A cannot be seen by other applications.
C.Application A can see uncommitted changes made by other applications.
D.Results produced by re-execution of the statement by application A will not
be affected by other applications.
13.
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored
procedure?
A.Control Center
B.Development Center
C.Developer Workbench
D.Stored Procedure Builder
14.
Which of the following is the lowest cost DB2 product that can be legally installed on an
AIX server?
A.DB2 Express Edition
B.DB2 Personal Edition
C.DB2 Workgroup Server Edition
D.DB2 Enterprise Server Edition
15.
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The
TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost.
Which of the following commands is required to update the local node directory so that a
DB2 client can access this DRDA database?
A.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D.CATALOGTCPIPNODEmydb2srvREMOTEmyhostSERVER
192.168.10.1
16.
Given the following query:
SELECT quantity,
CASE WHEN itemcode ='099'THEN'SILVER'
WHEN itemcode ='788'THEN'GOLD'
WHEN itemcode ='899'THEN'PLATINUM'
ELSE' ERROR'
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE
expression?
SUPPLIER
..........................................
QUANTITYITEMCODE
3099
4099
1788
1899
5009
3788
1899
A.3,SILVER
4,GOLD
1,SILVER
1,GOLD
5,PLATINUM
3,SILVER
1,GOLD
B.3,SILVER
4,SILVER
1,GOLD
1,PLATINUM
S,ERROR
3,GOLD
1,PLATINUM
C.3,SILVER
4,SILVER
1,PLATINUM
1,ERROR
5,SILVER
3,GOLD
1,PLATINUM
D.3,SILVER
4,SILVER
1,GOLD
1,GOLD
5,SILVER
3,ERROR
1,PLATINUM
17.
A "trusted" client needs to communicate with a sewer that has been configured to use
CLIENT authentication. Which of the following will be used to verify passwords?
A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system
18.
Within the application MY_APP the following PREVIOUS VALUE expression references
the sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq

After which of the following events will the most recently generated value of MY_SEQ
persist so that it can be returned to the active MY_APP application?
A.After a ROLLBACK is issued
B.After the sequence is altered
C.After the sequence is dropped
D.After the current session ends
19.
Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE
S ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of
the following is true?
A.The next value will be 0 and the sequence will never use the values 101 to
105.
B.The next value will be 101 to ensure uniqueness between existing and newly
generated sequence values.
C.Previously cached values are retained by DB2, and after the restart, will be
used for values 101 to 105.
D.The next value will be 0 and DB2 will not ensure uniqueness between
existing and newly generated values.
20.
To which of the following resources can a lock be applied?
A.Row
B.Alias
C.Bitmap
D.Column
21.
Which of the following statements is used to grant user TOM and Application team
APPGRP the ability to add data to table TAB1?
A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
CGRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
22.
Assuming PUBLIC has been granted all privileges on table T1, which of the following
statements would continue to permit any user to add rows to table T1, but not remove
them?
A.REVOKE DROP ON tl FROM PUBLIC
B.REVOKE UPDATE ON tl FROM PUBLIC
C.REVOKE DELETE ON tl FROM PUBLIC
D.REVOKE CONTROL ON tl FROM PUBLIC
23.
On which of the following database objects may the SELECT privilege be controlled?
A.Sequence
B.Schema
C.Group
DView
24.
The opening of cursor CSR01 produces the following result set:
STUDENTLASTNMFIRSTNMCLASSNO
123BrownJohnT100
213BaileyJamesT100
312CarterArleneT210
465ChaseDevonT305
546DavisStevenT405
IfthisFetch statementisexecuted:
FETCH csr01INTO:studnum,:firstname,:lastname,:class
Which of the following DELETE statements will cause this row- to be deleted?
A.DELETE ALL FROM tab01 FOR CURRENT OF cst01
B.DELETE FROM tab01 FOR CURRENT cst01 WITH RS
C.DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D.DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
25.
Given the following statements:
CREATE TABLEtabl(collINT);
CREATE TABLEtab2(collINT);
CREATE TRIGGER trigl AFTER UPDATE ON tabl
REFERENCING NEW AS newl
FOR EACH ROW MODE DB2SQL
INSERT INTO tab2 VALUES(newl.coll);
INSERT INTO tabl VALUES(2) , (3);
What is the result of the following query?
SELECT count(*)FROM tab2;
A3
B2
C1
D0
26.
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming theITEMS table was created with the following SQL statement:
CREATE TABLEitems
item noINT,
item name CHAR(5),
item_qtyINT)
Which of the following SQL statements will provide the table definition that meets the
specified requirements?
A.DECLARE GLOBAL TEMPORARY TABLE tracker
AS(SELECT item_no,item_name FROM items)WITH NO DATA
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
B.DECLARE GLOBAL TEMPORARY TABLE tracker
AS(SELECT item_no,item_name FROM items)WITH NO DATA
ON COMMIT PRESERVE ROWS
C.CREATE TABLEsystmp.tracker
AS(SELECT item_num,item_name FROM items)WITH NO DATA
ON COMMIT PRESERVE ROWS
D.CREATE TABLE tracker
AS(SELECT item_num,item_name FROM items)
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
27.
Which of the following SQL statements will return the year and average salaW for all
employees hired within a given year that have a salaW greater than $30,000?
A.SELECT hyear,AVG(salary)
FROM(SELECT YEAR(datehired)AShyear,salary
FROM employee)newgrp
HAVINGsalary >30000
GROUPBY hyear
B.SELECT hyear,AVG(salary)
FROM(SELECT YEAR(datehired)AS hyear,salary
FROM employee WHEREsalary> 30000)newgrp
GROUP BY hyear
C.SELECT hyear,AVG(salary)
FROM(SELECT YEAR(datehired)AS hyear,salary
FROM employee WHEREsalary> 30000)newgrp
GROUP BYYEAR(datehired)
D.SELECT hyear,AVG(salary)
FROM(SELECT YEAR(datehired)AS hyear,salary
FROM employee HAVING salary> 30000)newgrp
GROUP BY YEAR(datehired)
28.
Which of the following DB2 tools allows a user to execute an SQL statement and view a
graphical representation of the access plan?
A.Task Center
B.Command Editor
C.Developer Workbench
D.Command Line Processor
29.
Which of the following database objects is considered executable using SQL?
A.View
B.Table
C.Routine
D.Package
30.
Which of the following queries will correctly return the manager information sorted by the
manager's last name, department and project name?
A.SELECT lastname,dept,projname,manager,startdate
FROM(SELECTname,dept,projASproj name,manager,
startdate
FROM employee,project
WHERE empno = empno)AS empproj
ORDER BY name,dept,projname
B.SELECT lastname,dept,projname,manager,startdate
FROM(SELECTnameASlastname,dept,projASprojname,
manager,startdate
FROM employee,project
WHERE empno = mgrno)AS empproj
SORT BY lastname,firstname,dept,projname
C.SELECT lastname,dept,projname,manager,startdate
FROM(SELECTnameASlastname,dept,projASprojname,
manager,startdate
FROM employee,project
WHERE empno = mgrno)AS empproj
ORDER BY lastname ASC
SORT BY dept,projname DESC
D.SELECT lastname,dept,projname,manager,startdate
FROM(SELECTnameASlastname,dept,projASprojname,
manager,startdate
FROM employee,project
WHERE empno = mgrno)AS empproj
ORDER BY lastname,dept,projname
31.
Application A holds an Update lock on a single row and application B is trying to read that
row. If both applications are using isolation level UR, which of the following will occur?
A.Application B will read the row.
B.Applications A and B will cause a deadlock situation.
C.Application B will wait until application A releases the Update lock.
D.Application A will be terminated so that application B can read the row.
32.
The following statements:
CREATETABLEt 1( co 11INTNOTNULL,PR IMARY
KEY(coil) );
CREATE TABLE t2(coilINT NOT NULL,cci2CHAR(i)NOT NULL,PRIMARY
KEY(coil,cci2),
FOREIGN KEY(coil)REFERENCEStl(coil)
ON DELETE CASCADE ON UPDATE RESTRICT);
CREATE TABLE t3(coilINT NOT NULL,cci2INT NOT NULL,PRIMARY KEY
(coil,cci2) ,
FOREIGN KEY(coil)REFERENCEStl(coil)
ON DELETE NO ACTION ON UPDATE RESTRICT);
INSERT INTO tl VALUES(1),(2);
INSERT INTO t2 VALUES(1,'a'),(1,'b'),(2,'c');
INSERT INTO t3 VALUES(1,100),(2, 200),(2,300);
How many rows will be deleted by the following DELETE statement?
DELETE FROM tl WHERE coll=1;
A4
B3
C1
D0

the manager of communications project department语法正确吗1.
A UDT is a data type which:
A. must contain unique values.
B. cannot be CAST to other data types.
C. is created using the CREATE DISTINCT command.
D. contains a value that was automatically calculated from values in other
columns.
2.
Which of the following statements allows USER1 to take away read access on the table
ORG. TAB1 from USER2?
A. REVOKE SELECT FROM user2 ON TABLE org.tab1
B. REVOKE SELECT ON TABLE org.tab1 FROM user2
C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
3.
Which of the following resources can be referenced in the LOCK statement?
A. Row
B. Table
C. Column
D. Table space
4.
Given the following table definition:
STOCK:
item VARCHAR (30)
status CHAR (1)
quantity INT
price DEC ( 7,2 )
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and
PRICE to zero, which of the following statements would be used to update the STOCK
table to indicate that all the items whose description begins with the letter "S" are out of
stock?
A. UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE
'S%'
B. UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item
LIKE 'S%'
C. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0
WHERE item LIKE 'S%'
D. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item
LIKE 'S%'
5.
Given that tables T1 and T2 contain the following rows:
Table Ti: Table T2:
C1 C2 C1 C2
-------------- ----------------
1 4 1 1
1 3 1 2
1 2 1 3
Which of the following queries will return only those rows that exist in both T1 and T27
A. SELECT * FROM tl
UNION
SELECT * FROM t2
B. SELECT * FROM tl
UNION DISTINCT
SELECT * PROM t2
C. SELECT * FROM tl
INTERSECT
SELECT * FROM t2
D. SELECT * FROM tl WHERE (cl,c2)= (SELECT cl,c2 FROM t2)
6.
A user utilizing an alias to update a subset of columns in a table must have UPDATE
privileges on which of the following DB2 objects?
A. Table
B. Columns
C. Table and Alias
D. Columns and Alias
7.
In which situation is shredding XML data recommended?
A. When the data is naturally tabular
B. When the number of nodes are volatile
C. When the data by nature has sparse attributes
D. When the data is of Iow volume and requires a complex star-schema topology
8.
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A. An application process acquires at least a share lock on the current row of
every cursor.
B. Any row that is read during a unit of work cannot be changed by other
application processes until the unit of work is complete.
C. Any row changed by another application process can be read, even if the
change has net been committed by that application process.
D. An application process that issues the same query more than once in a unit
of work will net see additional rows caused by other application processes appending new
information to the database.
9.
Which of the following DB2 products are required on an iSeries or System i server to
enable an application running on that server to retrieve data from a DB2 database on a
Linux server?
A. DB2 for i5/OS
B. DB2 Runtime Client
C. DB2 Connect Enterprise Edition
D. DB2 for i5/OS SQL Development Kit
10.
A user needs to create a trigger that will update table T2 whenever a row is added to table
T1. Assuming the user has all appropriate privileges for table T2, which privilege is
required on table T1 to create the trigger?
A. REFERENCES
B. SELECT
C. UPDATE
D. ALTER
11.
Application A is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno='000010'
UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'
Application B is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE department SET deptname = ' OLD DEPT ' WHERE deptno= ' A00 '
UPDATE employee SET salary = salary * 0.5 WHERE empno=' 000010'
Application A and application B execute their first SQL statement at the same time. When
application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?
A. The database manager will rollback the transaction in both applications.
B. The database manager will rollback the transaction in one of the two applications.
C. Application B will successfully update the EMPLOYEE and DEPARTMENT
tables; Application A will be placed in a lock wait state.
D. Application A will successfully update the EMPLOYEE and DEPARTMENT
tables; Application B will terminate when the lock timeout value is reached.
12.
If application A issues the following SQL statement, which of the following statements
about concurrency is true?
SELECT deptno, deptname, mgrno
FROM dept
WHERE admrdept = 'A00'
FOR READ ONLY WITH RS
A. Rows accessed by application A can be seen by other applications.
B. Rows accessed by application A cannot be seen by other applications.
C. Application A can see uncommitted changes made by other applications.
D. Results produced by re-execution of the statement by application A will not
be affected by other applications.
13.
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored
procedure?
A. Control Center
B. Development Center
C. Developer Workbench
D. Stored Procedure Builder
14.
Which of the following is the lowest cost DB2 product that can be legally installed on an
AIX server?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
15.
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The
TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost.
Which of the following commands is required to update the local node directory so that a
DB2 client can access this DRDA database?
A. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER
192.168.10.1
16.
Given the following query:
SELECT quantity,
CASE WHEN itemcode = '099' THEN 'SILVER'
WHEN itemcode = '788' THEN 'GOLD'
WHEN itemcode = '899' THEN 'PLATINUM'
ELSE ' ERROR'
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE
expression?
SUPPLIER
..........................................
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
A. 3,SILVER
4,GOLD
1,SILVER
1,GOLD
5,PLATINUM
3,SILVER
1,GOLD
B. 3,SILVER
4,SILVER
1,GOLD
1,PLATINUM
S,ERROR
3,GOLD
1,PLATINUM
C. 3,SILVER
4,SILVER
1,PLATINUM
1,ERROR
5,SILVER
3,GOLD
1,PLATINUM
D. 3,SILVER
4,SILVER
1,GOLD
1,GOLD
5,SILVER
3,ERROR
1,PLATINUM
17.
A "trusted" client needs to communicate with a sewer that has been configured to use
CLIENT authentication. Which of the following will be used to verify passwords?
A. User ID/password file
B. Communications layer
C. Client applications
D. Operating system
18.
Within the application MY_APP the following PREVIOUS VALUE expression references
the sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq

After which of the following events will the most recently generated value of MY_SEQ
persist so that it can be returned to the active MY_APP application?
A. After a ROLLBACK is issued
B. After the sequence is altered
C. After the sequence is dropped
D. After the current session ends
19.
Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE
S ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of
the following is true?
A. The next value will be 0 and the sequence will never use the values 101 to
105.
B. The next value will be 101 to ensure uniqueness between existing and newly
generated sequence values.
C. Previously cached values are retained by DB2, and after the restart, will be
used for values 101 to 105.
D. The next value will be 0 and DB2 will not ensure uniqueness between
existing and newly generated values.
20.
To which of the following resources can a lock be applied?
A. Row
B. Alias
C. Bitmap
D. Column
21.
Which of the following statements is used to grant user TOM and Application team
APPGRP the ability to add data to table TAB1?
A. GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B. GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D. GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
22.
Assuming PUBLIC has been granted all privileges on table T1, which of the following
statements would continue to permit any user to add rows to table T1, but not remove
them?
A. REVOKE DROP ON tl FROM PUBLIC
B. REVOKE UPDATE ON tl FROM PUBLIC
C. REVOKE DELETE ON tl FROM PUBLIC
D. REVOKE CONTROL ON tl FROM PUBLIC
23.
On which of the following database objects may the SELECT privilege be controlled?
A. Sequence
B. Schema
C. Group
D View
24.
The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO
123 Brown John T100
213 Bailey James T100
312 Carter Arlene T210
465 Chase Devon T305
546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row- to be deleted?
A. DELETE ALL FROM tab01 FOR CURRENT OF cst01
B. DELETE FROM tab01 FOR CURRENT cst01 WITH RS
C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
25.
Given the following statements:
CREATE TABLE tabl (coll INT);
CREATE TABLE tab2 (coll INT);
CREATE TRIGGER trigl AFTER UPDATE ON tabl
REFERENCING NEW AS newl
FOR EACH ROW MODE DB2SQL
INSERT INTO tab2 VALUES(newl.coll);
INSERT INTO tabl VALUES(2) , (3);
What is the result of the following query?
SELECT count(*) FROM tab2;
A 3
B 2
C 1
D 0
26.
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming theITEMS table was created with the following SQL statement:
CREATE TABLE items
item no INT,
item name CHAR(5),
item_qty INT)
Which of the following SQL statements will provide the table definition that meets the
specified requirements?
A. DECLARE GLOBAL TEMPORARY TABLE tracker
AS (SELECT item_no, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
B. DECLARE GLOBAL TEMPORARY TABLE tracker
AS (SELECT item_no, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
C. CREATE TABLE systmp.tracker
AS (SELECT item_num, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
D. CREATE TABLE tracker
AS (SELECT item_num, item_name FROM items)
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
27.
Which of the following SQL statements will return the year and average salaW for all
employees hired within a given year that have a salaW greater than $30,000?
A. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee) newgrp
HAVING salary > 30000
GROUP BY hyear
B. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee WHERE salary > 30000) newgrp
GROUP BY hyear
C. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee WHERE salary > 30000) newgrp
GROUP BY YEAR(datehired)
D. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee HAVING salary > 30000) newgrp
GROUP BY YEAR(datehired)
28.
Which of the following DB2 tools allows a user to execute an SQL statement and view a
graphical representation of the access plan?
A. Task Center
B. Command Editor
C. Developer Workbench
D. Command Line Processor
29.
Which of the following database objects is considered executable using SQL?
A. View
B. Table
C. Routine
D. Package
30.
Which of the following queries will correctly return the manager information sorted by the
manager's last name, department and project name?
A. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name, dept, proj AS proj name, manager,
startdate
FROM employee, project
WHERE empno = empno) AS empproj
ORDER BY name, dept, projname
B. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
SORT BY lastname, firstname, dept, projname
C. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname ASC
SORT BY dept, projname DESC
D. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname, dept, projname
31.
Application A holds an Update lock on a single row and application B is trying to read that
row. If both applications are using isolation level UR, which of the following will occur?
A. Application B will read the row.
B. Applications A and B will cause a deadlock situation.
C. Application B will wait until application A releases the Update lock.
D. Application A will be terminated so that application B can read the row.
32.
The following statements:
CREATE TABLE t 1 ( co 11 INT NOT NULL, PR IMARY
KEY(coil) );
CREATE TABLE t2 (coil INT NOT NULL, cci2 CHAR(i) NOT NULL, PRIMARY
KEY (coil, cci2),
FOREIGN KEY (coil) REFERENCES tl (coil)
ON DELETE CASCADE ON UPDATE RESTRICT);
CREATE TABLE t3 (coil INT NOT NULL, cci2 INT NOT NULL, PRIMARY KEY
(coil, cci2) ,
FOREIGN KEY (coil) REFERENCES tl (coil)
ON DELETE NO ACTION ON UPDATE RESTRICT);
INSERT INTO tl VALUES (1), (2);
INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c');
INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);
How many rows will be deleted by the following DELETE statement?
DELETE FROM tl WHERE coll = 1;
A 4
B 3
C 1
D 0