网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）
- A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee_id IN (103,115);
- B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
- C、UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);
- D、UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';
- E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);
参考答案
更多 “ Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee_id IN (103,115);B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';C、UPDATE employeesC.UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D、UPDATE employeesD.UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job_id = 'SA_REP';E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);” 相关考题
考题
M．Jackson suggested the data structure oriented software design method．Which of the following structure can be introduced by using input data structure?A．algorithm structureB．procedure structureC．code structureD．program structure
考题
合法的电子邮件地址是( )。A．Wang.em.hxing.com.cnB．em.hxing.com.cn.wangC．em.hxing.com.on@wangD．wang@em.hxig.com.cn
考题
S7－200PLC有哪几种扩展模块?()
A、数字量扩展模块：EM 221、EM222、EM223B、模拟量扩展模块：EM 231、EM232、EM235C、通信模块：EM227D、现场设备扩展模块：CP243;
考题
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.
考题
Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES table:You issue these statements:At the end of this transaction, what is true?()
A. You have no rows in the table.B. You have an employee with the name of James.C. You cannot roll back to the same savepoint more than once.D. Your last update fails to update any rows because employee ID 180 was already eleted.
考题
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()
A.B.C.D.
考题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()
A.B.C.D.
考题
当()时,货币贬值使该国国际收支状况恶化。A:|ex＋em|>1B:|ex＋em|=1C:|ex＋em|
当()时，货币贬值使该国国际收支状况恶化。A:|ex+em|>1B:|ex+em|=1C:|ex+em|D:|ex+em|≤1
考题
慢代谢者（PM），快代谢者（EM），快代谢者又分为纯合子EM和杂合子EM，在相同剂量下，他们体内血药浓度比较（）A、杂合子EM＝纯合子EMPMB、纯合子EM杂合子EMPMC、PM纯合子EM＝杂合子EMD、PM杂合子EM纯合子EM
考题
$（“div”）.find（“em”；）与下面哪句功能一致？（）A、$（"divem"）B、$（"div em"）C、$（"div"）.has（"em"）D、$（"div"）.children（）.is（"em"）
考题
单选题View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？ （）A
displaying the total order value for sales representatives 161 and 163B
displaying the order total for sales representative 161 in the year 1999C
displaying the number of orders that have order mode online and order date in 1999D
displaying the number of orders whose order total is more than the average order total for all online orders
考题
单选题A data manipulation language statement （）.A
completes a transaction on a tableB
modifies the structure and data in a tableC
modifies the data but not the structure of a tableD
modifies the structure but not the data of a table
考题
单选题$（“div”）.find（“em”；）与下面哪句功能一致？（）A
$（divem）B
$（div em）C
$（div）.has（em）D
$（div）.children（）.is（em）
热门标签
最新试卷