其他
Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values ‘C‘, ‘H‘ and ‘N‘, and permits inserts only when a cor
题目
Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values ‘C‘, ‘H‘ and ‘N‘, and permits inserts only when a corresponding value for the employee‘s department exists in the DEPARTMENT table.Which of the following CREATE statements will successfully create this table?（）
A.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN (‘C‘,‘H‘,‘N‘)), );
B.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES (‘C‘,‘H‘,‘N‘) );
C.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN (‘C‘,‘H‘,‘N‘)), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
D.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN (‘C‘,‘H‘,‘N‘)) );
相似问题和答案
第1题：
包容类Contain和内嵌类Embed定义如下： #include ＜iostream.h＞ class Contain { private: int x; protected: int z; public: class Embed { private: int y; public: Embed(){y=100;} int Embed_Fun(); }MyEmbed; int Contain_Fun(); }; 对上面的定义，正确的描述是( )。
A．定义类Embed对象的语句是:Contain::Embed embed；
B．类Contain的成员函数Contain_Fun()中可以用MyEmbed.y的方式访问类Embed的私有成员y
C．类Embed的成员函数Embed_Fun()中可以直接访问类Contain和的私有成员x
D．类Embed的成员函数Embed_Fun()中可以直接访问类Contain的保护成员z
第2题：
包容类Contain和内嵌类Embed定义如下： #include＜iostream.h＞ class Contain { private： int X； protected： int z； public： class Embed { private： int y； public： Embed(){y=100；} int Embed_Fun()； }MyEmbed； int Contain_Fun(
A．定义类Embed对象的语句是：Contain? Embed embed；
B．类Contain的成员函数Contain_Fun()中可以用MyEmbe D.y的方式访问类Embed的私有成员y
C．类Embed的成员函数Embed_Fun()中可以直接访问Contain的私有成员x
D．类Embed的成员函数Embed_Fun()中可以直接访问Contain的保护成员Z
第3题：
(c) mandatory continuing professional development (CPD) requirements. (5 marks)
(c) Continuing Professional Development (CPD)
CPD is defined5 as ‘the continuous maintenance, development and enhancement of the professional and personal knowledge
and skills which members of ACCA require throughout their working lives’.
All professional accountants need to maintain their competence and develop new skills to be effective in their current and
future employment. CPD helps keep accountants in practice employable and maintains their reputation with employers,
clients and the public. It also helps maintain the accounting profession’s reputation for producing and supporting high calibre
individuals. Therefore, CPD is something which professional accountants should take personal responsibility for, and be doing
as part of their everyday work.
Mandatory CPD for active members of IFAC member bodies (such as ACCA) was introduced with effect from 1 January 2005
onwards. ACCA has introduced CPD as a requirement for all active members, subject to the phasing-in dates (and waivers).
Tutorial note: IFAC issued International Education Standard (IES) 7, which requires the introduction of CPD for all active
members of IFAC member bodies.
ACCA practising certificate and insolvency licence holders are still required to participate in technical CPD training. All other
members will also be asked to state on their annual CPD return that they maintain competence in professional ethics.
The scheme is being introduced in phases:
■ phase 1 (2005) – members admitted since 1 January 2001, and all practising certificate and insolvency licence
holders;
■ phase 2 (2006) – members admitted between 1 January 1995 and 31 December 2000;
■ phase 3 (2007) – all remaining members.
Tutorial note: However, ACCA encouraged all members to adopt the scheme from 1 January 2005.
Affiliates join the CPD scheme on 1 January following their date of admittance to membership.
There are two routes to participation in ACCA’s CPD scheme:
(1) the unit scheme route (40 units approximate to 40 hours required each year); and
(2) the approved CPD employer route (i.e. where employers are recognised as effectively providing ACCA members with
CPD).
Tutorial note: Alternatively, if an ACCA member is also a member of another IFAC accounting body and that CPD scheme
is compliant with IFAC’s CPD IES 7, they may choose to follow that body’ s route.
第4题：
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）
A．Create_Table，Alter_Table，Drop_Table
B．Create_View，Alter_View，Drop_View
C．Create_Procedure，Alter_Procedure，Drop_Procedure
D．Rollback
第5题：
A.contain，inoculate，quarantine，andtreat
B.inoculate，contain，quarantine，andtreat
C.quarantine，contain，inoculate，andtreat
D.preparation，identification，traceback，andpostmortem
E.preparation，classification，reaction，andtreat
F.identification，inoculation，postmortem，andreaction
第6题：
Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）
A.byusingtheDBMS_REPAIRpackage
B.byusingtheDBVERIFYutility
C.byusingBlockMediaRecovery
D.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand
第7题：
类 Contain 的定义如下： class Contain { private: int x; protected: int z; public: class Embed { private: int y; public: Embed ( ) { y=100; } int Embed_Fun(); }MyEmbed; int Contain_Fun(); }； 下列对上面定义的描述中，正确的是( )。
A．定义类Embed对象的语句是：Contain：：Embed Myobject；
B．类Contain的成员函数Contain_Fun()中可以访问对象MyEmbed的私有成员y
C．类Embed的成员函数Embed_Fun()中可以直接访问类Contain的所有成员
D．类Embed的成员函数Embed_Fun()中只能直接访问类Contain的公有成员
解析：对象MyEmbed是类Contain的成员对象，通过对象MyEmbed不能访问其私有数据成员y，所以选项B是错误的。类Embed是类Contain的嵌套类，类Embed的成员函数不能直接访问类Contain的所有成员，所以选项C和D都是错误的。
第8题：
A. followed,followed
B. followed,following
C. following,followed
D. following,following
第9题：
B.control instructions
C. I/O operation
D.datA.table
大多数操作系统都有一套标准的（71）处理所有的输入和输出指令。
A. 电子表格 B. 控制指令
C. I/O操作 D. 数据表
第10题：
如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？
A．create table
B．create any table
C．create all table
D．create * table