検証済みの1z1-909試験問題集PDF [2023年最新] 成功の秘訣はここにある [Q22-Q42]

検証済みの1z1-909試験問題集PDF [2023年最新] 成功の秘訣はここにある

ベストを体験せよ！1z1-909試験問題トレーニングを提供していますFast2test

Oracle 1z1-909 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Analyze queries for optimization Aggregate and summarize data Data-driven Applications
トピック 2	Create and execute stored routines MySQL Schema Objects and Data
トピック 3	Use MySQL Shell to access document stores Retrieve data from the database by using a connector
トピック 4	Explain application development with NoSQL and XDevAPI Handle and interpret errors and warnings
トピック 5	Understand locking mechanisms within MySQL Control transactions in applications
トピック 6	Resolve consistency problems with isolation levels Set SQL Modes to change MySQL behavior
トピック 7	Demonstrate connector use, management and configuration Secure credentials and connections
トピック 8	Store and process spatial data Design, create, and alter views
トピック 9	Rewrite queries for optimization Store and process string data

質問 22
Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

A. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;
B. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
C. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
D. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
E. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

正解: A,E

質問 23
Examine the content of the employee table:

Now examine this PHP script:

Finally examine this desired output:

A. $options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;
B. $options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;
C. $options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;
D. $options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;

正解: A

質問 24
Which two are true about MySQL connectors?

A. Connectors must be installed on both the client and server hosts.
B. Connector/NET runs on the Windows platform only.
C. Connector/J is based on Connector/C.
D. Connector/Python is released in precompiled binary and source code.
E. Connector/ODBC is available on Unix, Windows, and MacOS X.

正解: A,C

質問 25
Examine this statement:

A. Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement
B. user who creates the procedure needing the create routine privilege
C. user who creates the procedure needing the create and execute privileges
D. Inserting COMMIT; SET @m :=: before line 4
E. inserting USE <database >; before line 3

正解: A

質問 26
A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

A. The X Dev API protocol must be enabled to use sockets in Connector/J driver.
B. The socket is not implemented in Connector/J driver.
C. socket is a reserved word in Java.
D. Java treats the socket file as insecure.
E. The socket can only be accessed from the local host.

正解: B,D

質問 27
Examine this statement which has executed successfully:

A. No index will improve statement performance.
B. Execution performance can be improved by using like instead of RLIKE.
C. Execution performance can be improved by adding an index on column description.
D. The statement takes advantage of index description_idx.
E. Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

正解: B

質問 28
Examine this event's metadata:

Now examine this command:
DROP USER 'userl'e'localhost';
Which effect will the command have on the event?

A. The event will be dropped without an error or warning.
B. The event is scheduled but will no longer execute. The system will log an error.
C. The event is scheduled and executed but fails. The system will log an error.
D. The event is not scheduled and will no longer execute. The system will log an error.

正解: B

質問 29
Which two statements are true about AUTO_INCREMENT?

A. AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.
B. The decimal data type supports AUTO_INCREMENT.
C. An AUTO_INCREMENT column must be indexed.
D. A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.
E. A table can have multiple AUTO_INCREMENT columns.

正解: A,C

質問 30
Which select statement returns true?

A. SELECT NULL := NULL;
B. SELECT NULL <=> NULL;
C. SELECT NULL <> NULL;
D. SELECT NULL = NULL;

正解: B

質問 31
Which change will prevent negative ages to be inserted into the people table?

A. DELIMITER //
CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;
B. DELIMITER //
CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;
C. ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);
D. ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

正解: C

質問 32
Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

A. log_queries_not_using_indexes
B. log_throttle_queries_not_using_indexes=100
C. log_queries_not_using_indexes=ON
D. log__slow_admin_statements=1

正解: D

質問 33
Examine these lines of Python code:

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

A. d = cursor.fetchall(query, (hire_start, hire_end))
B. d = cursor.fetch(query, (hire_start, hire_end))
C. d = cursor.execute(query, (hire_start, hire_end) )
D. d = cursor.execute(query)
E. d = cursor.fetch(query % (hire_start, hire_end))
F. d = cursor . f etchall (query)

正解: B

質問 34
Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

A. SELECT 'Car' RLIKE 'Ca?' INTO @r;
B. SELECT 'Car' LIKE 'Ca?' INTO @r;
C. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;
D. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

正解: A

質問 35
Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)

D)

A. Option B
B. Option D
C. Option C
D. Option A

正解: B

質問 36
Which select statement returns true?

A. SELECT NULL <=> NULL;
B. SELECT NULL <> NULL;
C. SELECT NULL = NULL;
D. SELECT NULL := NULL;

正解: D

質問 37
Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?

A. The inserted row is not returned because the isolation level is READ COMMITTED in S2.
B. The inserted row is returned because the transaction is auto committed in S2.
C. The inserted row is returned because the isolation level is RPEATABLE READ in S1.
D. The inserted row is not returned because the transaction still active in s2.

正解: B

質問 38
Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?
A)

B)

D)

E)

A. Option B
B. Option C
C. Option A
D. Option D
E. Option E

正解: A,B

質問 39
You must reclaim memory used by a prepared statement named prep. Which two achieve this?

A. DROP PROCEDURE prep;
B. SET @a = ''; EXECUTE prep USING @a;
C. PREPARE prep FROM '';
D. SET @prep = NULL;
E. DROP PREPARE prep;
F. DEALLOCATE PREPARE prep?

正解: A,D

質問 40
Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

A. The json_extract() function requires a length value that matches the field length in the schema.
B. The select requires json_unquoteo in the where clause.
C. The JSON datatype cannot be used in virtual columns.
D. The virtual values in the name column must be accessed using functions.
E. Table statistics must be updated to generate values for the name column.

正解: C

質問 41
Examine these statement which execute successfully:

Now, examine the statements executed in the mysqi command-line client:

What is true?
A)

B)

C)

D)