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 VARCHAR2（15））D、ALTER teams TABLEMODIFYCOLUMN（mgr_id VARCHAR2（15））
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））
相关考题：
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?（）
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 objectivesB.different objectivesC.a single objectiveD.independent objectives
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.sizeB.qualityC.scaleD.complexity
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.relativelyB./C.onlyD.more than
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.convenientB.existingC.practicalD.real
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.relativelyB. /C.only D.more than
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.jobC.process D.application
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.sizeB.qualityC.scaleD.complexity
“球员”表包含以下列： 球员标识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球员；
为表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）
您正在创建“雇员”表。此表应包含“佣金”列；如果在插入记录时未提供任何佣金值，此表会使用值10%。应当在CREATETABLE语句中包括以下哪一行来完成此任务（）A、佣金NUMBER（4，2）DEFAULT0.10B、佣金NUMBER（4，2）DEFAULT=0.10C、佣金NUMBER（4，2）DEFAULT（0.10）D、佣金NUMBER（4，2）（DEFAULT，0.10）
评估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列的数据类型，因为该表不为空
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）
评估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列的宽度
您的主管让您修改ORDERS表中的AMOUNT列。他要求将该列配置为接受默认值250。该表包含您需要保留的数据。应执行以下哪条语句来完成此任务（）A、ALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250B、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）
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语句执行成功，但不重新创建引用约束条件
以前的管理员创建了一个名为CONTACTS的表，其中包含过时的数据。您想从数据库中删除该表及该表中的数据。应使用以下哪条语句（）A、DROPTABLEB、DELETEC、TRUNCATETABLED、ALTERTABLE
“产品”表包含以下列： 产品标识 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、该行的创建完全错误。没有任何数据添加到正确的列中。
单选题TEAMS表包含以下各列： TEAM_ID NUMBER（4） Primary Key TEAM_NAMEVARCHAR2（20） MGR_ID NUMBER（9） TEAMS表当前是空表。您需要允许用户在经理标识值中包含文本字符。应使用以下哪条语句来执行此任务（）AALTER teams MODIFY（mgr_id VARCHAR2（15））BALTERTABLE teams MODIFY（mgr_idVARCHAR2（15））CALTERTABLE teams REPLACE（mgr_id VARCHAR2（15））DALTER teams TABLEMODIFYCOLUMN（mgr_id VARCHAR2（15））
单选题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); 是以下哪个说法（）AALTER TABLE语句创建从EMPLOYEE表到DEPARTMENT表的引用约束条件BALTER TABLE语句创建从DEPARTMENT表到EMPLOYEE表的引用约束条件CADD CONSTRAINT子句存在语法错误，因此ALTER TABLE语句将会失败DALTER TABLE语句执行成功，但不重新创建引用约束条件
单选题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语句将完成此任务（）ACREATE VIEW（SELECT first_name，last_name，status，courseid，subject，term FROM faculty，course WHERE facultyid=facultyid）BCREATE VIEW pt_view ON（SELEC Tfirst_name，last_name，status，courseid，subject，term FROM faculty f and coursec WHERE f.facultyid=c.facultyid）CCREATE VIEW pt_view IN（SELECT first_name，last_name，status，courseid，subject，term FROM faculty course）DCREATE VIEW pt_view AS（SELECT first_name，last_name，status，courseid，subject，term FROM facultyf，coursec WHERE f.facultyid=c.facultyid）
单选题您的主管让您修改ORDERS表中的AMOUNT列。他要求将该列配置为接受默认值250。该表包含您需要保留的数据。应执行以下哪条语句来完成此任务（）AALTER TABLE orders CHANGE DATATYPE amount TO DEFAULT 250BALTER TABLE orders MODIFY（amount DEFAULT 250）CDROP 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）DDELETE 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）
单选题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?A44B40C32D28E26
单选题评估EMPLOYEE表的结构： EMPLOYEE_IDNUMBER（9） LAST_NAMEVARCHAR2（25） FIRST_NAMEVARCHAR2（25） DEPARTMENT_IDNUMBER（9） MANAGER_IDNUMBER（9） SALARYNUMBER（7，2） EMPLOYEE_ID列当前包含500个雇员标识号。业务需求已发生变化，您需要允许用户在标识值中包含文本字符。应该使用哪条语句来更改该列的数据类型（）AALTER TABLE employee MODIFY（employee_id VARCHAR2（9））BALTER TABLE employee REPLACE（employee_id VARCHAR2（9））CALTER employee TABLEMODIFY COLUMN（employee_id VARCHAR2（15））D您不能修改EMPLOYEE_ID列的数据类型，因为该表不为空
单选题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?A48B40C36D30E28
单选题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?（）ATo find the tax percentage for each of the employees.BTo list the name, job id, and manager name for all the employees.CTo find the name, salary, and department name of employees who are not working with Smith.DTo find the number of employees working for the Administrative department and earning less then 4000.ETo display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
单选题您正在创建“雇员”表。此表应包含“佣金”列；如果在插入记录时未提供任何佣金值，此表会使用值10%。应当在CREATETABLE语句中包括以下哪一行来完成此任务（）A佣金NUMBER（4，2）DEFAULT0.10B佣金NUMBER（4，2）DEFAULT=0.10C佣金NUMBER（4，2）DEFAULT（0.10）D佣金NUMBER（4，2）（DEFAULT，0.10）