1z0-882 by Oracle Valid Free Exam Practice Test

Question 1

Inspect the query:
Mysql> SELECT count (emp_no) FROM titles WHERE title = 'senior staff';

How can this query be optimized?

A. The query cannot be optimized as count () must read all rows. B. The query needs an index that includes the title column. C. The query cannot be optimized as an index is already used. D. The query need an index on the emp-no column.

Correct Answer: C

Question 2

Which three statement types can be prepared?

A. CALL B. LOAD DATA INFILE C. CREATE TABLE D. CREATE VIEW E. ALTER VIEW

Correct Answer: A,C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Which two queries return a value of NULL?

A. SELECT NULL is NULL B. SELECT NULL <= > NULL C. SELECT COUNT (NULL); D. SELECT NULL =NULL E. SELECT 1 > NULL

Correct Answer: D,E

Question 4

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 the settings for CHARACTER SET and COLLATION attributes do not match the settings for
the tables inside the database. B. You get an error while trying to change from a more inclusive CHARACTER SET like 'utfs to a less' inclusive
CHARACTER SET like 'latin'. C. The statement succeeds and new tables created in this database use the new settings as their default values. D. You get an error because database are not allowed to have CHARACTER SET or COLLATION attributes. E. The statement succeeds and all of the tables inside the database are converted to user the new settings. F. You get an error because changes to the CHARACTER SET or COLLATION attribute can happen only for empty
databases.

Correct Answer: C

Question 5

Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no mysqld
process is running.
Which two may provide diagnostic information to help determine why the MYSQL server stopped?

A. The slow query log file B. The MYSQL server error log file C. The binary log file D. The syslog on Linux/UNIX or the Event view on windows E. The general query log file

Correct Answer: B,C

Question 6

Which statement describes the process of normalizing databases?

A. Columns that contain repeating data values are split into separate tables to reduce item duplication. B. Redundant tables are combined into one larger table to simplify the schema design. C. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest
allocation. D. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected. E. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.

Correct Answer: A

Question 7

The people table contains the data as shown:

Which two statements return two rows each?

A. SELECT 1, 2 FROM people WHERE last _name ='smith' B. SELECT DISTINCT last_name, first_name FROM people C. SELECT 1,2 FROM people GROUP BY last_name D. SELECT first _name, last_name FROM people LIMIT 1, 2 E. SELECT first_name, last _name FROM people WHERE age LIKE '2'

Correct Answer: C,D

Question 8

You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?

A. Tab-delimited data B. Comma-delimited data C. MyISAM or InnoDB data files D. SQL commands

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

You started a MySQL command -line session with sq1_ mode (empty), and created the person table with the
structure:
Mysql> DESC person;

You issue:
INSERT INTO person VALUES ('casper', 'undefined')
What is the effect?

Correct Answer:

Question 10

Consider the CREATE FUNCTION statement:
CREATE FUNCTION countrycount ()
BEGIN
DECLARE count INT;
SELECT COUNT (*) INTO count FROM country;
RETURN count ;
END
What is the outcome when you try to create the function?

A. An error results as the SELECT must assign the return values to a user variable. B. An error results as the count variable is not initialized with a value. C. An error result as the function must be defined with the CONTAINS SQL clause. D. An error result as the variable type returned by the function must be defined with a RETURNS clause.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Certified Professional, MySQL 5.6 Developer - 1z0-882 Exam Practice Test