Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Dumpsbuddy Logo
  1. Home
  2. Oracle
  3. MySQL Developer
  4. 1z0-882
  5. Oracle Certified Professional, MySQL 5.6 Developer Questions and Answers
Note! Oracle has retired the 1z0-882 Exam Contact us through Live Chat or email us for more information.

1z0-882 Oracle Certified Professional, MySQL 5.6 Developer Questions and Answers

Questions 4

You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables.

Which query accomplishes this?

Options:

A.

SELECT * FROM tableA. tableB

B.

SELECT * FROM tableA JOIN tableB

C.

SELECT * FROM table A INNER JOIN tableB

D.

SELECT * FROM tableA NATURAL JOIN tableB

E.

SELECT & FROM tableA STRAIGHT JOIN tableB

Buy Now
Questions 5

Given the data from table t1:

This DELETE command is executed:

DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;

Which set of rows will be deleted by the command?

Options:

A.

(7,1) and (1,4)

B.

(2,8) and (1,4)

C.

(7,1) and (10,8)

D.

(2,8) and (10,8)

Buy Now
Questions 6

An application tracks usage of educational courses in a company. Many people can take one course. Each person can take multiple courses. The data has been stored in one table but it is growing too large. You decide to normalize the table.

What would a normalized data model contain?

Options:

A.

Two tables: employee and course, with foreign keys on employee ID and course ID.

B.

Three tables: employee, course, and a table cross-referencing employee IDs and course IDs

C.

Two tables: an employee table with multiple course IDs , and a course table

D.

Four tables: employee, course, courses by employee, and employees by course

Buy Now
Questions 7

The city table has the following structure:

Consider the statement with an incorrect field name:

PREPARE countryBYID FROM ‘SELECT country FROM city WHERE ID=?,

What happens if a prepared statement named countryByID already exists when the above statement is executed?

Options:

A.

A duplicate name error will result because a prepared statement with the same name already exists.

B.

An unknown column error will result and the old prepared statement definition will remain in effect.

C.

An unknown column error will result and no prepared statement named countryByID will exist.

D.

A warning will result and the old prepared statement definition will remain in effect.

Buy Now
Questions 8

You have a transaction that queries a table at the beginning of the transaction and performs the same query later.

Which two transaction isolation levels guarantee that you get the same results both times?

Options:

A.

Repeatable read

B.

Read committed

C.

Read uncommitted

D.

Single user

E.

serializable

Buy Now
Questions 9

Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN).

Which query would you use?

Options:

A.

SELECT UPPER (Location) as location FROM MemberLocation

B.

SELECT UPPER (BINARY location) as location FROM MemberLocation

C.

SELECT UPPER (location AS UPPER ) as location FROM Memberlocation

D.

SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation

Buy Now
Questions 10

Which two PHP modules provide APIs for developing MYSQL applications?

Options:

A.

Mysqli

B.

Mysqlnd

C.

PDO

D.

PDO_mysql

Buy Now
Questions 11

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

Options:

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.

Buy Now
Questions 12

Assume your connection uses SQL mode ANSI_QUOTES.

Which two statements cause a syntax error?

Options:

A.

CREATE TABLE FRIENDS (NAME CHAR (10))

B.

CREATE TABLE BINARY (PRIMARY SMALLINT)

C.

CREATE TABLE ‘TABLE’ (COLUMN’ INTEGER)

D.

CREATE TABLE “CONDITION” (“DESCRIBE” TEXT)

E.

CREATE TABLE INTERVAL (ELAPSED_TIME TIME)

Buy Now
Questions 13

Consider a table my_table , with contents shown:

You execute:

SELECT a b, b a

FROM my_table

WHERE a < s

ORDER BY b;

What does this statement return?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 14

Which three connector/J connection strings can be used to connect to the MYSQL server?

Options:

A.

Jdbc:mysq1://localhost/test?user =xxx&password=xxx

B.

Jdbc :mysqli://localhost/test?user=xxx&password=xxx

C.

Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx

D.

Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx

E.

Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx

Buy Now
Questions 15

Examine this table that contains over two million rows of data:

CREATE TABLE ‘news_feed’ (

.id’bigint (20) NOT NULL AUTO _INCREMENT,

.news _sources_id’varchar (11) NOT NULL,

.dataline’ datetime NOT NULL,

.headline’ varchar (256) NOT NULL,

.story’ text NOT NULL,.tag varchar (32768) DEFAULT NULL,

PRIMARY KEY (‘id’)

KEY ‘dateline’ ( ‘dateline’)

)

Examine this query that returns 332 rows of date:

SELECT *

FROM news_feed

WHERE DATE(dateline)= ‘2013-01-01’

Which change would show the greatest improvement in the response time of the query?

Options:

A.

Use the LIKE operator:

SELECT . . .WHERE dateline LIKE ‘2013-10-01&’

B.

USE the DATEDIFF function:

SELECT . . . WHERE DATEDIFF (dateline, ‘2013-01-01’) = 0

C.

Use numeric equivalents for comparing the two dates:

SELECT. . .WHERE MOD(UNIX_TIMESTAMP (dateline), 86400 =UNIX_TIMESTAMP (‘2013-01-01’)

D.

Use a date range comparison:

SELECT . . . WHERE dateline >= ‘2013-01’ and dateline < ‘2013-01-02’

Buy Now
Exam Code: 1z0-882
Exam Name: Oracle Certified Professional, MySQL 5.6 Developer
Last Update: Nov 23, 2024
Questions: 100