Download MySQL 5.6 Developer.1z0-882.Prep4Sure.2019-04-10.61q.vcex
| Vendor: | Oracle |
| Exam Code: | 1z0-882 |
| Exam Name: | MySQL 5.6 Developer |
| Date: | Apr 10, 2019 |
| File Size: | 1 MB |
| Downloads: | 1 |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than ‘max_allowed_packet’ bytes
Which two scenarios can hibernate this error message? (Choose two.)
- The application tried to INSERT a row that exceeded max_allowed_packet.
- The network caused an error Inducing the max_allowed_packet error.
- The application did not use the COMPRESS () function for a large result set.
- The application tried to SELECT many rows together that exceeded max__allowed_packet.
- The application tried to SELECT a row that exceeded max_allowed_packet.
- The operating system caused an error inducing the max_allowed_packet error.
Correct answer: DF
Question 2
Which two functions can be used in a C program to retrieve information about warning? (Choose two.)
- mysql_info
- mysql_error
- mysql_warning_count
- mysql_errno
Correct answer: AB
Question 3
You wish to create a trigger on the ‘city’ table that will check the value of the ‘District’ field before any INSERT. The trigger needs to change it to” Unknown” for an empty string or NULL.
CREATE TRIGGER City_bi
BEFORE INSERT ON CITY
FOR EACH ROW
BEGIN
IF OLD. District IS NULL OR OLD.District= . .
THEN
SET NEW.District=’Unknown’;
END IF :
END;
Does the CREATE TRIGGER statement accomplish this goal?
- Yes; the trigger works correctly.
- No; FOR EACH ROW is invalid syntax.
- No; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT….
- No; the OLD keyword cannot be used in an INSERT trigger.
Correct answer: A
Question 4
The tab-delimited file”/tmp/people,txt contains:
This is the structure of the people table:
Which statement will load the first and last names into the Names column and the country into the country column?
- LOAD DATA INFILE ‘/tmp/people.txt’INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4(CONCAT (@First, ‘ ‘,@Last) , @ Country)
- LOAD DATA INFILE ‘/tmp/people.txt ‘ INTO TABLE People@Skip=$1 , @ First=$2, @Last=$3, @ Country=4,(CONCAT (@First, ‘ ‘ .@ Last) , @ Country)
- LOAD DATA INFILE ‘/tmp/people.txt ‘INTO TABLE People(@ Skip, @First , @Last, @CountrySET Name=CONCAT (@First, ‘ ‘,@Last)
- LOAD DATA INFILE ‘/tmp/people,txt, INTO TABLE People.(@Skip. @First, @Last, @Country)Country=@country
- It is not possible to load the data from the file/tmp/people.txt into the people table, as shown.
Correct answer: C
Question 5
What are two ways in which normalizing your tables helps improve performance In MySQL?
- Smaller table sizes and row lengths improve sorting operations.
- Separate tables allow indexing more columns.
- Fewer nullable column improve index usage.
- Normalizing Improves the performance of innodb_file_per _table.
Correct answer: BC
Question 6
Identity two ways to configure a PHP application to use the UTF8 character set. (Choose two.)
- mysqli: :query (‘’SET NAMES utfs’’);
- mysqli : :set_charset (‘utf8’)
- spdo = new PDO (‘’mysql:host=localhost;dbname=test;charset=utfs’’, user’’, ‘’pass’’);
- PDO: :set_charset(‘’utf8’’)
Correct answer: BC
Explanation:
Reference: http://stackoverflow.com/questions/5842980/a-permanent-way-of-doing-mysqli-set-charset Reference: http://stackoverflow.com/questions/5842980/a-permanent-way-of-doing-mysqli-set-charset
Question 7
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? (Choose two.)
- Repeatable read
- Read committed
- Read uncommitted
- Single user
- Serializable
Correct answer: AE
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.0/en/commit.html Reference: http://dev.mysql.com/doc/refman/5.0/en/commit.html
Question 8
Which three database objects have non-case-sensitive names on all operating system? (Choose three.)
- Table
- Column
- Index
- Stored procedure
- Trigger
Correct answer: BCD
Question 9
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?
- Paris, Amsterdam. New York, Tokyo
- Tokyo, New York, Amsterdam, Paris
- Amsterdam, New York, Paris, Tokyo
- Tokyo, Paris, New York, Amsterdam
Correct answer: C
Question 10
In MYSQL 5.6 you have the table t1:
CREATE TABLE t1 (
id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;
There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1;
Connection 2> TRUNCATE TABLE t1;
What happens to the TRUNCATE TABLE command in connection 2?
- It immediately proceeds and causes an implicit commit of the transaction in connection1.
- It runs concurrently with the transaction in connection 1 as each connection has its own view of the data in the t1 table.
- It blocks waiting for a metadata lock until the transaction in connection 1 ends.
- It blocks waiting for a table lock until the transaction in connection 1 ends.
Correct answer: A
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!