최신Oracle MySQL 8.0 Database Developer - 1z1-909무료샘플문제
문제1
Examine this statement and output:
You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?
Examine this statement and output:
You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?
정답: C
문제2
Examine these statements issued from Session 1 which execute successfully:
Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?
Examine these statements issued from Session 1 which execute successfully:
Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?
정답: B,F
문제3
Examine these statements which execute successfully:
Now, examine this query:
What is the result?
Examine these statements which execute successfully:
Now, examine this query:
What is the result?
정답: A
문제4
Examine these commands and output:
Which is true about the execution of the insert statement?
Examine these commands and output:
Which is true about the execution of the insert statement?
정답: A
문제5
Which two are true about indexes?
Which two are true about indexes?
정답: C,D
문제6
Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?
Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?
정답: B
문제7
Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?
Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?
정답: C