单选

某企业的数据库系统中有如下所示的员工关系和仓库关系，每个仓库可有多名员工，但只有一名负责人。  

员工关系(employee)：

仓库关系(warehouse)：

 则创建仓库表结构的SQL语句为(58)。

  • A．CREATE TABLE (employee ID CHAR(2)NOTNULL UNIQUE， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3))；
  • B．CREATE warehouse(warehouse ID CHAR(2)PRIMARY KEY， name CHAR(30)， address CHAR(40)， principal ID CHAR(3))；
  • C．CREATE TABLE warehouse(warehouse ID CHAR(2)PRIMARY KEY， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3)， FOREIGN KEY(principal ID)REFERENCES employee(employee ID))；
  • D．CREATE TABIE warehouse(warehouse ID CHAR(2)， name CHAR(30)NOT NULL， address CHAR(40)， principal ID CHAR(3)， PRIMARY REY(warehouse ID)， FOREIGN KEY(employee ID)REFERENCES employee(employee ID))；
试题出自试卷《软件水平考试（初级）程序员上午（基础知识）模拟试卷37》
参考答案
您可能感兴趣的试题

Firewall is a(74) mechanism used by organizations to protect their LANs from the Internet.
  • A．reliable
  • B．stable
  • C．peaceful
  • D．security
查看试题详情

In(75) programming, the user determines the sepuence of instions to be executed, not programmer.
  • A．top-down
  • B．structure
  • C．data-driven
  • D．event-driven
查看试题详情

C++ fully supports(73)programming.
  • A．visual
  • B．object-oriented
  • C．logic
  • D．natural language
查看试题详情

(72) is the conscious effort to make all jobs similar, routine, and interchangeable.
  • A．WWW
  • B．Informatization
  • C．Computerization
  • D．Standardization
查看试题详情

(71 ) is the sending and receiving of the messages by computer. It is a fast, low-cost way of communicating worldwide.
  • A．LAN
  • B．Post office
  • C．E-Mail
  • D．Interface
查看试题详情

In C language,(69) are used to create variables and are grouped at the top of a program block.
  • A．declarations
  • B．dimensions
  • C．comments
  • D．descriptions
查看试题详情

An(70) statement can perform. a calculation and store the result in a variable so that it can be used later.
  • A．executable
  • B．input
  • C．output
  • D．assignment
查看试题详情

(68) are those programs that help find the information you are trying to locate on the WWW．
  • A．Windows
  • B．SearchEngines
  • C．WebSites
  • D．WebPages
查看试题详情

(66) is a device that converts images to digital format．
  • A．Copier
  • B．Printer
  • C．Scanner
  • D．Display
查看试题详情

In C language, a(67) is a series of characters enclosed in double quotes．
  • A．matrix
  • B．string
  • C．program
  • D．stream
查看试题详情
您可能感兴趣的试卷

热门试卷

高级经济师考试试题：经济法案例试题精

所属类型：模拟考试2021-03-22

高级经济师考试试题及答案：单选练习题

所属类型：模拟考试2021-03-22

高级经济师考试试题及答案(1)

所属类型：模拟考试2021-03-22

高级经济师考试试题及答案：多选练习题

所属类型：模拟考试2021-03-22

高级经济师冲刺题及答案(1)

所属类型：模拟考试2021-03-22

高级经济师考试试题精选练习（2）

所属类型：模拟考试2021-03-22

高级经济师考试模拟试题及答案

所属类型：模拟考试2021-03-22
¥

订单号：

遇到问题请联系在线客服

订单号：

遇到问题请联系在线客服