单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statemen

第1题：

class Parent {     String one， two；  public Parent（String a， String b）{     one = a；     two = b；    }  public void print（）{ System.out.println（one）； }    }  public class Child extends Parent {     public Child（String a， String b）{     super（a，b）；     }  public void print（）{  System.out.println（one + " to " + two）；     }  public static void main（String arg[]）{     Parent p = new Parent（"south"， "north"）；     Parent t = new Child（"east"， "west"）；     p.print（）；     t.print（）；     }     }  Which of the following is correct？（）

• A、 Cause error during compilation. 
• B、 south         east 
• C、 south to north     east to west    
• D、 south to north      east    
• E、 south     east to west

第2题：

Your company has a single Active Directory forest that has a domain in North America named na.contoso.com and a domain in South America named sa.contoso.com. The client computers run Windows Vista.You need to configure the client computers in the North America office to improve the name resolution response time for resources in the South America office. What should you do？（）

• A、Configure a new Group Policy object （GPO） that disables the Local-Link Multicast Name Resolution feature. Apply the policy to all the client computers in the North America office.
• B、Configure a new Group Policy object （GPO） that enables the Local-Link Multicast Name Resolution feature. Apply the policy to all the client computers in the North America office.
• C、Configure a new Group Policy object （GPO） that configures the DNS Suffix Search List option to sa.contoso.com， na.contoso.com. Apply the policy to all the client computers in the North America office.
• D、Configure the priority value for the Service Location （SRV） records on each of the North America domain controllers to 5.

第3题：

There are three major routes of container transportation： Far East to North America， Far East to Europe and Mediterranean， North America to Europe and Mediterranean.

第4题：

Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）

• A、INSERT INTO tab1 SELECT cx, cy FROM tab2
• B、INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
• C、INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
• D、INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

第5题：

View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；   You want to back out transaction T2.  Which option would you use？（）

• A、 It is possible，but transaction T3 also backs out.
• B、 It is possible with the NOCASCADE_FORCE option.
• C、 It is possible with the NONCONFLICT_ONLY option.
• D、 It is not possible because it has conflicts with transaction T3.

第6题：

Your company has a single Active Directory forest that has a domain in North America named na.contoso.com and a domain in South America named sa.contoso.com. The client computers run Windows 7. You need to configure the client computers in the North America office to improve the name resolution response time for resources in the South America office.What should you do？（）

• A、Configure a new Group Policy object (GPO) that disables the Local-Link Multicast Name Resolution feature. Apply the policy to all the client computers in the North America office.
• B、Configure a new Group Policy object (GPO) that enables the Local-Link Multicast Name Resolution feature. Apply the policy to all the client computers in the North America office.
• C、Configure a new Group Policy object (GPO) that configures the DNS Suffix Search List option to sa.contoso.com, na.contoso.com. Apply the policy to all the client computers in the North America office.
• D、Configure the priority value for the Service Location (SRV) records on each of the North America domain controllers to 5.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  In what sequence would you use this process to perform the recovery？（）

• A、7， 2， 3， 1， 4， 6， 5
• B、7， 1， 3， 2， 6， 5， 4
• C、2， 1， 7， 6， 3， 5， 4
• D、2， 7， 3， 5， 1， 6， 4

第14题：

New Zealand is situated about 1, 500 km （）

• A、north-west of Australia
• B、south-east of Australia
• C、north-east of Australia
• D、south-west of Australia

第15题：

Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）

• A、2
• B、7
• C、9
• D、14

第16题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）

• A、SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
• B、SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
• C、SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
• D、SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );

第17题：

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary 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, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）

• A、SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary > 10000;
• B、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 JOIN ON (e.department_id = d.department id) AND (d.location_id =1.location_id) AND salary > 10000;
• C、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary > 10000;
• D、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary > 10000;
• E、SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：