Oracle MySQL 8.0 Database Developer - 1z1-909 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Examine this SQL statement:

A. db. country-select(['Name','Population']) .where('Name LIKE :param') -bind ('param' , 'United*') -limit(5) B. db.country. fields ( [ 'Name ' , 'Population* ] ) .where ( 'Name LIKE "United%',,) -select ()-limit(5) C. db . country. fields ( [ ' Name ' , 'Population']) . select (' limit=5 ' ) .where('Name LIKE "United%" ' ) D. db . country, select ( [ ' Name LIKE "united%" ' , ' Population>^0 ' ] ) - limit (5) E. db . country. Select ([Name' , 'Population.'] ) -limit (5) .where('Name LIKE "United%"')

Discussion 0

Correct Answer: A Vote an answer

Question 2

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?

A. start_time DATETIME duration DATETIME B. start_time TIME duration TIME C. start_time TIMESTAMP duration TIME D. start_time TIMESTAMP duration TIMESTAMP E. start__time DATETIME duration TIME

Discussion 0

Correct Answer: A Vote an answer

Question 3

Examine this statement and output:

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

A. ''$.varieties [3]. origin[0]'' B. product->varieties[3]. origin[0]'' C. ''$.varieties[4]. origin[1]'' D. product->''$.varieties [4]. origin[1];;

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

Which two statements would generate this bar graph?

A. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC; B. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC; C. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC; D. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC; E. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?

A. ALTER TABLE appointments add index IX_3(attendant_id, created_by) B. ALTER TABLE appointments add index IX_2(attendant_session_id, created_by) C. ALTER TABLE appointments add index IX_1(credit,payment) D. ALTER TABLE appointments add index IX_4<attendant_id, payment, credit)

Discussion 0

Correct Answer: D Vote an answer

Question 6

Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

A. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r; B. SELECT 'Car' RLIKE 'Ca?' INTO @r; C. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r; D. SELECT 'Car' LIKE 'Ca?' INTO @r;

Discussion 0

Correct Answer: B Vote an answer

Question 7

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?

A. Execution of an insert statement causes the trigger to activate. B. The trigger body set causes trigger activation. C. The trigger activates after any row has been inserted into the table. D. The trigger activates after any row in the table has been updated.

Discussion 0

Correct Answer: A Vote an answer