1Z0-909 Questions Pass on Your First Attempt Dumps for MySQL Developer Certified [Q26-Q40]

NO.26 Examine this statement which executes successfully:
CREATE TABLE ‘fshop’ (‘product’ JSON DEFAULT NULL ) ENGINE=InnoDB;
Now, examine a json value contained in the table:
{“name” : “orange”, “varieties” : [{“VarietyName”:”Clementine”, “Origin” : [“PA”, “BU”] }, {“VarietyName”: “tangerine”, “Origin” : [“CH”,”JP”]>]> Which will cause documents to be indexed over the ‘name’ key?

ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product-
>* S .varieties. VarietyName ‘ ) VIRTUAL, ADD KEY idx_name (name.) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->’ S – varieties’ ) VIRTUAL, ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->’ S – name’ ) VIRTUAL, ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;

ALTER TABLE fshop ADD name VARCHAR(20) AS (JSON_ONQUOTE (product->”S.varieties.VarietyName”)), ADD INDEX (name);

NO.27 Examine this event’s metadata:

Now examine this command:
DROP USER ‘userl’e’localhost’;
Which effect will the command have on the event?

The event is scheduled and executed but fails. The system will log an error.

The event is scheduled but will no longer execute. The system will log an error.

The event will be dropped without an error or warning.

The event is not scheduled and will no longer execute. The system will log an error.

NO.28 Examine this statement and output:

You execute this statement:
SELECT JSON_SEARCH(product,’one’,’IT’) FROM fshop ;
What is the output?

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

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

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

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

NO.29 Examine this statement and output:

Which is true?

The underlying table’s index on the Name column is not chosen because of low selectivity.

myview cannot be automatically indexed.

myview was defined with the temptable processing algorithm.

Column Name in myview can be indexed if the is_updatable attribute is true.

NO.30 Which change will prevent negative ages to be inserted into the people table?

DELIMITER //
CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER ;

ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

DELIMITER //
CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN SET NEW.age =0; END IF;// DELIMITER;

ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

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

SELECT doc->”$.name” FROM col WHERE doc->”$.season” = “1”;

SELECT “S.name” FROM col WHERE “S.season” = “1”;

SELECT doc->,$.name,, FROM col WHERE doc->”$ . season” = “1”;

SELECT name FROM col WHERE season = 1;

NO.32 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)

Option A

Option B

Option C

Option D

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

NO.34 Which two statements are true about AUTO_INCREMENT?

AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

A table can have multiple AUTO_INCREMENT columns.

A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

The decimal data type supports AUTO_INCREMENT.

An AUTO_INCREMENT column must be indexed.

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 these lines of Python code:

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

d = cursor.execute(query)

d = cursor.execute(query, (hire_start, hire_end) )

d = cursor.fetch(query % (hire_start, hire_end))

d = cursor.fetch(query, (hire_start, hire_end))

d = cursor . f etchall (query)

d = cursor.fetchall(query, (hire_start, hire_end))

NO.37 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.38 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?

start_time TIMESTAMP duration TIMESTAMP

start_time TIMESTAMP duration TIME

start_time DATETIME duration DATETIME

start_time TIME duration TIME

start__time DATETIME duration TIME

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

1Z0-909 Questions Pass on Your First Attempt Dumps for MySQL Developer Certified [Q26-Q40]

Leave a Reply Cancel reply

1Z0-909 Practice Tests

Related Certifications

Recent Posts

Categories

Archives