Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-909 - MySQL 8.0 Database Developer

Oracle 1z0-909 Premium Access     Download Demo    
Page: 1 / 2
Total 65 questions

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

A.

mysqli supports object oriented programming.

B.

mysqli can access databases from other vendors.

C.

mysqli supports non blocking, asynchronous queries.

D.

mysqli includes X DevAPI functions.

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

A.

log_queries_not_using_indexes

B.

log__slow_admin_statements=1

C.

log_queries_not_using_indexes=ON

D.

log_throttle_queries_not_using_indexes=100

Examine this statement and output:

Which is true?

A.

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

B.

myview cannot be automatically indexed.

C.

myview was defined with the temptable processing algorithm.

D.

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

Examine this table definition:

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

A.

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

B.

The column must have a default value.

C.

The column must be used in a unique constraint.

D.

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

E.

The column must be indexed.

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)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

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?

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.

Examine the layout of the my_values table.

Examine the data in the my_value3 table.

Examine this statement:

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

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

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.

Examine these commands and output:

Which is true?

A.

Existing emp_vuL is dropped and a new emp_vu1 created with the new definition.

B.

A new view is created because the previous was dropped on execution of the drop table statement.

C.

It returns an error because the CREATE TABLE statement automatically recreated the view.

D.

It returns an error because the DROP TABLE statement did not drop the view.

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?

A.

d = cursor.execute(query)

B.

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

C.

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

D.

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

E.

d = cursor . f etchall (query)

F.

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