违法和不良信息举报 联系客服
免费注册 登录

The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35

题目
单选题
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
A

SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

B

SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

C

SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

D

SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）

  • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
  • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
  • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

正确答案:C

第2题：

单选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?（）
A

UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;

B

UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;

C

UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;

D

UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;


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

第3题：

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）

A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;


参考答案：D

第4题：

单选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; 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 deleted.


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

第5题：

单选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?（）
A

UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;

B

UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;

C

UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;

D

UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;


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

第6题：

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?（）

  • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
  • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
  • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');

正确答案:C

第7题：

单选题
The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）
A

Column definitions cannot be altered to add DEFAULT values.

B

A change to the DEFAULT value affects only subsequent insertions to the table.

C

Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

D

All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


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

第8题：

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

  • A、A check constraint on the EMPLOYEE table
  • B、A unique constraint on the EMPLOYEE table WORKDEPT column
  • C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
  • D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

正确答案:D

第9题：

单选题
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
A

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

B

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

C

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

D

SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';


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

第10题：

多选题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）
A

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

B

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

C

INSERT INTO employees VALUES ('1000','JOHN','NULL');

D

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

E

INSERT INTO employees (employee_id) VALUES (1000);

F

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);


正确答案： A,F
解析： 暂无解析

更多相关问题
相关内容