Best Preparations of 1z1-909 Exam 2023 MySQL Developer Unlimited 66 Questions [Q10-Q32]

Rate this post

Best Preparations of 1z1-909 Exam 2023 MySQL Developer Unlimited 66 Questions

Focus on 1z1-909 All-in-One Exam Guide For Quick Preparation.

Oracle 1z1-909 Exam Syllabus Topics:

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

QUESTION 10
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?

The X Dev API protocol must be enabled to use sockets in Connector/J driver.

The socket is not implemented in Connector/J driver.

The socket can only be accessed from the local host.

socket is a reserved word in Java.

Java treats the socket file as insecure.

QUESTION 11
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?

Enable the mysqli extension in the php.ini file.

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

Replace line 2 With: Slink = mysql_xdevapigetSession
(“mysqlx://username:password@localhost:3306″,”schema”);

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

QUESTION 12
Examine the structure of the emp table:

Examine the structure of the emp_vu1 view based on the emp table:

Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES (‘Alice’,20000) ;
What is true about executing the statement?

It inserts a row in the emp table.

It returns an error because an insert operation is not allowed on views.

It inserts a row in the view only.

It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.

QUESTION 13
Examine these statements and output:

Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?

It undoes the update command.

It returns an error because there is no active transaction.

It undoes the insert command.

It undoes both insert and update commands.

It has no effect.

QUESTION 14
Examine these statement which execute successfully:

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

What is true?

QUESTION 15
Examine these MySQL Shell statements:

What is the true about the attempts to add document to the collection?

All documents are added without any error or warning.

First three documents are added, then different number of fields cause an error.

First two documents are added, then mismatched field names cause an error.

First two documents are added, then mismatched field names cause a warning.

All documents are added and cause a warning.

QUESTION 16
Examine these commands and output:

Which is true?

Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

A new view is created because the previous was dropped on execution of the drop table statement.

It returns an error because the CREATE TABLE statement automatically recreated the view.

It returns an error because the DROP TABLE statement did not drop the view.

QUESTION 17
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?

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

Which two statements would generate this bar graph?

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

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

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

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

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

QUESTION 19
Which two are true about MySQL Document Store?

It helps to store data items in a schema-less key-value store.

It can store documents greater than 4 GB.

It depends heavily on strictly typed data.

It allows one to bypass the SQL layer of the server.

There is no access to relational tables.

QUESTION 20
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?

An error is generated because srid o is an invalid identifier value.

Execution succeeds with a warning.

An error is generated because the index prevents changes to the column.

Execution succeeds and allows the use of the index by the optimizer.

QUESTION 21
Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O’Hagen
* birthdate = November 26, 1997
* reg_date = the current date

Change DATE () to DAY ().

Change “O’Hagen” to ‘o’Hagen’.

Change date () to CURRENT_TIMESTAMP () .

Change ” NULL ” to NULL.

Change ” NULL ” to ‘ NULL ‘ .

Change “O’Hagen” to “O’Hagen”.

QUESTION 22
Examine the output:

Which explain command will obtain the output?

EXPLAIN ANALYZE

EXPLAIN PARTITIONS

EXPLAIN FORMAT=TREE

EXPLAIN PORMAT^TRADITIONAL

EXPLAIN PORMAT=JSON

QUESTION 23
Examine these statements which execute successfully:

Now, examine this query:

What is the result?

It inserts a row with a warning.

It inserts a row with no error or warning.

It inserts a row with an error.

It fails with an error.

It fails with a warning.

QUESTION 24
Examine these commands and output:

Which is true?

Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

A new view is created because the previous was dropped on execution of the drop table statement.

It returns an error because the CREATE TABLE statement automatically recreated the view.

It returns an error because the DROP TABLE statement did not drop the view.

QUESTION 25
Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?

The trigger activates after any row has been inserted into the table.

The trigger body set causes trigger activation.

The trigger activates after any row in the table has been updated.

Execution of an insert statement causes the trigger to activate.

QUESTION 26
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?

Enable the mysqli extension in the php.ini file.

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

Replace line 2 With: Slink = mysql_xdevapigetSession
(“mysqlx://username:password@localhost:3306″,”schema”);

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

QUESTION 27
Examine the content of the employee table:

Now examine this PHP script:

Finally examine this desired output:

$options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;

$options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;

$options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;

$options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;

QUESTION 28
Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

log_queries_not_using_indexes

log__slow_admin_statements=1

log_queries_not_using_indexes=ON

log_throttle_queries_not_using_indexes=100

QUESTION 29
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?

Disable TLS/SSL authentication.

Place this in the root directory of your shell account:
[mysqld] require__secure_transport=OFF

Use blank RSA or SSL certificates.

Upgrade the connector to a version that supports caching_sha2_password.

Change the user account to use mysql_native_password.

QUESTION 30
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?

QUESTION 31
Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?