New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. MySQL Developer
  4. 1z0-909
  5. 1z0-909 - MySQL 8.0 Database Developer

Oracle 1z0-909 MySQL 8.0 Database Developer Exam Practice Test

Page: 1 / 7
Total 65 questions
Get 1z0-909 Full Access Download 1z0-909 PDF

MySQL 8.0 Database Developer Questions and Answers

Question 1

Examine the structure of the emp table:

Question # 1

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

Question # 1

Now, examine this statement:

mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;

What is true about executing the statement?

Options:

A.

It inserts a row in the emp table.

B.

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

C.

It inserts a row in the view only.

D.

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

Question 2

Examine this event's metadata:

Question # 2

Now examine this command:

DROP USER 'userl'e'localhost';

Which effect will the command have on the event?

Options:

A.

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

B.

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

C.

The event will be dropped without an error or warning.

D.

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

Question 3

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?

Options:

A.

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

B.

Execution succeeds with a warning.

C.

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

D.

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

Question 4

Examine these statements and output:

Question # 4

Now, examine this command:

Mysql> ROLLBACK;

What is true about the effect of the command?

Options:

A.

It undoes the update command.

B.

It returns an error because there is no active transaction.

C.

It undoes the insert command.

D.

It undoes both insert and update commands.

E.

It has no effect.

Question 5

Examine this statement and output:

Question # 5

Now, examine these desired output values:

Question # 5

Which statement updates the table data as require

Options:

A.

UPDATE exam_result SET score=TRUNCATE

B.

UPDATE examresult SET score=ROUND(CEIL(score

C.

UPDATE exam_result SET score=CEIL(TRUNCATE(sco

D.

UPDATE exam_result SET score=CEIL(ROUND(score,1));

E.

UPDATE exam_result SET score=ROUND(score,1);

F.

UPDATE exam_result SET score=TRUNCATE(score,1);

Question 6

Which two differences exist between the timestamp and date time data types?

Options:

A.

timestamp has larger range of values.

B.

timestamp uses less storage space.

C.

timestamp stores more decimal points in seconds

D.

timestamp converts the value based on the session time zone.

E.

timestamp stores the interval between two dates.

Question 7

Examine this statement:

Question # 7

Options:

A.

Inserting COMMIT; SET @m :=: before line 4

B.

user who creates the procedure needing the create and execute privileges

C.

user who creates the procedure needing the create routine privilege

D.

inserting USE ; before line 3

E.

Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement

Question 8

Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Question # 8

Now, examine this statement that execute successfully in s1:

S1> SELECT * FROM emp;

Which is true about the result of the select statement?

Options:

A.

The inserted row is returned because the transaction is auto committed in S2.

B.

The inserted row is not returned because the isolation level is READ COMMITTED in S2.

C.

The inserted row is not returned because the transaction still active in s2.

D.

The inserted row is returned because the isolation level is RPEATABLE READ in S1.

Question 9

Examine the appointments table definition which contains one million rows:

Question # 9

Now, examine this statement which executes successfully:

Question # 9

Which statement will improve query performance?

Options:

A.

ALTER TABLE appointments add index IX_4

B.

ALTER TABLE appointments add index IX_1(credit,payment)

C.

ALTER TABLE appointments add index IX_2(attendant_session_id, created_by)

D.

ALTER TABLE appointments add index IX_3(attendant_id, created_by)

Load More 1z0-909 Questions 
Page: 1 / 7
Total 65 questions
Get 1z0-909 Full Access Download 1z0-909 PDF