【单选题】对于示例表EMP,字段EMPNO为雇员编号,字段MGR为雇员直属经理的编号,KING是最高领导,他的直属经理编号为空,以下哪个语句能查询出JONES及其所有下属
A.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY PRIOR EMPNO=MGR START WITH ENAME='JONES';
B.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY PRIOR MGR=EMPNO START WITH ENAME='JONES';
C.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY EMPNO=PRIOR MGR START WITH ENAME='JONES';
D.
SELECT LEVEL,ENAME,DEPTNO,EMPNO,MGR FROM EMP CONNECT BY MGR=EMPNO START WITH ENAME='JONES';
【多选题】Exhibit: View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is not deferred. Which two statements are tru...
A.
No index would be created or used in this case.
B.
A unique index on the empno column would be created.
C.
A CHECK constraint would be enforced on the empno column.
D.
A NOT NULL constraint would be enforced on the empno column.
E.
A bitmap unique index would be created on the empno column.
【单选题】按与供应的( )分类,可以分为短期目标型供应商、长期目标型供应商、渗透型供应商、联盟型供应商、纵向集成型供应商。
【单选题】遗传组成为N(rr),细胞核为不育基因,细胞质基因正常可育,为( )。
【判断题】供应商关系类型分为短期目标型、长期目标型、参透型、联盟型、纵向集成型等几种。
【简答题】企业与供应商之间的关系大致可分为()。 A短期目标型、长期目标型、联盟型、渗透型和纵向集成型。 B伙伴型、重点型、优先型和商业型; C供应商按80/20规则分类; D专家级型、行业领袖型、低产小规模型和量小品种多型。
【单选题】按与供应商的交易关系稳定性角度分类,供应商可分为短期目标型、长期目标型、纵向集成型、联盟型和()
【判断题】按与供应商的采购业务关系重要程度分类,可分为短期目标型、长期目标型、渗透型、联盟型、纵向集成型。