Oracle 12cµÄOCP¿¼ÊÔ¿¼3¿Æ£¬·Ö±ðÊÇ071¡¢062¡¢063£¬¶ÔÓÚÕâЩ¿¼Ì⣬ÎÒÃÇרÃÅÓÐÈ˸ºÔðÊÕ¼¯ÕûÀí£¬²¢ÓÉרҵµÄÀÏʦ¶ÔÕâЩ¿¼Ìâ½øÐнâÎö£¬Ï£Íû¿ÉÒÔ°ïÖúÏ뿼OCPµÄͬѧ£¬ÕâÀ￪ʼ½éÉÜ071µÄÌâ¿â¡£

ÿÖÜÎåÍí8µã£¬ÎÒÃÇÓÐÃâ·ÑµÄOCP½âÎö¹«¿ª¿Î£¬µØÖ·£ºhttps://ke.qq.com/course/326223  OCPÌâ¿â½»Á÷Ⱥ£º1015267481£¬ÑéÖ¤ocp

-------------------------------------------------------

071¿¼ÊÔÌâ¿â-µÚ34Ìâ¡¢choose two

Which two statements are true regarding operators used with subqueries? (Choose two.)

A) =ANY and =ALL operators have the same functionality.

E) The NOT IN operator is equivalent to is NULL.

C) The

D) The NOT operator can be used with IN, ANY and ALL operators.

E) The IN operator cannot be used in single-row subqueries.

Answer£ºCD

(½âÎö£º051 Ôø¾­³öÏÖ¹ý£¬µ«Êǵ±Ê±Êǵ¥Ñ¡Ì⣬´ð°¸ÊÇ D£¬Õâ¸öÓï·¨±È½ÏÉÙ¼û¡£

Æäʵ¾ÍÊÇ°Ñ NOT ·Åµ½Õû¸ö±í´ïʽ֮ǰ£¬ÏÂÃæÌõ¼þÖ´ÐеĽá¹û¶¼ÊÇÒ»Ñù£¬¿¼´ó¼ÒµÄÂß¼­Ë¼Î¬ÄÜÁ¦£º

WHERE NOT col IN (SELECT ...)(Ò²¿ÉÒÔÊÇ WHERE col not IN (SELECT ...))

WHERE NOT col = ANY (SELECT ...)(´óÓÚ¡¢Ð¡ÓÚ¶¼¿ÉÒÔ)

WHERE NOT col = ALL (SELECT ...)(´óÓÚ¡¢Ð¡ÓÚ¶¼¿ÉÒÔ)

SQL> select deptno from emp

2 where not deptno in (select deptno from dept where deptno=10);

DEPTNO

----------

20

30

30

....

»òÕߣº

select deptno from emp

where not deptno = all (select deptno from dept where deptno=10);