单选题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

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? （）

It’s hard to get more white-fenced than Naperville. In the western Chicago suburb, crime is an annoyance, not a problem. The streets are clean and the schools are some of the most impressive in the state, producing some of the brightest students who attend the nation’s best colleges. (1)____________.　　The rankings will be phased out over the next year, with 2007’s upperclassmen deciding whether to include such a rank in their official transcripts. By no longer ranking students, the Naperville School District 203 is squarely in line with a trend that is fast sweeping the nation, as more and more private and public schools are dropping the practice. The goal, proponents say, is to cut down on the hyper-competition and lessen the stress at such a critical learning point and maturation curve in kids’ lives.　　“It’s a high bar we set, and it should be,” said Naperville Superintendent Alan Leis. “But there needs to be more than wrestling over who’s better than who.” (2)______________.　　Some 80% or more public schools still report rankings to inquiring universities and colleges, but a growing number of high schools in the Chicago area and around the country—in mostly affluent districts from California to Miami to New Jersey—have already adopted the practice. (3)_______________. Even in Naperville, a valedictorian is still expected to address the class, but that honor is not chosen until the last weeks of a school year and is not forwarded on to schools in official transcripts.　　(4)_______________. According to Dr. Scott Hunter, a clinical psychologist and school consultant at the University of Chicago Hospitals who specializes in pediatric neuropsychology. “The reality is that we have made in the last 10 years more of rank than it deserves because some kids don’t really shine until they enter into adulthood, and they risk being ignored by the very places and people where they could greatly succeed,” adds Hunter, “ This is an artificial number in terms of where a person really falls.”　　(5)___________________.　　“It makes it a little more opaque for us on the admissions side, but we fully understand it,” said Jim Miller, director of admissions at Brown University. “It’s conceivable a student could get a B in gym and get knocked down 40 places in rank. So we’re getting more used to it, and probably half our applicants now come from schools that don’t have rank. “　　[A] Class rankings, a tradition at many schools, have long helped universities and colleges—especially the Harvards and Princetons of the world—weed out the weak students from the strong, the ones with not only promise but the ambition to excel and meet the difficulties of higher education.　　[B] But it’s vicious at the top—so much so that Naperville’s school officials recently voted to stop using a class ranking system.　　[C] A much higher number of private schools do not share their rankings, including some independent schools in Chicago that, for example, have societies that recognize the top 10% of a class but choose to allow the students themselves dictate who speaks at graduation.　　[D] Competitions among students for the title of honored graduates are very tight and are on the rise in a great number of private schools.　　[E] Schools just have to make certain, through student profiles and other means, the strength of a schedule and student performance relative to other students.　　[F] Not surprisingly, there is still lots of disagreement about the new policy; some parents are worried that it hurts high-achieving students’ chances of getting over the bar, while forcing colleges and universities to rely on perhaps less reliable or easier measures or on standardized tests like the ACT or SAT.　　[G] Students and their parents increasingly fight over who gets to be number one, and the damage that can be done—both academically and psychologically—to those who lose out far wins the benefits of the glory attached to such titles.(此文选自Time 2006年刊)

From the first paragraph we can infer that in the US schools ______.

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?（）

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?（）

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?（）

Reading a large number of books ______ make us wiser. The more we read, the more we know.

If the temperature drops low enough, oil will not flow, （） just tell us the temperature.

Do you have an account with us? Yes,（）

The following are the details of your database：   Instance name：test   Host name：tech1.us.oracle.com   IP address：145.33.230.186  Enterprise Manager Console HTTP Port number：5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）

The US Department of Labor statistics shows that ______.

Which of the following sentences is CORRECT?

Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）