网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）
A
The SQL statement displays the desired results.
B
The column in the WHERE clause should be changed to display the desired results.
C
The operator in the WHERE clause should be changed to display the desired results.
D
The WHERE clause should be changed to use an outer join to display the desired results.
参考答案
参考解析
解析：
暂无解析
更多 “单选题The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?（）A The SQL statement displays the desired results.B The column in the WHERE clause should be changed to display the desired results.C The operator in the WHERE clause should be changed to display the desired results.D The WHERE clause should be changed to use an outer join to display the desired results.” 相关考题
考题
单选题The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）A
randomlyB
ascending by dateC
descending by dateD
ascending alphabeticallyE
descending alphabetically
考题
单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）A
SELECT 1, 2 FROM 3 WHERE last_name = '8';B
SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C
SELECT 1, 2 FROM 3 WHERE last_name = '8';D
SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）A
SELECT COUNT (*) FROM employees WHERE last _name='smith';B
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';C
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';D
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';E
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
考题
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）A
The SQL statement displays the desired results.B
The column in the WHERE clause should be changed to display the desired results.C
The operator in the WHERE clause should be changed to display the desired results.D
The WHERE clause should be changed to use an outer join to display the desired results.
考题
单选题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_';
考题
单选题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.
考题
多选题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? （）AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');CINSERT INTO employees VALUES ('1000','JOHN','NULL');DINSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
考题
单选题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 ( employe_id NUMBER, name VARCGAR2(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 sey 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.
考题
单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）A
SELECT last_name, 12*salary* commission_pct FROM emp;B
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
考题
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）A
The SQL statement displays the desired results.B
The column in the WHERE clause should be changed to display the desired results.C
The operator in the WHERE clause should be changed to display the desired results.D
The WHERE clause should be changed to use an outer join to display the desired results.
考题
单选题评估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列的宽度
热门标签
最新试卷
