Oracle认证考试

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 t

题目

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.
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement: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.


参考答案：C

第2题：

In which three cases would you use the USING clause?()

A.You want to create a nonequijoin.

B.The tables to be joined have multiple NULL columns.

C.The tables to be joined have columns of the same name and different data types.

D.The tables to be joined have columns with the same name and compatible data types.

E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


参考答案：C, D, E

第3题：

If you don’t know exactly where to find the information, you may use one of the many search engines on the Web. ()

此题为判断题(对，错)。


正确答案:正确

第4题：

Which statement is true about Kompella-based and Martina-based VPNs？（）

  • A、Both use LDP
  • B、Both use BGP
  • C、Both require additional hardware.
  • D、Both use a two-label stack for forwarding.

正确答案:D

第5题：

Write a letter of about 100 words to the president of your university,suggesting how to improve students’physical condition.You should include the details you think necessary.You should write neatly on the ANSWER SHEET.Do not sign your own name at the end of the letter.Use“Li Ming”instead.


答案：
解析：
审题谋篇本篇应用文仍然属于书信类型中的建议信，从话题角度看属于健康类话题。该书信的收信人为大学校长，所以属于正式文体，文中不应出现过多缩写/省略/口语表达等非正式语言。称呼处可以直接尊称“Dear Mr.President,”，正文仍然按照三段模式展开。首段需要简单地自我介绍，交代写信目的。中间段具体对如何提高大学生身体素质给出2-3条可行的建议。建议信的尾段一般是提出希望，期待回信。落款使用常见的书信落款：Yours sincerely,Sincerely yours，Yours truly，或Truly yours等，签名应写Li Ming，切勿出现自己真实姓名。二、参考范文Dear Mr.President,I am a student of our university.I am writing this letter to bring forward some effective suggestions to our college students about how to improve their body health.Initially,exercising,though not a student’s first priority in his/her daily life,should be stressed by all of us as well as our university,because it is vital to not only our physical health but mental health as well.Furthermore,developing a regular and healthy diet,which provides vitamins and other nutrients to our body,would,to some extent,undoubtedly benefit our body.I hope that you will find my suggestions useful and propagandas be launched among the students.I am looking forward to your earlier response.Yours sincerely,Li Ming三、万能句型1.I am writing this letter to bring forward some effective suggestions to…about….2.…should be stressed by…,because it is vital to but…as well.3.I hope that you will find my suggestions useful.4.I am looking forward to your earlier response.

第6题：

Describe an instance where you made effective use of facts to secure the agreement of others.


正确答案：

          

第四，请你举1个例子说明你是怎样通过事实来使他人达成一致的。

第7题：

You are planning to anchor in an area where several anchors have been lost due to fouling．As a precaution，you should ______．

A.anchor using both anchors

B.anchor with scope of 8 or more to 1

C.use a stern anchor

D.fit a crown strap and work wire to the anchor


正确答案：D

第8题：

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

第9题：

--Which of those electronic dictionaries do you like most?
-- __________. They are both expensive and of little use.

A.None
B.Neither
C.All
D.Both

答案：A
解析：
考查不定代词。both表示“两者都”，用于肯定句中；neither表示“两者都不”，用于否定句中；all指“三者或三者以上都”，用于肯定句中；none指“三者或三者以上都不”，用于否定句中。由后一句“They are both expensive and of little use．”可知答案应为表示否定的代词，故排除C、D。由首旬中的most可知是在三个以上之间选择。故选A。

第10题：

Regarding zone types， which statement is true？（）

  • A、You cannot assign an interface to a functional zone.
  • B、You can specifiy a functional zone in a security policy.
  • C、Security zones must have a scheduler applied.
  • D、You can use a security zone for traffic destined for the device itself.

正确答案:D

更多相关问题
相关内容