增值定制服务部一面招聘试题答案-数据库.docVIP

选择题每题4分，共10题，简答题每题8分，共5题，编程题每题20分，共一题，满分100分。 此套试题为数据库基础试题，考试时间为1小时，考试分数为70分为合适。 一、选择题 Oracle存储结构正确的是（B） A. tablespace--segment--osblock--block B. tablespace--segment--extent--block C. tablespace-- extent -- segment--block D. tablespace-- extent -- block -- segment 表EMPLOYEES结构为 ( EMPLOYEE_ID NUMBER(6) not null primary key, FIRST_NAME VARCHAR2(20) unique, LAST_NAME VARCHAR2(25), EMAIL VARCHAR2(25) not null, PHONE_NUMBER VARCHAR2(20), HIRE_DATE DATE, JOB_ID VARCHAR2(10), SALARY NUMBER(8,2), COMMISSION_PCT NUMBER(2,2), MANAGER_ID NUMBER(6), DEPARTMENT_ID NUMBER(4) ) 以下哪几个语句可算出表中记录，多选 （ABD） A.select count(*) from EMPLOYEES B.select count(EMPLOYEE_ID) from employees C.select count(FIRST_NAME) from employees D.select count(EMAIL) from employees E.select count(JOB_ID) from employees 表EMPLOYEES的结构为: ( EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) ) 下面哪条语句可以查出各个dept_id的最大salary值和最小salary值 并且它的最值小于5000最大值大于15000？（D） A. SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000; B. SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id; C. SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX(salary) 15000; D. SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) 5000 AND MAX(salary) 15000; E. SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) 5000 AND MAX(salary) 15000; SQL Server中在A数据库下如何访问B数据库中的C表：（D） A．在A数据库中通过建立数据库链接指向B，然后直接访问select * from c B．在B数据库中授权给A,然后直接访问select * from c C．直接访问select * from c D．直接访问select * from B..c Oracle数据库中用户A的一个存储过程用到用户B下的表Tab_B及函数Fun_B,正确的赋权语句是( B ) A.在A用户模式执行 grant select on Tab_B to A; grant execute on Fun_B to A; B.在B用户模式执行 grant select o