The report from the US Department of Education shows that ______.A. the number of the expulsions is not largeB. the number of the expulsion is wrongC. there are soldiers hiding among the studentsD. guns are out of control in US schools
题目
The report from the US Department of Education shows that ______.
A. the number of the expulsions is not large
B. the number of the expulsion is wrong
C. there are soldiers hiding among the students
D. guns are out of control in US schools
相似考题
参考答案和解析
47．答案为D。根据第一、二段内容作出该项选择。
更多“The report from the US Department of Education shows that ______. A. the number ”相关问题
-
第1题：
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （）
A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
参考答案：A
-
第2题：
Examine the structure if the EMPLOYEES table:Column name Data Type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）
A. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
C. CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
D. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
参考答案：B
-
第3题：
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERMGR_ID NUMBER References EMPLOYEE_ID COLUMNDEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS tableDEPARTMENTSColumn name Data type RemarksDEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30)MGR_ID NUMBER References MGR_ID column of the EMPLOYEES tableEvaluate this SQL statement:SELECT employee_id, e.department_id, department_name, salaryFROM employees e, departments dWHERE e. department_id = d.department_id;Which SQL statement is equivalent to the above SQL statement? （）
A. SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
B. SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
C. SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
D. SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
参考答案：C
-
第4题：
Passage Four
More than 6,000 children were expelled (开除) from US school last year for bringing guns and bombs to school, the US Department of Education said on May 8.
The department gave a report to the expulsions (开除) as saying handguns accounted for 58 percent of the 6,093 expulsions in 1996 and 1997, against 7 percent for rifles (步枪) or shotguns and 35 percent for other types of firearms.
"The report is a clear sign that out nation's public schools are cracking down (严惩) on students who bring guns to school," Education Secretary Richard Riley said in a statement. "We need to be tough-minded about keeping guns out of our schools and do everything to keep our children safe."
In March 1997, an 11 years old boy and 13 years old boy using handguns and rifles shot dead four children and a teacher at a school in Jonesboro, Arkansas. In October, two were killed and seven wounded in a shooting at a Mississippi school. Two months later, a 14 years old boy killed three high school students and wounded five in Dasucah, Kentucky.
Most of the expulsions, 56 percent, were from high school, which have students from about age 13.34 percent were from junior high schools and 9 percent were from elementary schools, the report said.
46. From the first paragraph we can infer that in the US schools ______.
A. students enjoy shooting
B. students are eager to be solider
C. safety is a problem
D. students can make guns
正确答案：C46．答案为C。根据第一段，for bringing guns and bombs to school作出该项选择。
-
第5题：
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view? （）
- A、SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
- B、SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
- C、SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
- D、SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
正确答案:A -
第6题：
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task? （）
- A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
- B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
- C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
- D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
- E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
- F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
正确答案:E -
第7题：
单选题The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）AFixed
BExpand
CContract
DVariable
正确答案： B解析： 暂无解析 -
第8题：
单选题You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）AALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
BMODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
CALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
DMODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
ECREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
FYou must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
正确答案： F解析： 暂无解析 -
第9题：
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （）ASELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
BSELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
CSELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
DSELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
正确答案： B解析： 暂无解析 -
第10题：
单选题The US Department of Labor statistics shows that ______.Amany college graduates find it increasingly hard to get suitable jobs
Bthere is an oversupply of workers and this oversupply is increasing recently
Cteachers, engineers, physicists and other specialists are extremely needed
Dcolleges and graduate schools have become aware of the severe situation in the labor market
正确答案： A解析：
根据首段第一句The US Department of Labor statistics (统计结果) indicates that there is an oversupply of college-trained workers and that this oversupply is increasing.可知，美国劳动部的统计结果表明大学毕业生供大于求，而且这种供大于求的状况一直在加剧。因此答案为A)“许多大学生发现越来越难找到合适的工作”。 -
第11题：
单选题1The general manager sat there, ______ to the report from each department.Ato listen
Blisten
Cbeing listened
Dlistening
正确答案： D解析：
本题考查分词作状语。句子主语the general manager与后面的动词listen之间是主谓关系，这里应该使用动词的现在分词形式。根据句意，正确答案为D。句意：总经理坐在那里，听取各部门报告。 -
第12题：
单选题The report from the US Department of Education shows that ______.Athe number of the expulsions is not large
Bthe number of the expulsions is wrong
Cthere are soldiers hiding among the students
Dguns are out of control in US schools
正确答案： D解析：
推理判断题。由关键词The report定位第二段，从教育部报告所列出的持枪者数字，我们可以看出美国校园内枪支的管理是混乱的，故D项正确。原文纸上给出了爆炸案件的数字，并没有对此作出评价，故A项和B项错误，C项原文没有提及。 -
第13题：
Consider the following:Which statement best describes the meaning of the value for the key_len column?()
A.It shows the total size of the index row
B.It shows how many columns in the index are examined
C.It shows the number of characters indexed in the key
D.It shows how many bytes will be used from each index row
参考答案：D
-
第14题：
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME.The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary keyDEPARTMENT_ID column of the DEPARTMENTS table.You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables.How can you accomplish this task? （）
A. ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
B. MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
C. ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
D. MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
E. CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
F. You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
参考答案：E
-
第15题：
Examine the data from the EMP table:The COMMISSION column shows the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to perform in a single step?（）
A. Deleting the records of employees who do not earn commission.
B. Increasing the commission of employee 3 by the average commission earned in department 20.
C. Finding the number of employees who do NOT earn commission and are working for department 20.
D. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.
E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
参考答案：B, D, F
-
第16题：
根据下列内容，回答203-206题。
Chinese and US students will have greater access to educational exchange programmes as thetwo countries have agreed to expand and promote educational co-operation.
Further co-operation in higher education, language learning and teaching, and primary andsecondary education were highlighted in a memorandum of understanding signed by educationministers from both countries on Thursday.
Margaret Spellings, US secretary of education, described the memorandum as historic at abreakfast panel discussion hosted by the China Chamber of Commerce on Friday in Beijing, thelast stop of her East Asia tour following Tokyo and Seoul.
She said the United States is"deadly serious" about promoting educational co-operation andexchange with China. Her delegation, consisting of 12 US university presidents, is the first everhigh-profile delegation of us college and university presidents to China.
"It's even more compelling that on this first ever delegation, China is one of the firsts of thefirst, as our trip starts from East Asia," Spellings said.
Education co-operation and exchanges between the United States and China have beendeveloping rapidly in recent years. More than 63,000 Chinese students are currently studying inthe United States, while there has also been a rise in the number of US students studying in China.
A recent report from the New York--based Institute of International Education, one of theworld's largest international education organizations shows that 6,389 US students came to Chinain the 2005-2006 academic year, up 35 percent year-on-year. The report also lists China as theonly Asian country among the top 10 popular destinations for US students to study abroad.
Spellings said she was pleased with the numbers but not satisfied."US students do want tocome to study in China, and we need to help them do that as well as to help Chinese students tocome to our country."
On Friday, Premier Wen Jiabao met with Spellings and her delegation in Beijing.
The passage suggests that__________.A.following Beijing, Margaret Spellings and her delegation will visit Tokyo and Seoul in EastAsia.
B.the US will further streamline the visa application process, making it easier for Chinesestudents.
C.the US often send delegations of college and university presidents to China in recent years.
D.China as well as Japan are among the most popular countries that the US students want tostudy in.答案：B解析：Spellings是先拜访的日本和首尔，接下来才是北京，A不正确；文章中指出，最引人注目的是，这是第一次代表团，中国是第一次，而C选项则说的是近几年来，美国经常派一些大学代表团来中国，因此错误；文章只说了中国是亚洲唯一美国学生希望来求学的国家，D也不正确。故选B。 -
第17题：
Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）
- A、Only the row with department ID 40 is deleted in the DEPARTMENTS table.
- B、The statement fails because there are child records in the EMPLOYEES table with department ID 40.
- C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
- D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
- E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
- F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
正确答案:B -
第18题：
单选题Examine the description of the EMPLOYEES table: 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) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）ASELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
BSELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
CSELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
DSELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
ESELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
正确答案： B解析： 暂无解析 -
第19题：
单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）ACREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
BCREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
CCREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
DCREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
正确答案： C解析： 暂无解析 -
第20题：
单选题Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）ASELECT * FROM emp_dept_vu;
BSELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
CSELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
DSELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
ENone of the statements produce an error; all are valid.
正确答案： C解析： 暂无解析 -
第21题：
单选题The general manager sat there, _____ to the report from each department.Ato listen
Blisten
Cbeing listened
Dlistening
正确答案： C解析：
本题考查分词作状语。句意：总经理坐在那里，听取各部门报告。主语the general manager与动词listen之间是主谓关系，这里应该使用动词的现在分词形式。根据句意，正确答案为D。 -
第22题：
单选题Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）ASELECT * FROM emp_dept_vu;
BSELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
CSELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
DSELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
ENone of the statements produce an error; all are valid.
正确答案： A解析： 暂无解析 -
第23题：
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?（）ASELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
BSELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
CSELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
DSELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
正确答案： A解析： 暂无解析