1Z0-882 Online Practice Questions and Answers

The tab-delimited file"/tmp/people,txt contains:

1636 Carsten Pederson Denmark 4672 Kai Voigt Germany 4628 Max Mether France

This is the structure of the people table: Mysq1> DESCRIBE people; Which statement will load the first and last names into the Names column and the country into the country column?

A. LOAD DATA INFILE `/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4 (CONCAT (@First, ` `,@Last) , @ Country)

B. LOAD DATA INFILE `/tmp/people.txt ` INTO TABLE People @Skip=$1 , @ First=$2, @Last=$3, @ Country=4, (CONCAT (@First, ` ` .@ Last) , @ Country)

C. LOAD DATA INFILE `/tmp/people.txt `INTO TABLE People (@ Skip, @First , @Last, @Country SET Name=CONCAT (@First, ` `,@Last)

D. LOAD DATA INFILE `/tmp/people,txt, INTO TABLE People. (@Skip. @First, @Last, @Country) Country=@country

E. It is not possible to load the data from the file/tmp/people.txt into the people table,as shown.

The data from t1 table is:

Assuming You want to see this output: Which query achieves the preceding result?

A. SELECT name FROM t1 WHERE name LIKE ,_e%

B. SELECT name FROM t1 WHERE name LIKE,e%.;

C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;

D. SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;

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

A. Jdbc:mysq1://localhost/test?user =xxxandpassword=xxx

B. Jdbc :mysqli://localhost/test?user=xxxandpassword=xxx

C. Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxxandpassword=xxx

D. Jdbc:mysql:proxy://localhost/test?user=xxxandpassword=xxx

E. Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxxandpassword=xxx

A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown:

You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the effect of adding STRAIGHT JOINs to the query?

A. The optimizer processes only the JOINs in the sequence listed in the query.

B. The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.

C. The optimizer will only JOIN the tables in sequence from smallest to largest.

D. The optimizer ignores all terms in the WHERE clause until all JOINs have been completed.

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?

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

You have a database `dev' that contains 15 tables, all of which use the CHARACTER SET `utfs' and the COLLATION `utfs_general_ci'.

You perform the command:

ALTER DATABASE `dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci'

What is the result?

A. You get an error because database are not allowed to have CHARACTER SET or COLLATION attributes.

B. You get an error because the settings for CHARACTER SET and COLLATION attributes do not match the settings for the tables inside the database.

C. You get an error while trying to change from a more inclusive CHARACTER SET like `utfs to a less' inclusive CHARACTER SET like `latin'.

D. You get an error because changes to the CHARACTER SET or COLLATION attribute can happen only for empty databases.

E. The statement succeeds and new tables created in this database use the new settings as their default values.

F. The statement succeeds and all of the tables inside the database are converted to user the new settings.

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.

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.jd bc

B. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin

C. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin

You want to query the VARCHAR column ` code' values that match:

Start with "p"

End with "_"

Contain more than 3 characters

Assume that sql_mode is blank.

Which two queries select only those rows?

A.

SELECT code FROM operations WHERE code LIKE "pandand_";

B.

SELECT code FROM operations WHERE code LIKE " 'and'and_' "ESCAPE " ` '';

C.

SELECT code FROM operations WHERE code LIKE "pand_\_";

D.

SELECT code FROM operations WHERE code LIKE "p_\and\_";

E.

SELECT code FROM operations WHERE code LIKE "p_7_and;_"ESCAPE "/";

When executing a stored routine, how is the SQL_MODE determined?

A. By the default SQL_MODE of the server

B. By the current SQL _MODE of the session

C. By the SQL_MODE that was set when the routine was defined

D. By using TRADITTIONAL regardless of any other settings