Which three are true regarding the use of outer joins? ()A. You cannot use IN operator in a condition that involves an outerjoin.B. You use (+) on both sides of the WHERE condition to perform an outerjoin.C. You use (*) on both sides of the WHERE conditio

题目
Which three are true regarding the use of outer joins? ()

A. You cannot use IN operator in a condition that involves an outerjoin.

B. You use (+) on both sides of the WHERE condition to perform an outerjoin.

C. You use (*) on both sides of the WHERE condition to perform an outerjoin.

D. You use an outerjoin to see only the rows that do not meet the join condition.

E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.

F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.


相似考题
参考答案和解析
参考答案:D, E, F
更多“Which three are true regarding the use of outer joins? () ”相关问题
  • 第1题:

    以下对枚举类型名的定义中正确的是______。

    A.enum a={one,two,three};

    B.enum a{on=9,two=-1,three};

    C.enum a={"one","two","three"};

    D.enum a{"one","two","three"};


    正确答案:B
    解析:声明枚举类型用enum开头。例如:enumweekday(sun,mon,tue,wed,thu,fri,sat);说明;1、在C编译中,对枚单元素按常量处理,同时可以改变他们的值。2、枚举值可以用来做判断比较。3、一个整数不能直接赋给一个牧举变量。

  • 第2题:

    Despite the wonderful acting and well-developed plot the _________ movie could not hold our attention.

    A) three-hours B) three-hour

    C) three-hours’ D) three-hour’s

     

     


    选B

     用破折号连接的作形容词不用复数.

  • 第3题:

    4、Outer类中定义了一个成员内部类Inner,需要在main()方法中创建Inner类实例对象,以下四种方式哪一种是正确的?()

    A.Inner in = new Inner()

    B.Inner in = new Outer.Inner();

    C.Outer.Inner in = new Outer.Inner();

    D.Outer.Inner in = new Outer().new Inner();


    正确

  • 第4题:

    以下对枚举类型名的定义中正确的是______。

    A.enum a={one,two,three};

    B.enum a{one=9,two=-1,three};

    C.enum a={"one","two","three"};

    D.enum a{"one","two","three"};


    正确答案:B
    解析:声明枚举类型用enum开头。例如:enum weekday(sun,mon,tue,wed,thu,fri,sat); 说明:1、在C编译中,对枚举元素按常量处理,同时可以改变他们的值。2、枚举值可以用来做判断比较。3、一个整数不能直接赋给一个枚举变量。

  • 第5题:

    Import for the first three months this year is larger than that for the__________period last year.


    A.relating

    B.concerning

    C.corresponding

    D.regarding

    答案:C
    解析:
    考查词义辨析。句意为“今年前三个月的进口量比上一年同期多”。relating to“相关的”,concerning“关于”,corresponding“相当的,对应的”,regarding“关于;就……而论”。根据句意可知是今年前三个月和去年相对应的前三个月做对比.故选C。

  • 第6题:

    Outer类中定义了一个静态内部类Inner,需要在main()方法中创建Inner类实例对象,以下四种方式哪一种是正确的? ()

    A.Inner in = new Inner();

    B.Inner in = new Outer.Inner();

    C.Outer.Inner in = new Outer.Inner();

    D.Outer.Inner in = new Outer().new Inner()


    Outer.Inner in = new Outer.Inner();