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

题目
多选题
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题:

Which of the following a true statements regarding the use of VLANs to segment a network? (Select three)

A. They increase the size of collision domains

B. They allow logical grouping of users by function.

C. They can enhance network security.

D. They increase the size of the broadcast domain while decreasing the number of collision domains.

E. They increase the number of broadcast domains while decreasing the size of the broadcast domains.

F. They simplify switch administration.


正确答案:BCE
B,C,E 解析:Explanation:
VLANs are used to segment a LAN into multiple, smaller LANs. This can be used to enhance security as local traffic from one VLAN will not be passed to users in other VLANS.

Incorrect Answers:
A. VLANs are used to decrease the size of a collision domain, not increase it.

D. The opposite is true.

F. The default operation of a switch is to allow all traffic and to enable all ports in VLAN1. The use of VLANs will increase the complexity of the switch environment, making for more difficult administration.

第2题:

Which statements are true regarding classless routing protocols?()

A. The use of discontiguous subnets is not allowed

B. The use of variable length subnet masks is permitted

C. RIP v1 is a classless routing protocol

D. IGRP supports classless routing within the same autonomous system

E. RIP v2 supports classless routing


参考答案:B, E

第3题:

Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset.

E. The DMU can report columns that are not represented in the converted characterset.


参考答案:A, D, E

第4题:

Which statement is true regarding the Junos OS?()

  • A、All platforms running the Junos OS use the same source code base
  • B、All platforms running the Junos OS use the same PFE
  • C、All platforms running the Junos OS use a hard drive to optimize syslog data storage
  • D、All platforms running the Junos OS use a separate process with protected memory space for each routing protocol

正确答案:A

第5题:

Which two statements are true regarding the USING clause in table joins?()

  • A、It can be used to join a maximum of three tables 
  • B、It can be used to restrict the number of columns used in a NATURAL join 
  • C、It can be used to access data from tables through equijoins as well as nonequijoins 
  • D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第6题:

Which three security concerns can be addressed by a tunnel mode IPsec VPN secured by ESP?() (Choose three.)

A. data integrity

B. data confidentiality

C. data authentication

D. outer IP header confidentiality

E. outer IP header authentication


参考答案:A, B, C

第7题:

Exhibit: Which of the following are true regarding the command output shown in the display (Choose two.)()。

A.There are at least two routers participating in the RIP process.

B.A ping to 192.168.168.2 will be successful.

C.A ping to 10.0.15.2 will be successful.

D.RtrA has three interfaces participating in the RIP process.


参考答案:A, C

第8题:

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()

A. Allocates memory for RMAN backup and restore operations

B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors

D. Contains stack space

E. Contains a hash area performing hash joins of tables


参考答案:A, B, C

第9题:

What is true regarding subqueries?()

  • A、The inner query always sorts the results of the outer query
  • B、The outer query always sorts the results of the inner query
  • C、The outer query must return a value to the outer query
  • D、The inner query returns a value to the outer query
  • E、The inner query must always return a value or the outer query will give an error

正确答案:D

第10题:

Which three security concerns can be addressed by a tunnel mode IPsec VPN secured by ESP?() (Choose three.)

  • A、data integrity
  • B、data confidentiality
  • C、data authentication
  • D、outer IP header confidentiality
  • E、outer IP header authentication

正确答案:A,B,C

更多相关问题