1Z0-909.pdf
Q: 1
You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?
Options
Q: 2
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?
Options
Q: 3
The collection col contains all episodes for all seasons for a TV show.
Examine this document which has an example of the details for each episode:
Which query returns all expisode names from the first season?
Which query returns all expisode names from the first season?Options
Q: 4
Examine this statement which has executed successfully:
Options
Q: 5
Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT
STRCMPCAlice',
UCASE ('Alice* )) ;
What is displayed?
Options
Q: 6
The continent column in the country table contains no null values.
Examine this output:
A)
B)
C)
D)
A)
B)
C)
D)
Options
Q: 7
Examine this event's metadata:
Now examine this command:
DROP USER
'userl'e'localhost';
Which effect will the command have on the event?
Now examine this command:
DROP USER
'userl'e'localhost';
Which effect will the command have on the event?Options
Q: 8
Examine these commands and output:
Which is true?
Which is true?Options
Q: 9
Which select statement returns true?
Options
Q: 10
The meeting table stores meeting schedules with participants from five continents. The participants'
details are stored in another table.
You need to adjust the start_time and duration columns for optimal storage. What datatype changes
would achieve this?
You need to adjust the start_time and duration columns for optimal storage. What datatype changes
would achieve this?Options
Question 1 of 10
