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

A.

B.

C.

D.

A. 0

B. -1

C. NULL

D. ERROR: 1267 (HYOOO): Illegal mix of collations

E. 1

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

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

C. No index will improve statement performance.

D. The statement takes advantage of index description_idx.

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

A. SELECT 'Car' RLIKE 'Ca?' INTO @r;

B. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

C. SELECT 'Car' LIKE 'Ca?' INTO @r;

D. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

A. db . country. Select ([Name' , 'Population.'] ) -limit (5) .where('Name LIKE "United%"')

B. db . country. fields ( [ ' Name ' , 'Population']) . select (' limit=5 ' ) .where('Name LIKE "United%" ' )

C. db . country, select ( [ ' Name LIKE "united%" ' , ' Population>^0 ' ] ) - limit (5)

D. db.country. fields ( [ 'Name ' , 'Population* ] ) .where ( 'Name LIKE "United%',,) -select ()-limit(5)

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

A. The set local_infile option has not been enabled.

B. The database server is running in read-only mode.

C. The database client process does not have sufficient privilege.

D. The database server process does not have sufficient privilege.

E. The engine is disabled.

F. The database user does not have sufficient privilege.

A. The statement will wait for the transaction in Session 1 to finish.

B. The row will be updated immediately.

C. A deadlock will occur.

D. The transaction in Session 1 will be rolled back automatically.