⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 200401_rjsjs_1.htm

📁 软件设计师考试的资料
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;background:white;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>B<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;background:white;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>C<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;background:white;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>D<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:1;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>a<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>b<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>c<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>d<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:2;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>a<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>c<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>d<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>e<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:3;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>b<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>d<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>e<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>f<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:4;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>a<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>d<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>c<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>g<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:5;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>b<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>c<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>d<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>g<o:p></o:p></span></p>
  </td>
 </tr>
 <tr style='mso-yfti-irow:6;mso-yfti-lastrow:yes;height:12.0pt'>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>c<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>b<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>e<o:p></o:p></span></p>
  </td>
  <td width="25%" style='width:25.0%;border:inset black 1.0pt;mso-border-alt:
  inset black .75pt;padding:0cm 0cm 0cm 0cm;height:12.0pt'>
  <p class=MsoNormal align=center style='text-align:center;mso-pagination:widow-orphan'><span
  lang=EN-US style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-bidi-font-family:
  宋体;color:black;mso-font-kerning:0pt'>g<o:p></o:p></span></p>
  </td>
 </tr>
</table>

</div>

<p class=MsoNormal align=left style='margin-top:3.0pt;mso-margin-bottom-alt:
auto;text-align:left;mso-pagination:widow-orphan'><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:
0pt'>　　<span lang=EN-US>(17)A</span>．<span lang=EN-US>ABC</span>　　<span
lang=EN-US>B</span>．<span lang=EN-US>ABD</span>　　<span class=GramE>　</span><span
lang=EN-US>C</span>．<span lang=EN-US>ACD</span><span class=GramE>　　　　　</span><span
lang=EN-US>D</span>．<span lang=EN-US>ABCD<br>
</span>　　<span lang=EN-US>(18)A</span>．<span lang=EN-US>ABC</span>　　<span
lang=EN-US>B</span>．<span lang=EN-US>AB</span>、<span lang=EN-US>AD</span>　<span
lang=EN-US> C</span>．<span lang=EN-US>AC</span>、<span lang=EN-US>AD</span>和<span
lang=EN-US>CD</span>　<span lang=EN-US> D</span>．<span lang=EN-US>AB</span>、<span
lang=EN-US>AD</span>、<span lang=EN-US>BD</span>和<span lang=EN-US>CD <o:p></o:p></span></span></p>

<p class=MsoNormal align=left style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;text-align:left;mso-pagination:widow-orphan'><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-bidi-font-family:宋体;color:black;mso-font-kerning:
0pt'>　　<span lang=EN-US>●</span><span class=GramE>设供应</span>商供应零件的关系模式为<span
lang=EN-US>SP(<span class=SpellE>Sno</span></span>，<span class=SpellE><span
lang=EN-US>Pno</span></span>，<span lang=EN-US>Qty)</span>，其中<span class=SpellE><span
lang=EN-US>Sno</span></span>表示供应商号，<span class=SpellE><span lang=EN-US>Pno</span></span>表示零件号，<span
lang=EN-US>Qty</span>表示零件数量。查询至少包含了供应商<span lang=EN-US>“168”</span>所供应的全部零件的供应商号的<span
lang=EN-US>SQL</span>语句如下：<span lang=EN-US><br>
</span>　　<span lang=EN-US>SELECT <span class=SpellE>Sno</span><br>
</span>　　<span class=GramE>　</span><span lang=EN-US>FROM SP SPX<br>
</span>　　<span class=GramE>　</span><span lang=EN-US>WHERE __(19)__<br>
</span>　　<span class=GramE>　</span><span lang=EN-US>(SELECT *<br>
</span><span class=GramE>　　　　</span><span lang=EN-US>FROM SP SPY<br>
</span><span class=GramE>　　　　</span><span lang=EN-US>WHERE __(20)__ AND
NOTEXISTS<br>
</span>　　<span class=GramE>　　</span><span lang=EN-US>(SELECT *<br>
</span><span class=GramE>　　　　　</span><span lang=EN-US>FROM SP SPZ<br>
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -