2026년에도 ExamPassdump의 1z1-882 학습 자료는 PDF, Desktop Test Engine, Online Test Engine 세 가지 형태로 제공됩니다. 학습 환경과 스타일에 맞는 형태를 선택해 Oracle Certified Professional, MySQL 5.6 Developer 시험을 준비해 보시기 바랍니다.

Oracle 1z1-882 시험 개요:

Oracle 1z1-882 시험 요강 주제:

Oracle Certified Professional, MySQL 5.6 Developer 시험, 이것이 궁금합니다

최신 OCP 1z1-882 무료샘플문제

문제 #1

Assume your connection uses SQL mode ANSI_QUOTES.
Which two statements cause a syntax error?

A. CREATE TABLE BINARY (PRIMARY SMALLINT)
B. CREATE TABLE 'TABLE' (COLUMN' INTEGER)
C. CREATE TABLE INTERVAL (ELAPSED_TIME TIME)
D. CREATE TABLE "CONDITION" ("DESCRIBE" TEXT)
E. CREATE TABLE FRIENDS (NAME CHAR (10))

문제 #2

A table country exists with a column Name. A user variable @ limitcount contains the value 20.
Which two statements are valid uses of the LIMIT clause?

A. SELECT Name FROM country LIMIT RAND ()
B. SELECT Name FROM country LIMIT 35
C. SELECT Name FROM country LIMIT @limitcount
D. SELECT Name FROM country LIMIT 100,50
E. SELECT Name FROM country LIMIT 100-50

문제 #3

Which condition must be true in order that a view is considered updateable?

A. There must be a subquery in the WHERE clause that refers to a table in the FROM clause.
B. There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.
C. The user must have the UPDATE or DELETE privilege for the underlying table.
D. The view must only refer to literal values.

문제 #4

You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows:
Mysql> explain select comic_ title, publisher from comics where comic_title like '& Action&';

row in set (0.00 sec)
You create the following index:
CREATE INDEX cimic_title_idx ON comics (comic_title, publisher);
You run the same EXPLAIN statement again;
Mysql > explain select comic_title ,publisher from comics where comic_title like '& Action&';

1 row in set (0.00 sec)
Why did the second SELECT statement need to read all 1183 rows in the index comic_title_idx?

A. Because a wildcard character is at the beginning of the search word
B. Because a LIKE statement always requires a full tables scan
C. Because comic _title is part of acovering index
D. Because comic_title is not the primary key

문제 #5

Which statement describes the process of normalizing databases?

A. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
B. Redundant tables are combined into one larger table to simplify the schema design.
C. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
D. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest
allocation.
E. Columns that contain repeating data values are split into separate tables to reduce item duplication.

질문과 대답: