单选题

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 ?（）

发布日期：2020-04-10

The SQL statement displays the desired results.

The column in the WHERE clause should be changed to display the desired results.

The operator in the WHERE clause should be changed to display the desired results.

The WHERE clause should be changed to use an outer join to display the desired results.

题王网让考试变得更简单

扫码关注题王，更多免费功能准备上线！

此试题出现在

其他考试

热门试题热门资讯相关试题

[多选题]You need to store a floating point number，called Tsquare，in the session scope. Which two code snippetsallow you to retrieve this value？（）

[单选题]关于信贷合同的变更，表述错误的是（）。

[单选题]在电子商务环境下，下列哪一种企业结构机制比较合理（）。

[问答题]实词包括哪些类别？

[多选题]与加工装配生产比较，连续式生产的突出特征有（）。

[单选题]石油库的消防泵站设置事故照明电源时，其连续供电时间不应少于（）min。

[单选题]下列何种邪易扰心神（）

[单选题]计算机病毒可以使整个计算机瘫痪，危害极大。计算机病毒是（　　）。

[问答题]如何理解无因管理之债的效力？

[单选题]P波消失，代之以匀齐的"F"波（）

暂无相关推荐~

[单选题]The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2...

[单选题]The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) ...

[单选题]The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE...

[单选题]The EMP table contains these columns: You need to display the employees who have...

[单选题]The EMP table has these columns: Management wants a list of names of employees w...

[单选题]The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25...

[单选题]The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) ...

[多选题]The ORDERS table has these columns: The ORDERS table tracks the Order number, th...

[单选题]有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40));...