大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
【優(yōu)技教育】Oracle 19c OCP 082題庫(第1題)- 2024年修正版
考試科目:1Z0-082
考試題量:90
通過分?jǐn)?shù):60%
考試時(shí)間:150min
本文為(CUUG 原創(chuàng))整理并解析,轉(zhuǎn)發(fā)請注明出處,禁止抄襲及未經(jīng)注明出處的轉(zhuǎn)載。
原文地址:http://www.cuug.com/index.php?s=/home/article/detail/id/3385.html
第1題:
1、Choose two.
You execute these commands:
CREATE TABLE customers (customer_id INTEGER, customer_name VARCHAR2 (20)) ;
INSERT INTO customers VALUES (1, 'Customer 1') ;
SAVEPOINT post_insert;
INSERT INTO customers VALUES (2, ' Customer 2') ;
SELECT COUNT(*) FROM customers;
Which two, used independently, can replace so the query returns 1?
A) COMMIT TO SAVEPOINT post_insert;
B) ROLLBACK TO post_insert;
C) COMMIT;
D) ROLLBACK TO SAVEPOINT post_insert;
E) ROLLBACK;
Answer:BD
(解析:試驗(yàn)發(fā)現(xiàn)提交的時(shí)候不能指定到某個(gè)保存點(diǎn)。)
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)系老師咨詢。