大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
【優(yōu)技教育】Oracle 19c OCP 082題庫(Q 3題)- 2024年修正版
考試科目:1Z0-082
考試題量:90
通過分?jǐn)?shù):60%
考試時(shí)間:150min
本文為(CUUG 原創(chuàng))整理并解析,轉(zhuǎn)發(fā)請(qǐng)注明出處,禁止抄襲及未經(jīng)注明出處的轉(zhuǎn)載。
原文地址:http://www.cuug.com/index.php?s=/home/article/detail/id/3386.html
第3題:
3、Choose two.
Which is true about the & and && prefixes with substitution variables?
A) Both & and && can prefix a substitution variable name in queries and DML statements.
B) The && prefix will not prompt for a value even if the substitution variable is not previously defined in the session.
C) An && prefix to an undefined substitution variable, which is referenced multiple times in multiple queries, will prompt for a value once per query.
D) & can prefix a substitution variable name only in queries.
E) An & prefix to an undefined substitution variable, which is referenced twice in the same query,will prompt for a value twice.
Answer:AE
(解析:此題的難點(diǎn)在對(duì)英文的理解上,答案 C 錯(cuò)誤的地方是多次查詢,一個(gè)是相同的查詢里面引用多次,每次查詢都要提示一次輸入,實(shí)際上不需要的。)
A: &和&&都可以在查詢和 DML 語句中作為替換變量名的前綴
Oracle 19c OCP認(rèn)證需要到Oracle指定的WDP機(jī)構(gòu),有了培訓(xùn)記錄之后才能考試,考試需要考2科,分別是082(60%及格)和083(57%及格),兩科都通過之后才能拿到證書。證書如下:
CUUG是甲骨文的金牌WDP合作機(jī)構(gòu),30多年品牌,培養(yǎng)了數(shù)萬名數(shù)據(jù)庫人才。想快速通過19c OCP考試的同學(xué)可以掃碼聯(lián)系老師咨詢。