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

题目

单选题

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

参考答案和解析

正确答案： B

解析：暂无解析

更多“单选题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题

New Zealand is situated about 1, 500 km （）A、north-west of AustraliaB、south-east of AustraliaC、north-east of AustraliaD、south-west of Australia

点击查看答案
第2题

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.

点击查看答案
第3题

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、2B、7C、9D、14

点击查看答案
第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 tab2B、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题

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 );

点击查看答案
第6题

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.

点击查看答案
第7题

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;

点击查看答案

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

题目

参考答案和解析

更多“单选题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题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容