网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 ” 相关考题
考题
Passage ThreeMore 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% of the 6,093 expulsions in 1996—1997, against 7% for rifles (步枪) or shotguns and 35% for other types of firearms."The report is a clear sign that our nation's public schools are cracking down (严惩) on students who bring guns to school," Education Secretary Richard Riley said in a statement.In March 1997, an 11-year old boy and a 13-year old boy using handguns and rifles shot dead four children and a teacher at a school in Arkansas. In October, two were killed and seven wounded in a shooting at a Mississippi school. Two months later, a 14-year old boy killed three high school students and wounded five in Kentucky.Most of the expulsions, 56%, were from high school, 34% were from junior high schools and 9% were from elementary schools, the report said.41. From the first paragraph we can infer that in the US schools______.A. students enjoy shootingB. safety is a problemC. students are eager to be solider.D. students can make guns.
考题
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 the US schools.
考题
The chart shows that from 2005 to 2008，．A．the percentage of the Spanish families with a computer rose 35 pointsB．the percentage of the White families with a computer remained unchangedC．the number of the Black families with a computer was on the decreaseD．the number of the Asian families with a computer showed the sharpest increase
考题
Examine the structure of the EMP_DEPT_VU view:Column Name Type RemarksEMPLOYEE_ID NUMBER From the EMPLOYEES tableEMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES tableSALARY NUMBER From the EMPLOYEES tableDEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）A. SELECT * FROM emp_dept_vu;B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E. None of the statements produce an error; all are valid.
考题
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);
考题
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 rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row
考题
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;
考题
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.
考题
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);
考题
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.
考题
Passage FourMore 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 shootingB. students are eager to be soliderC. safety is a problemD. students can make guns
考题
根据下列内容，回答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.
考题
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);
考题
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.
考题
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.
考题
单选题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?（）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;
考题
单选题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?（）A
Fixed B
Expand C
Contract D
Variable
考题
单选题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?（）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;
考题
单选题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.
考题
单选题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?（）A
SELECT * FROM emp_dept_vu;B
SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C
SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D
SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E
None of the statements produce an error; all are valid.
考题
单选题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? （）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);
考题
单选题The general manager sat there, _____ to the report from each department.A
to listenB
listenC
being listenedD
listening
考题
单选题The US Department of Labor statistics shows that ______.A
many college graduates find it increasingly hard to get suitable jobsB
there is an oversupply of workers and this oversupply is increasing recentlyC
teachers, engineers, physicists and other specialists are extremely neededD
colleges and graduate schools have become aware of the severe situation in the labor market
考题
单选题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?（）A
SELECT * FROM emp_dept_vu;B
SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C
SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D
SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E
None of the statements produce an error; all are valid.
考题
单选题1The general manager sat there, ______ to the report from each department.A
to listenB
listenC
being listenedD
listening
考题
单选题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?（）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);
考题
单选题The report from the US Department of Education shows that ______.A
the number of the expulsions is not largeB
the number of the expulsions is wrongC
there are soldiers hiding among the studentsD
guns are out of control in US schools
热门标签
最新试卷
