1z1-909 Exam Training Practice Tests (Oracle MySQL 8.0 Database Developer)]

Question 1

You must enforce data integrity for data Inserted in a JSON column.
Which statement successfully creates a constraint in a 3SON column?

A. CREATE TABLE fshop (product JSON CHECK (JSON_VALID(product) ) ) ; B. CREATE TABLE fshop (id INT NOT NULL AUTOINCREMENT, product JSON, PRIMARY KEY (id)) ENGINE=InnoDB; C. CREATE TABLE fshop (id INT NOT NULL AUTO_ INCREMENT, product JSON, CHECK (id>0) ) ENGXNE=InnoDB; D. CREATE TABLE fshop ( product JSON, f INT' GENERATED ALWAYS AS (product->"S - id") ) ;

Correct Answer: B

Question 2

Which two are true about MySQL connectors?

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

Correct Answer: B,E

Question 3

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 is not scheduled and will no longer execute. The system will log an error. B. The event will be dropped without an error or warning. C. The event is scheduled and executed but fails. The system will log an error. D. The event is scheduled but will no longer execute. The system will log an error.

Correct Answer: D

Question 4

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

A. Results are sent to the calling PHP process for buffering. B. Buffered queries must be explicitly enabled using mysqliuseresult. C. Additional queries on the same session are blocked until the result set is released. D. Buffered queries are enabled by default. E. Results are sent from the server to the browser for buffering. F. Buffered queries should be used on large tables when the result size is unknown. G. Large results can have a negative impact on performance.

Correct Answer: B,F,G

Question 5

What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?

A. mysqli includes X DevAPI functions. B. mysqli supports non blocking, asynchronous queries. C. mysqli can access databases from other vendors. D. mysqli supports object oriented programming.

Correct Answer: D

Question 6

Examine these commands and output:

Which is true?

A. A new view is created because the previous was dropped on execution of the drop table statement. B. It returns an error because the DROP TABLE statement did not drop the view. C. Existing emp_vuL is dropped and a new emp_vu1 created with the new definition. D. It returns an error because the CREATE TABLE statement automatically recreated the view.

Correct Answer: B

Question 7

Examine this statement and output:

What causes the error?

A. The engine is disabled. B. The database client process does not have sufficient privilege. C. The database server is running in read-only mode. D. The set local_infile option has not been enabled. E. The database user does not have sufficient privilege. F. The database server process does not have sufficient privilege.

Correct Answer: F

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