[Sep 02, 2022] Lesson Brilliant PDF for the 1z1-909 Tests Free Updated Today [Q29-Q53]

5/5 - (2 votes)

[Sep 02, 2022] Lesson Brilliant PDF for the 1z1-909 Tests Free Updated Today

Get New 2022 Valid Practice MySQL Developer 1z1-909 Q&A – Testing Engine

Oracle 1z1-909 Exam Syllabus Topics:

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

NO.29 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?

NO.30 Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

NO.31 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.

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

mysqli supports object oriented programming.

mysqli can access databases from other vendors.

mysqli supports non blocking, asynchronous queries.

mysqli includes X DevAPI functions.

NO.33 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.

NO.34 Examine these commands and output:

Which is true about the execution of the insert statement?

It returns an error.

It inserts a row in the view and base table.

It inserts a new row in the base table only.

It inserts a new row in the view only.

NO.35 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] ;

NO.36 Examine this statement and output:

Which will provide the same level of detail when the error is encountered within a stored routine?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

NO.37 Examine these statement which execute successfully:

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

What is true?

NO.38 Examine this SQL statement:

db.country. fields ( [ ‘Name ‘ , ‘Population* ] ) .where ( ‘Name LIKE “United%’,,) -select ()-limit(5)

db . country, select ( [ ‘ Name LIKE “united%” ‘ , ‘ Population>^0 ‘ ] ) – limit (5)

db . country. fields ( [ ‘ Name ‘ , ‘Population’]) . select (‘ limit=5 ‘ ) .where(‘Name LIKE “United%” ‘ )

db. country-select([‘Name’,’Population’]) .where(‘Name LIKE :param’) -bind (‘param’ , ‘United*’) -limit(5)

db . country. Select ([Name’ , ‘Population.’] ) -limit (5) .where(‘Name LIKE “United%”‘)

NO.39 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”.

NO.40 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.

NO.41 Examine the employee table structure:

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

D)

Option A

Option B

Option C

Option D

NO.42 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.

NO.43 Which two statements are true about aggregate functions?

SUM () returns o if there are no rows to aggregate.

MAX () returns null if there are no rows to aggregate.

COUNT (distinct) returns a count of the number of rows with different values including Null.

MIN () cannot use distinct when it executes as a Windows function.

AVG () does not allow use of the distinct option.

NO.44 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;

NO.45 Which statement is true about the show errors command?

It displays the total number of errors, warnings, and notes since the beginning of the current session.

It displays the total number of errors, warnings, and notes since the server last restarted.

It cannot display information for more than max_errot_count server system variable setting.

It displays errors messages only, since the start time of the current session.

It displays errors messages only, since the server last restarted.

It displays similar diagnostics results as get diagnostics.

NO.46 Examine these statements which execute successfully:

Which two changes will improve this query performance?

CREATE INDEX 1X7 ON users (user_name) USING HASH;

CREATE INDEX 1X4 ON Locations (site_id, loc_shared);

CREATE INDEX IX1 ON locations (loc_shareci) ;

CREATE INDEX 1X6 ON users (user_name);

CREATE INDEX 1X3 ON locations <loc_site_id) ;

CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH

CREATE INDEX 1X5 ON users (loc_id);

NO.47 Which two are true about indexes?

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

Indexing all of a table’s columns improves performance.

Indexes contain rows sorted by key values.

Indexes reduce disk space used.

Indexes are used to enforce unique constraints.

NO.48 Examine this table definition:

The table must always remain a valid document store collection. What restriction does this impose on any added column?

The column must be a generated column referencing any attribute of doc.

The column must have a default value.

The column must be used in a unique constraint.

The column must be a generated column referencing only an existing attribute of doc.

The column must be indexed.

NO.49 Examine this statement which has executed successfully:

Execution performance can be improved by using like instead of RLIKE.

The statement takes advantage of index description_idx.

Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

No index will improve statement performance.

Execution performance can be improved by adding an index on column description.

NO.50 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?

SELECT last_name + ‘, ‘ + first_name FROM employees;

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

SELECT GROUP_CONCAT(last_name, first_name) FROM employees;

SELECT last_name, ‘ , ‘,first_name FROM employees;

SELECT CONCAT(last name,’, ‘,first_name) FROM employees;

NO.51 Examine the output:

Which explain command will obtain the output?