Oracle认证考试
Which three statements about subqueries are true?（）A、A single row subquery can retrieve only one column and one row.B、A single row subquery can retrieve only one row but many columns.C、A multiple row subquery can retrieve multiple rows and multiple column
题目
Which three statements about subqueries are true?（）
- A、A single row subquery can retrieve only one column and one row.
- B、A single row subquery can retrieve only one row but many columns.
- C、A multiple row subquery can retrieve multiple rows and multiple columns.
- D、A multiple row subquery can be compared by using the ">" operator.
- E、A single row subquery can use the IN operator.
- F、A multiple row subquery can use the "=" operator.
参考答案和解析
相似问题和答案
第1题：
A. one-rate rate limiters
B. two-rate rate limiters
C. two-rate rate limiters is the default
D. one-rate rate limiters is the default
E. there is no default it must be configured
第2题：
Which three statements are correct about RIP version 2? (Choose three.)（）
- A、It has the same maximum hop count as version 1.
- B、It uses broadcasts for its routing updates.
- C、It is a classless routing protocol.
- D、It has a lower default administrative distance than RIP version 1.
- E、It supports authentication.
- F、It does not send the subnet mask in updates.
正确答案:A,C,E
第3题：
15 Which of the following statements about intangible assets are correct?
1 If certain criteria are met, research expenditure must be recognised as an intangible asset.
2 Goodwill may not be revalued upwards.
3 Internally generated goodwill should not be capitalised.
A 2 and 3 only
B 1 and 3 only
C 1 and 2 only
D All three statements are correct
第4题：
Which two statements about IS reachability TLV (TLV 2) and the extended IS reachability (TLV 22) are true?（）
- A、TLV 22 supports wide metrics.
- B、TLV 2 is only used in Level 1 routers.
- C、TLV 22 displays the neighbor's extended areas.
- D、Only TLV 22 can support the inclusion of sub-TLVs.
正确答案:A,D
第5题：
Which three statements about Label-Switched Paths （LSPs） are true？ （）
- A、 LSPs are bidirectional.
- B、 LSPs are unidirectional.
- C、 LSPs can be signaled by CAC.
- D、 LSPs can be configured explicitly.
- E、 LSPs can be configured dynamically.
正确答案:B,D,E
第6题：
Which three statements are correct about RIP version 2 (Choose three.)（）。
- A、It has the same maximum hop count as version 1
- B、It uses broadcasts for its routing updates
- C、It is a classless routing protocol
- D、It has a lower default administrative distance than RIP version 1
- E、It supports authentication
- F、It does not send the subnet mask in updates
正确答案:A,C,E
第7题：
Which of these statements is true about ssids configured in cisco adu？（）
- A、ssids are not case-sensitive.
- B、ssids must be listed in the same order in the adu as they are in the access point.
- C、a maximum of three ssids may be configured.
- D、ssids may have a maximum of 16 characters.
正确答案:C
第8题：
19 Which of the following statements about intangible assets in company financial statements are correct according
to international accounting standards?
1 Internally generated goodwill should not be capitalised.
2 Purchased goodwill should normally be amortised through the income statement.
3 Development expenditure must be capitalised if certain conditions are met.
A 1 and 3 only
B 1 and 2 only
C 2 and 3 only
D All three statements are correct
第9题：
Which three statements are true about terms in a policy?（）
- A、The order of the terms in a policy is irrelevant
- B、The action is specified in a then statement
- C、Ters are optional in a policy
- D、The match condition can be identified with a from statement
- E、Every policy must contain at least one term
正确答案:B,D,E
第10题：
Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)
- A、It detects changes in SQL execution plans.
- B、It produces results that can be used to create the SQL plan baseline.
- C、The importance of SQL statements is based on the size of the objects accessed.
- D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
- E、It shows only the overall impact on workload and not the net SQL impact on workload.
正确答案:A,B,D