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

1z0-882 Questions and Answers

Note! Following 1z0-882 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-882 Questions and Answers

Question # 6

Which statement is true about the difference between HASH and BTREE INDEXES?

A.

HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.

B.

HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.

C.

HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can also be used for range searches (>or<).

D.

HASH indexes are much faster than BTREE indexes but can only be used for a single column.

Full Access
Question # 7

You are connected to a MySQL server and using a prepared statement. You accidentally exit your session.

What will happen if you log back in to use your prepared statement?

A.

The statement exists, but will need to be deallocated and re-created.

B.

The statement exists, but the user variables need to be redefined.

C.

The statement can be used, if the MySQL server hasn’t been restarted.

D.

The statement no longer exists.

Full Access
Question # 8

Which three database objects have non-case-sensitive names on all operating system?

A.

Table

B.

Column

C.

Index

D.

Stored procedure

E.

Trigger

Full Access
Question # 9

Which statement describes the process of normalizing databases?

A.

All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.

B.

Redundant tables are combined into one larger table to simplify the schema design.

C.

Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.

D.

Columns that contain repeating data values are split into separate tables to reduce item duplication.

E.

Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.

Full Access
Question # 10

A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.

You execute this query:

SELECT col1 FROM t1 WHERE col1< 100

UNION

SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200

UNION ALL

SELECT col1 FROM t1 WHERE col 1 >=900

What is the output?

A.

A list of unique values within the ranges of 1-200 and 900-1000

B.

A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the range of 900-1000

C.

A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000

D.

A list of all values, including duplicates, in the ranges of 1-200 and 900-1000

E.

An error, because mixing UNION and UNION ALL in the same query is not permitted

Full Access
Question # 11

As a developer, you inherit this table as part of a project:

CREATE TABLE exam (

Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,

Examinee_id INTEGER UNSIGNED UNIQUE,

Score INTEGER UNSIGNED

)

What change should you make to ensure that examinee_id is an integer value throughout the table?

A.

The examinee_id column should be designated as PRIMARY KEY.

B.

A NOT NULL qualifier should be moved from exam-id to examinee-id.

C.

The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).

D.

A NOT NULL qualifier should be added to examinee_id.

Full Access
Question # 12

You want to use the SHA -256 Authentication plugin with Connector/J.

Which two parameter settings achieve this?

A.

Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc

B.

Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin

C.

defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

D.

defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin

Full Access
Question # 13

Using the MYSQL command –line client you have received the error “Lost connection to MYSQL server query”

Which three are possible causes of the error?

A.

The MYSQL server stopped working during query execution.

B.

The network connection was interrupted during query execution.

C.

The connection that issued the query was killed.

D.

The client connection stayed idle for longer than interactive –timeout seconds and was closed.

E.

The client sent an erroneous query to the server causing the connection to be closed.

F.

The server interrupted client connection after max-connect-errors was achieved.

Full Access
Question # 14

What is true about the contents of the INFORMATION_SCHEMATA table?

A.

It contains information about the table structure for all databases.

B.

It contains information about all the tables, triggers, and views for all databases.

C.

It contains information such as name, character set, and collation for all the databases on the server.

D.

It contains information including tables, trigger, stored routines, and views for all databases

Full Access
Question # 15

The application logs contain many entries of the following:

ERROR 1153 (OSSO1): Got a packet bigger than ‘max_allowed_packet’ bytes

With two scenarios can (Hibernate this error message?

A.

The application tried to INSERT a row that exceeded max_allowed_packet.

B.

The network caused an error Inducing the max_allowed_packet error.

C.

The application did not use the COMPRESS () function for a large result set.

D.

The application tried to SELECT many rows together that exceeded max__allowed_packet.

E.

The application tried to SELECT a row that exceeded max_allowed_packet.

F.

The operating system caused an error inducing the max_allowed_packet error.

Full Access