TEAMS表包含以下各列： TEAM_ID NUMBER（4） Primary Key TEAM_NAMEVARCHAR2（20） MGR_ID NUMBER（9） TEAMS表当前是空表。您需要允许用户在经理标识值中包含文本字符。应使用以下哪条语句来执行此任务（）A、ALTER teams MODIFY（mgr_id VARCHAR2（15））B、ALTERTABLE teams MODIFY（mgr_id VARCHAR2（15））C、ALTERTABLE teams REPLACE（mgr_id V

题目

TEAMS表包含以下各列： TEAM_ID NUMBER（4） Primary Key TEAM_NAMEVARCHAR2（20） MGR_ID NUMBER（9） TEAMS表当前是空表。您需要允许用户在经理标识值中包含文本字符。应使用以下哪条语句来执行此任务（）

A、ALTER teams MODIFY（mgr_id VARCHAR2（15））
B、ALTERTABLE teams MODIFY（mgr_id VARCHAR2（15））
C、ALTERTABLE teams REPLACE（mgr_id VARCHAR2（15））
D、ALTER teams TABLEMODIFYCOLUMN（mgr_id VARCHAR2（15））

相似考题

1.Examine the data in the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD_ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EX_DIR 8000120 Ravi 20 110 SA*DIR 6500DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Admin20 Education30 IT40 Human ResourcesAlso 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 REFERENCESdepartments(department_id),MGR_ID NUMBER REFERENCESemployees(employee id),MGR_ID NUMBER REFERENCESemployees(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:DELETEFROM departmentsWHERE department id = 40;What happens when you execute the DELETE statement?（）

2.Teams are required for most engineering projects.Although some small hardware or software products can be developed by individuals,the scale and complexity of modern systems is such,and the demand for short schedules so great,that it is no longer（）for one person to do most engineering jobs.Systems development is a team（）,and the effectiveness of the team largely determines the（请作答此空）of the engineering. Development teams often behave much like baseball or basketball teams.Even though they may have multiple specialties,all the members work toward（）.However,on systems maintenance and enhancement teams,the engineers often work relatively independently,much like wrestling and track teams. A team is（）just a group of people who happen to work together.Teamwork takes practice and it involves special skills.Teams require common processes;they need agreed-upon goals;and they need effective guidance and leadership.The methods for guiding and leading such teams are well known,but they are not obvious.A.size B.quality C.scale D.complexity

3.Teams are required for most engineering projects.Although some small hardware or software products can be developed by individuals,the scale and complexity of modern systems is such,and the demand for short schedules so great,that it is no longer（）for one person to do most engineering jobs.Systems development is a team（）,and the effectiveness of the team largely determines the（）of the engineering. Development teams often behave much like baseball or basketball teams.Even though they may have multiple specialties,all the members work toward（）.However,on systems maintenance and enhancement teams,the engineers often work relatively independently,much like wrestling and track teams. A team is（请作答此空）just a group of people who happen to work together.Teamwork takes practice and it involves special skills.Teams require common processes;they need agreed-upon goals;and they need effective guidance and leadership.The methods for guiding and leading such teams are well known,but they are not obvious.A.relatively B./ C.only D.more than

4.Teams are required for most engineering projects．Although some small hardware or software products can be developed by individuals,the scale and complexity of modem systems is such,and the demand for short schedules so great,that it is no longer（）for one person to do most engineering jobs．Systems development is a team（）,and the effectiveness of the team largely determines the（）of the engineermg．Development teams often behave much like baseball or basketball teams．Even though they may have multiple specialties,all the members work toward（请作答此空）．However,on systems maintenance and enhancement teams,the engineers often work relatively independently,much like wrestling and track teams．A team is（）just a group of people who happen to work together．Teamwork takes practice and it involves special skills．Teams require common processes;they need agreed-upon goals;and they need effective guidance and leadership．The methods for guiding and leading such teams are well known,but they are not obvious．A.multiple objectives B.different objectives C.a single objective D.independent objectives

更多“TEAMS表包含以下各列： TEAM_ID NUMBER（4） Primary Key TEAM_NAMEVARCHAR2（20） MGR_ID NUMBER（9） TEAMS表当前是空表。您需要允许用户在经理标识值中包含文本字符。应使用以下哪条语句来执行此任务（）A、ALTER teams MODIFY（mgr_id VARCHAR2（15））B、ALTERTABLE teams MODIFY（mgr_idVARCHAR2（15））C、ALTERTABLE teams REPLACE（mgr_id VA”相关问题

第1题：

D.evelopment teams often behave much like baseball or basketball teams.Even though they may have multiple specialties,all the members work toward（）.However,on systems maintenance and enhancement teams,the engineers often work relatively independently,much like wrestling and track teams.
A team is（）just a group of people who happen to work together.Teamwork takes practice and it involves special skills.Teams require common processes;they need agreed-upon goals;and they need effective guidance and leadership.The methods for guiding and leading such teams are well known,but they are not obvious.

A.convenient
B.existing
C.practical
D.real

答案：C
解析：
第2题：

Teams are required for most engineering projects. Although some small hardware or software products can be developed by individuals, the scale and complexity of modem systems is such, and the demand for short schedules so great, that it is no longer ___71___ for one person to do most engineering jobs. Systems development is a team ___72___, and the effectiveness of the team largely determines the ___73___ of the engineering.
Development teams often behave much like baseball or basketball teams. Even though they may have multiple specialties, all the members work toward ___74___. However, on systems maintenance and enhancement teams, the engineers often work relatively independently, much like wrestling and track teams.A team is ___75__ just a group of people who happen to work together. Teamwork takes practice and it involves special skills. Teams require common processes; they need agreed-upon goals; and they need effective guidance and leadership. The methods for guiding and leading such teams are well known,but they are not obvious.

A.activity
B.job
C.process
D.application

答案：A
解析：
大多数软件工程项目都是需要由项目团队完成的，虽然小的简单的软硬件系统个人就能完成，但是对于大型复杂系统并且需要详细计划的项目由个人完成并不实际。系统开发是团队工作，团队工作的效率很大程度上决定了软件工程的质量。开发团队的合作与篮球或棒球运动员之间的合作很相像，尽管每个人都有自己擅长的技术，但是大家是向着一个目标而努力的。项目团队不是一群碰巧工作在一起的人，团队工作需要一群人互相配合，齐心协力向着一个目标奋斗，并且这群人也需要一个好的领导来带领他们。
第3题：

“球员”表包含以下列：球员标识NUMBER（9）姓氏VARCHAR2（20）名字VARCHAR2（20）球队标识NUMBER（4）经理标识NUMBER（9）位置标识NUMBER（4）如果要显示“球队标识”列和“经理标识”列的唯一组合，应使用哪条SELECT语句？（）
- A、SELECT*FROM球员；
- B、SELECT球队标识，经理标识FROM球员；
- C、SELECTDISTINCT球队标识，经理标识FROM球员；（*）
- D、SELECT球队标识，DISTINCT经理标识FROM球员；
- E、SELECT球队标识，经理标识DISTINCTFROM球员；
正确答案:C
第4题：

您正在创建“雇员”表。此表应包含“佣金”列；如果在插入记录时未提供任何佣金值，此表会使用值10%。应当在CREATETABLE语句中包括以下哪一行来完成此任务（）
- A、佣金NUMBER（4，2）DEFAULT0.10
- B、佣金NUMBER（4，2）DEFAULT=0.10
- C、佣金NUMBER（4，2）DEFAULT（0.10）
- D、佣金NUMBER（4，2）（DEFAULT，0.10）
正确答案:C
第5题：

FACULTY表包含以下各列： FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) ADDRESS VARCHAR2(35) CITY VARCHAR2(15) STATE VARCHAR2(2) ZIP NUMBER(9) TELEPHONE NUMBER(10) STATUS VARCHAR2(2) NOT NULL COURSE 表包含以下各列： COURSEID VARCHAR2(5) NOT NULL PRIMARY KEY SUBJECT VARCHAR2(5) TERM VARCHAR2(6 FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEY 您需要制定一个报表，用于确定在下学期任教的所有副教授。您要创建一个视图来简化报表的创建过程。以下哪条CREATE VIEW语句将完成此任务（）
- A、CREATE VIEW（SELECT first_name，last_name，status，courseid，subject，term FROM faculty，course WHERE facultyid=facultyid）
- B、CREATE VIEW pt_view ON（SELEC Tfirst_name，last_name，status，courseid，subject，term FROM faculty f and coursec WHERE f.facultyid=c.facultyid）
- C、CREATE VIEW pt_view IN（SELECT first_name，last_name，status，courseid，subject，term FROM faculty course）
- D、CREATE VIEW pt_view AS（SELECT first_name，last_name，status，courseid，subject，term FROM facultyf，coursec WHERE f.facultyid=c.facultyid）
正确答案:D
第6题：

您的主管让您修改ORDERS表中的AMOUNT列。他要求将该列配置为接受默认值250。该表包含您需要保留的数据。应执行以下哪条语句来完成此任务（）
- A、ALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250
- B、ALTER TABLE orders MODIFY（amount DEFAULT 250）
- C、DROP TABLE orders CREATE TABLE orders（orderno varchar2（5）CONSTRAINT pk_orders_01 PRIMARY KEY，customerid varchar2（5）REFERENCES customers（customerid），orderdate date，amount DEFAULT 250）
- D、DELETE TABLE orders CREATE TABLE orders（orderno varchar2（5）CONSTRAINT pk_orders_01 PRIMARY KEY，customerid varchar2（5）REFERENCES customers（customerid），orderdate date，amount DEFAULT 250）
正确答案:B
第7题：

以前的管理员创建了一个名为CONTACTS的表，其中包含过时的数据。您想从数据库中删除该表及该表中的数据。应使用以下哪条语句（）
- A、DROPTABLE
- B、DELETE
- C、TRUNCATETABLE
- D、ALTERTABLE
正确答案:B
第8题：

单选题
TEAMS表包含以下各列： TEAM_ID NUMBER（4） Primary Key TEAM_NAMEVARCHAR2（20） MGR_ID NUMBER（9） TEAMS表当前是空表。您需要允许用户在经理标识值中包含文本字符。应使用以下哪条语句来执行此任务（）
A
ALTER teams MODIFY（mgr_id VARCHAR2（15））
B
ALTERTABLE teams MODIFY（mgr_id VARCHAR2（15））
C
ALTERTABLE teams REPLACE（mgr_id VARCHAR2（15））
D
ALTER teams TABLEMODIFYCOLUMN（mgr_id VARCHAR2（15））

正确答案： D
解析：暂无解析
第9题：

单选题
FACULTY表包含以下各列： FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) ADDRESS VARCHAR2(35) CITY VARCHAR2(15) STATE VARCHAR2(2) ZIP NUMBER(9) TELEPHONE NUMBER(10) STATUS VARCHAR2(2) NOT NULL COURSE 表包含以下各列： COURSEID VARCHAR2(5) NOT NULL PRIMARY KEY SUBJECT VARCHAR2(5) TERM VARCHAR2(6 FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEY 您需要制定一个报表，用于确定在下学期任教的所有副教授。您要创建一个视图来简化报表的创建过程。以下哪条CREATE VIEW语句将完成此任务（）
A
CREATE VIEW（SELECT first_name，last_name，status，courseid，subject，term FROM faculty，course WHERE facultyid=facultyid）
B
CREATE VIEW pt_view ON（SELEC Tfirst_name，last_name，status，courseid，subject，term FROM faculty f and coursec WHERE f.facultyid=c.facultyid）
C
CREATE VIEW pt_view IN（SELECT first_name，last_name，status，courseid，subject，term FROM faculty course）
D
CREATE VIEW pt_view AS（SELECT first_name，last_name，status，courseid，subject，term FROM facultyf，coursec WHERE f.facultyid=c.facultyid）

正确答案： D
解析：暂无解析
第10题：

单选题
The students in a certain physical education class are on either the football team or the basketball team, are on both these teams, or are not on either team. If 12 students are on the football team, 15 students are on the basketball team, 8 students are on both teams, and 9 students are not on either of these teams, how many students are in the class?
A
44
B
40
C
32
D
28
E
26

正确答案： D
解析：
(12+15-8)+9=28
第11题：

单选题
The students in a certain physical education class are on either the basketball team or the tennis team, are on both these teams, or are not on either team. If 15 students are on the basketball team, 18 students are on the tennis team, 11 students are on both teams, and 14 students are not on either of these teams, how many students are in the class?
A
48
B
40
C
36
D
30
E
28

正确答案： D
解析：
The number of students on one but not both of the two teams is the sum of the number of students on the basketball team plus the number on the tennis team minus the number on both teams: 15+18-11 =22. Since 22 students are on the basketball or the tennis team and 14 students are not on either team, there are 22+14 or 36 students in the class.
第12题：

单选题
您正在创建“雇员”表。此表应包含“佣金”列；如果在插入记录时未提供任何佣金值，此表会使用值10%。应当在CREATETABLE语句中包括以下哪一行来完成此任务（）
A
佣金NUMBER（4，2）DEFAULT0.10
B
佣金NUMBER（4，2）DEFAULT=0.10
C
佣金NUMBER（4，2）DEFAULT（0.10）
D
佣金NUMBER（4，2）（DEFAULT，0.10）

正确答案： C
解析：暂无解析
第13题：

Teams are required for most engineering projects. Although some small hardware or software products can be developed by individuals, the scale and complexity of modem systems is such, and the demand for short schedules so great, that it is no longer ___71___ for one person to do most engineering jobs. Systems development is a team ___72___, and the effectiveness of the team largely determines the ___73___ of the engineering.
Development teams often behave much like baseball or basketball teams. Even though they may have multiple specialties, all the members work toward ___74___. However, on systems maintenance and enhancement teams, the engineers often work relatively independently, much like wrestling and track teams.A team is ___75__ just a group of people who happen to work together. Teamwork takes practice and it involves special skills. Teams require common processes; they need agreed-upon goals; and they need effective guidance and leadership. The methods for guiding and leading such teams are well known,but they are not obvious.

A.relatively
B. /
C.only
D.more than

答案：D
解析：
大多数软件工程项目都是需要由项目团队完成的，虽然小的简单的软硬件系统个人就能完成，但是对于大型复杂系统并且需要详细计划的项目由个人完成并不实际。系统开发是团队工作，团队工作的效率很大程度上决定了软件工程的质量。开发团队的合作与篮球或棒球运动员之间的合作很相像，尽管每个人都有自己擅长的技术，但是大家是向着一个目标而努力的。项目团队不是一群碰巧工作在一起的人，团队工作需要一群人互相配合，齐心协力向着一个目标奋斗，并且这群人也需要一个好的领导来带领他们。
第14题：

Teams are required for most engineering projects. Although some small hardware or software products can be developed by individuals, the scale and complexity of modem systems is such, and the demand for short schedules so great, that it is no longer ___71___ for one person to do most engineering jobs. Systems development is a team ___72___, and the effectiveness of the team largely determines the ___73___ of the engineering.
Development teams often behave much like baseball or basketball teams. Even though they may have multiple specialties, all the members work toward ___74___. However, on systems maintenance and enhancement teams, the engineers often work relatively independently, much like wrestling and track teams.A team is ___75__ just a group of people who happen to work together. Teamwork takes practice and it involves special skills. Teams require common processes; they need agreed-upon goals; and they need effective guidance and leadership. The methods for guiding and leading such teams are well known,but they are not obvious.

A.size
B.quality
C.scale
D.complexity

答案：B
解析：
大多数软件工程项目都是需要由项目团队完成的，虽然小的简单的软硬件系统个人就能完成，但是对于大型复杂系统并且需要详细计划的项目由个人完成并不实际。系统开发是团队工作，团队工作的效率很大程度上决定了软件工程的质量。
开发团队的合作与篮球或棒球运动员之间的合作很相像，尽管每个人都有自己擅长的技术，但是大家是向着一个目标而努力的。项目团队不是一群碰巧工作在一起的人，团队工作需要一群人互相配合，齐心协力向着一个目标奋斗，并且这群人也需要一个好的领导来带领他们。
第15题：

为表TEST中ID列添加主键约束的语法是（）
- A、ALTER TABLE TEST CHANGE（ ID INT PRIMARY KEY）
- B、ALTER TABLE TEST ADD（ ID INT PRIMARY KEY）
- C、ALTER TABLE TEST MODIFY（ ID INT PRIMARY KEY）
- D、ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY （ID）
正确答案:D
第16题：

评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2） EMPLOYEE_ID列当前包含500个雇员标识号。业务需求已发生变化，您需要允许用户在标识值中包含文本字符。应该使用哪条语句来更改该列的数据类型（）
- A、ALTER TABLE employee MODIFY（employee_id VARCHAR2（9））
- B、ALTER TABLE employee REPLACE（employee_id VARCHAR2（9））
- C、ALTER employee TABLEMODIFY COLUMN（employee_id VARCHAR2（15））
- D、您不能修改EMPLOYEE_ID列的数据类型，因为该表不为空
正确答案:A
第17题：

评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2）您使用以下哪条语句可将LAST_NAME列（当前包含200条记录）的长度增加到35个字节（）
- A、ALTER employee TABLEAL TERCOLUMN（last_name VARCHAR2（35））
- B、ALTER TABLE employee RENAME last_name VARCHAR2（35）
- C、ALTER TABLE employee MODIFY（last_name VARCHAR2（35））
- D、不能增大LAST_NAME列的宽度
正确答案:C
第18题：

DEPARTMENT 表包含以下列： DEPT_ID NUMBER, Primary Key DEPT_ABBR VARCHAR2(4) DEPT_NAME VARCHAR2(30) MGR_ID NUMBER EMPLOYEE 表包含以下列： EMPLOYEE_ID NUMBER EMP_LNAME VARCHAR2(25) EMP_FNAME VARCHAR2(25) DEPT_ID NUMBER JOB_ID NUMBER MGR_ID NUMBER SALARY NUMBER(9,2) HIRE_DATE DATE 请评估以下语句： ALTER TABLE employee ADD CONSTRAINT REFERENTIAL (mgr_id) TO department(mgr_id); 是以下哪个说法（）
- A、ALTER TABLE语句创建从EMPLOYEE表到DEPARTMENT表的引用约束条件
- B、ALTER TABLE语句创建从DEPARTMENT表到EMPLOYEE表的引用约束条件
- C、ADD CONSTRAINT子句存在语法错误，因此ALTER TABLE语句将会失败
- D、ALTER TABLE语句执行成功，但不重新创建引用约束条件
正确答案:A
第19题：

“产品”表包含以下列：产品标识 NUMBER(4) 产品名称 VARCHAR2(25) 产品价格 NUMBER(3) 您想向“产品”表中添加以下数据行： (1) 在“产品标识”列中添加 Null 值 (2) 在“产品名称”列中添加“6-foot nylon leash” (3) 在“产品价格”列添加“10” 于是，您发出了以下语句： INSERT INTO 产品 VALUES (null,'6-foot nylon leash', 10); 请问，您向表中添加了什么行数据？（）
- A、创建该行时三个列中使用的值都正确。
- B、创建该行时三个列中有两个列使用的值正确。
- C、创建该行时三个列中有一个列使用的值正确。
- D、该行的创建完全错误。没有任何数据添加到正确的列中。
正确答案:A
第20题：

单选题
DEPARTMENT 表包含以下列： DEPT_ID NUMBER, Primary Key DEPT_ABBR VARCHAR2(4) DEPT_NAME VARCHAR2(30) MGR_ID NUMBER EMPLOYEE 表包含以下列： EMPLOYEE_ID NUMBER EMP_LNAME VARCHAR2(25) EMP_FNAME VARCHAR2(25) DEPT_ID NUMBER JOB_ID NUMBER MGR_ID NUMBER SALARY NUMBER(9,2) HIRE_DATE DATE 请评估以下语句： ALTER TABLE employee ADD CONSTRAINT REFERENTIAL (mgr_id) TO department(mgr_id); 是以下哪个说法（）
A
ALTER TABLE语句创建从EMPLOYEE表到DEPARTMENT表的引用约束条件
B
ALTER TABLE语句创建从DEPARTMENT表到EMPLOYEE表的引用约束条件
C
ADD CONSTRAINT子句存在语法错误，因此ALTER TABLE语句将会失败
D
ALTER TABLE语句执行成功，但不重新创建引用约束条件

正确答案： C
解析：暂无解析
第21题：

单选题
您的主管让您修改ORDERS表中的AMOUNT列。他要求将该列配置为接受默认值250。该表包含您需要保留的数据。应执行以下哪条语句来完成此任务（）
A
ALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250
B
ALTER TABLE orders MODIFY（amount DEFAULT 250）
C
DROP TABLE orders CREATE TABLE orders（orderno varchar2（5）CONSTRAINT pk_orders_01 PRIMARY KEY，customerid varchar2（5）REFERENCES customers（customerid），orderdate date，amount DEFAULT 250）
D
DELETE TABLE orders CREATE TABLE orders（orderno varchar2（5）CONSTRAINT pk_orders_01 PRIMARY KEY，customerid varchar2（5）REFERENCES customers（customerid），orderdate date，amount DEFAULT 250）

正确答案： C
解析：暂无解析
第22题：

单选题
评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2） EMPLOYEE_ID列当前包含500个雇员标识号。业务需求已发生变化，您需要允许用户在标识值中包含文本字符。应该使用哪条语句来更改该列的数据类型（）
A
ALTER TABLE employee MODIFY（employee_id VARCHAR2（9））
B
ALTER TABLE employee REPLACE（employee_id VARCHAR2（9））
C
ALTER employee TABLEMODIFY COLUMN（employee_id VARCHAR2（15））
D
您不能修改EMPLOYEE_ID列的数据类型，因为该表不为空

正确答案： C
解析：暂无解析
第23题：

单选题
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?（）
A
To find the tax percentage for each of the employees.
B
To list the name, job id, and manager name for all the employees.
C
To find the name, salary, and department name of employees who are not working with Smith.
D
To find the number of employees working for the Administrative department and earning less then 4000.
E
To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

正确答案： C
解析：暂无解析

题目

相似考题

相关内容