Summer Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Certensure Logo
  1. Home
  2. Oracle
  3. MySQL Developer
  4. 1z0-909 - MySQL 8.0 Database Developer

Oracle 1z0-909 MySQL 8.0 Database Developer Exam Practice Test

Demo: 9 questions
Total 65 questions
Get 1z0-909 Full Access Download 1z0-909 PDF

MySQL 8.0 Database Developer Questions and Answers

Question 1

Examine this statement and output:

You execute this statement:

SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;

What is the output?

Options:

A.

product->''$.varieties [4]. origin[1];;

B.

''$.varieties[4]. origin[1]''

C.

product->varieties[3]. origin[0]''

D.

''$.varieties [3]. origin[0]''

Question 2

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

Options:

A.

SET @a = ''; EXECUTE prep USING @a;

B.

DEALLOCATE PREPARE prep?

C.

DROP PROCEDURE prep;

D.

SET @prep = NULL;

E.

DROP PREPARE prep;

F.

PREPARE prep FROM '';

Question 3

Which two are true about MySQL connectors?

Options:

A.

Connectors must be installed on both the client and server hosts.

B.

Connector/J is based on Connector/C.

C.

Connector/ODBC is available on Unix, Windows, and MacOS X.

D.

Connector/NET runs on the Windows platform only.

E.

Connector/Python is released in precompiled binary and source code.

Question 4

The employee table includes these columns:

e_id INT, e_name VARCHAR (45), dept_id INT salart INT

You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.

Which statement will create the function?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 5

Which select statement returns true?

Options:

A.

SELECT NULL <> NULL;

B.

SELECT NULL <=> NULL;

C.

SELECT NULL = NULL;

D.

SELECT NULL := NULL;

Question 6

Examine the Test.php script which is numbered for clarity, and its output:

PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2

Which action will fix this error?

Options:

A.

Enable the mysqli extension in the php.ini file.

B.

Replace line 2 with Slink = mysql.connect {"localhost: 3306n, "username", "pas "schema") ;

C.

Replace line 2 With: Slink = mysql_xdevapi\getSession

("mysqlx://username:password@localhost:3306","schema");

D.

Install the PHP executable in the path used by the MySQL installation.

Question 7

Examine these commands and output:

Which is true about the execution of the insert statement?

Options:

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.

Question 8

Examine this statement that execute successfully in an interactive session:

The user running this session now goes to lunch for an hour.

Now, examine these statements executed independently in separate sessions while Session 0 is still active:

How many of them will complete while Session 0 is still active?

Options:

A.

5

B.

1

C.

2

D.

0

E.

3

F.

4

Question 9

You must write a statement that combines the first_name and last_name columns from the

employees table as "last_name, first_name."

Which two statements will do this?

Options:

A.

SELECT last_name + ', ' + first_name FROM employees;

B.

SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;

C.

SELECT GROUP_CONCAT(last_name, first_name) FROM employees;

D.

SELECT last_name, ‘ , ',first_name FROM employees;

E.

SELECT CONCAT(last name,', ',first_name) FROM employees;

Load More 1z0-909 Questions
Demo: 9 questions
Total 65 questions
Get 1z0-909 Full Access Download 1z0-909 PDF