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.

Identity two ways to configure a PHP application to use the UTF8 character set.

A. mysqli: :query (`'SET NAMES utfs'');

B. mysqli : :set_charset (`utf8')

C. spdo = new PDO (`'mysql:host=localhost;dbname=test;charset=utfs'', user'', `'pass'');

D. PDO: :set_charset(`'utf8'')

Which three are valid identifiers for the user table in the mysq1 database?

A. myssq1. user

B. `mysq1. user'

C. `mysq1'. `user'

D. Mysq1. `user'

E. `'mysq1. User''

In the office table, the city column is structured as shown:

Mysql> show columns from office like `city'\G

---------------------------------------------------1. row ---------------------__________________ Field: city

Type: enum(`paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes

Key:

Default:NULL

Extra:

Consider the output of the SELECT query executed on the office table:

Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:

SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?

A. Paris, Amsterdam. New York, Tokyo

B. Tokyo, New York, Amsterdam, Paris

C. Amsterdam, New York, Paris, Tokyo

D. Tokyo, Paris, New York, Amsterdam

Cormcctor/Net supports a decoupled database connection mode, where a database Connection is

established only when needed.

'

Choose the three parts that are involved when working with decoupled data.

A. OpenConnect.MySql, DataTTiread.MySql, CommandExecutor.MySql

B. MySqlQueryBuIld, MySqlQuerytxer. MySq I Query Results

C. DecoupODBCConn, DecoupMyScjlruiiimanrt, DecoupMySqlRetum

D. DataSet, MySqlDataAdapter, MySql Command Builder

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.

Which two PHP modules provide APIs for developing MYSQL applications?

A. Mysqli

B. Mysqlnd

C. PDO

D. PDO_mysql

Inspect the query:

Mysql> SELECT count (emp_no) FROM titles WHERE title = `senior staff';

How can this query be optimized?

A. The query need an index on the emp-no column.

B. The query cannot be optimized as an index is already used.

C. The query needs an index that includes the title column.

D. The query cannot be optimized as count () must read all rows.

Inspect the CREATE TABLE below:

Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2

warnings (0.11 sec)

Mysql> SHOW WARNINGS;

Which two is true connecting the meaning of the warnings?

A. The InnoDB storage engine was disabled during server startup.

B. Global variable skip _innodb was set to ON after the server had started.

C. The default storage engine MYISAM was used for the table created.

D. MYSQL server was not started with the option default storage engine=InnoDB

E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB

Assume that none of the databases exist.

A. CREATE DATABASE $test

B. CREATE DATABASE 1$

C. CREATE DATABASE $

D. CREATE DATABASE _

E. CREATE DATABASE 12

You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted: @old _countryNames with the value of the Name field @old _countryName with the value of the code field

You may assume that only one row is ever deleted at a time. CREATE TRIGGER Country_ad AFTER DELETE ON Country FOR EACH ROW SET

@old _CountryName= NEW.Name,

@

old _CountryCode=NEW.Code;

What is the outcome of the CREATE TRIGGER statement?

A.

The trigger will be created successfully.

B.

An error results because the NEW keyword cannot be used in a DELETE trigger.

C.

An error results because FOR EACH ROW is invalid syntax.

D.

An error results because a BEGIN. . .END block is required.

Consider the stored procedure

CREATE PROCEDURE param_test (

IN P_in INT,

OUT P_out INT,

INPUT P_inout INT)

BEGIN

SELECT P_in, P_out, P_ inout;

SET P_in, P_inout

END

You execute a series of commands:

What is the output of the CALL and SELECT?

A. (0,0,0) and (0,0,0)

B. (0,0,0,) and (0,200,300)

C. (0,NULL,0) and(0,200,300)

D. (0,NULL,0) and (100,200,300)

Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage;

SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial;

You add an index on the Isofficial column. Which two statement are true?

A. The optimizer will choose the index when Isofficial='T' is in the WHERE clause.

B. The optimizer will choose the index when Isofficial='F' is in the WHERE clause.

C. The optimizer will not choose the index on the Isofficial column.

D. The speed of INSERT statements to this table will be improved.

E. The speed of INSERT statements to this table will be reduced.

F. The speed of INSERT statements to this table will be unchanged.

The friends table has the columns and contents as shown: Mysql> SELECT * FROM friends;

This statement was executed: SELECT AVG (age) FROM friends What value is returned?

A. NULL

B. 10

C. 20

D. 0

A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0

What happens when you execute an UPDATE statement without a WHERE clause?

A. Results in an error

B. Updates every row in the specified table(s)

C. Results in - -safe-updates being enabled automatically

D. Causes a syntax error