当前位置:1z0-043题库

问题:

[单选]

Exhibit: Using Database Control, you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5:00 p.m. every Friday.When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk. What could have been the reason for this?()

A .  The tablespace that contains the TRANS table is online.
B .  The tablespace that contains the TRANS table is permanent.
C .  The tablespace that contains the TRANS table is locally managed.
D .  The segment space management of the tablespace that contains the TRANS table is manual in nature.

Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? () SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);。 SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);。 SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);。 SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);。 SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);。 SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))。 在控制的条件下系统地操纵某种变量的变化,来研究此种变量的变化对其他变量的影响,这种心理学研究方法是()。 观察法。 访谈法。 实验法。 统计法。 简述1942年前后解放区文学的变化。 简述香港特别行政区律政司司长的身份。 H2爆炸极限为4.0~7.4%,CH4爆炸极限为5~15%两者相比()的危险性大 H2。 CH4

Exhibit: Using Database Control, you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5:00 p.m. every Friday.When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk. What could have been the reason for this?()

参考答案:

  参考解析

本题暂无解析

在线 客服