Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-909 - MySQL 8.0 Database Developer

Oracle 1z0-909 Premium Access     Download Demo    
Page: 2 / 2
Total 65 questions

Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?

A.

ALTER TABLE appointments add index IX_4

B.

ALTER TABLE appointments add index IX_1(credit,payment)

C.

ALTER TABLE appointments add index IX_2(attendant_session_id, created_by)

D.

ALTER TABLE appointments add index IX_3(attendant_id, created_by)

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

Which two statements would generate this bar graph?

A.

SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

B.

SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

C.

SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

D.

SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

E.

SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Examine this statement and output:

Now, examine these desired output values:

Which statement updates the table data as require

A.

UPDATE exam_result SET score=TRUNCATE

B.

UPDATE examresult SET score=ROUND(CEIL(score

C.

UPDATE exam_result SET score=CEIL(TRUNCATE(sco

D.

UPDATE exam_result SET score=CEIL(ROUND(score,1));

E.

UPDATE exam_result SET score=ROUND(score,1);

F.

UPDATE exam_result SET score=TRUNCATE(score,1);

Your program which uses a MySQL connector receives this error:

Client does not support authentication protocol request by server

The account running the program uses caching_sha2_password.

Which two resolve this conflict?

A.

Disable TLS/SSL authentication.

B.

Place this in the root directory of your shell account:

[mysqld] require__secure_transport=OFF

C.

Use blank RSA or SSL certificates.

D.

Upgrade the connector to a version that supports caching_sha2_password.

E.

Change the user account to use mysql_native_password.

Examine the employee table structure:

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

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Which two are true about indexes?

A.

Secondary index access will always be faster than a table scan.

B.

Indexing all of a table's columns improves performance.

C.

Indexes contain rows sorted by key values.

D.

Indexes reduce disk space used.

E.

Indexes are used to enforce unique constraints.

Examine this statement which executes successfully:

SET @ir := 2;

Which query updates the value of @r to 0?

A.

SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

B.

SELECT STRCMP(‘Car'/Ca?') >= 0 INTO @r;

C.

SELECT 'Car' LIKE 'Ca?' INTO @r;

D.

SELECT 'Car' RLIKE 'Ca?' INTO @r;

Examine these commands and output:

Which is true about the execution of the insert statement?

A.

It returns an error.

B.

It inserts a row in the view and base table.

C.

It inserts a new row in the base table only.

D.

It inserts a new row in the view only.

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?

A.

No transaction commits.

B.

One row is inserted into band.

C.

Two transactions commit.

D.

No row is inserted into band.

E.

The transaction is rolled back to the savepoint.