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.

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''

These there tables represent a many to-many relationship in asocial networking database: This query draft is constructed to report for the past 30 days: Which change will correct this query?

A. Option A

B. Option B

C. Option C

D. Option D

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

Consider the query and its output:

Mysql> SELECT Language As Lang FROM countrylanguage ->WHERE countrycode ='GBR';

A user wants to have an output as shown:

What query would achieve this?

A. SELECT GROUP_IMPLODE (Language) As Lang FROM countrylanguage WHERE countrycode= `GBR';

B. SELECT GROUP_CAT(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

C. SELECT GROUP_CSV(Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

D. SELECT GROUP_CONCAT (Language) As Lang FROM countrylanguage WHERE countrycode='GBR';

Inspect the query:

Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE

dept_no'd004';

4 rows in set (0.00 sec)

Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004';

2 rows in set (0.00 sec)

Which two statements are true about the EXPLAIN output?

A. All data for the result is read from the indexex.

B. The PRIMARY KEY is used for filtering in both tables.

C. The minimal number of rows possible are read.

D. The dept_manager table has 4 times as many rows than the employees table.

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 have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated:

No manage is managing more than three people.

No employee can work for more than one manage.

Which of these designs represents a normalized schema that meets the project requirements?

A. CREATE TABLE `manager' `manager' varchar (50) DEFAULT NULL, `employee2' varchar (50) DEFAULT NULL, `employee' varchar (50) DEFAULT NULL, UNIQUE ( `manager `, `employee1', `employee2, `employee3') )

B. CREATE TABLE `managers' ( "id' int(11) NOT NULL AUTO_INCREMENT, `manager' varchar (50) DEFAULT NULL , PRIMARY KEY (`id') ) CREATE TABLE "employees' ( `id' int(11) NOT NULL AUTO _INCREMENT, `manager_id' int(11) DEFAULT NULL, `employee varchar (25) DEFAULT NULL, PRIMARY KEY (`id') )

C. CREATE TABLE `manager' ( `manager' varchar (50) DEFAULT NULL, `employee_list'varchar (150) DEFAULT NULL, )

D. CREATE TABLE `message' ( `id' int(11) NOT NULL AUTO_INCREMENT, `manager' varchar(50) DEFAULT NULL, PRIMARY KEY ("id') ) CREATE TABLE `employees' ( `id int (11) NOT NULL AUTO _INCREMENT, ` employees' varchar(25) DEFAULT NULL, )

Which three statement types can be prepared?

A. LOAD DATA INFILE

B. CREATE TABLE

C. CREATE VIEW

D. ALTER VIEW

E. CALL

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