皮皮学，免费搜题
登录
搜题
【简答题】
十进制的246=十六进制的?
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】对于示例表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.
【单选题】已知dept表有部门编号字段deptno、部门名称字段dname,员工表emp具有员工编号字段empno、员工姓名字段ename、电话字段phone和所属部门编号字段deptno,该字段参考dept表的deptno字段,要使用SQL语句查询 “研发部”部门所有员工的编号和姓名信息,下面选项中正确的是( )。
A.
SELECT empno,ename FROM emp WHERE empno=(SELECT empno FROM dept WHERE dname="研发部")
B.
SELECT empno,ename FROM emp WHERE deptno=(SELECT deptno FROM dept WHERE dname='研发部')
C.
SELECT empno,ename FROM emp WHERE deptno=(SELECT * FROM dept WHERE dname='研发部')
D.
SELECT empno,ename FROM dept WHERE deptno=(SELECT deptno FROM emp WHERE dname="研发部")
【单选题】显示在30号部门工作的雇员的名字和他上司的名字( )。 EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
A.
Select e.ename,s.ename from emp e,emp s where e.deptno =30 and e.empno=s.mgr
B.
Select ename,ename from emp join emp on deptno =30 and empno=mgr
C.
Select e.ename,s.ename from emp e join emp s on deptno =30 and e.empno=s.mgr
D.
Select e.ename,s.ename from emp e,emp s where e.deptno =30 and s.empno=e.mgr
相关题目：