Act now and download your Oracle 1z0-882 test today! Do not waste time for the worthless Oracle 1z0-882 tutorials. Download Leading Oracle Oracle Certified Professional, MySQL 5.6 Developer exam with real questions and answers and begin to learn Oracle 1z0-882 with a classic professional.
Q1. As a developer, you inherit this table as part of a project: CREATE TABLE exam (
Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
Examinee_id INTEGER UNSIGNED UNIQUE, Score INTEGER UNSIGNED
)
What change should you make to ensure that examinee_id is an integer value throughout the table?
A. The examinee_id column should be designated as PRIMARY KEY.
B. A NOT NULL qualifier should be moved from exam-id to examinee-id.
C. The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).
D. A NOT NULL qualifier should be added to examinee_id.
Answer: A
Q2. 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’’
Answer: A,C,D
Q3. Which two code samples demonstrate valid methods for working with loops?
A. DECLARE I INT DEFAULT 0;
Test_loop: LOOP SET i =i +1;
IF i> =5 THEN
LEAVE test_loop; END IF;
END LOOP test_loop;
B. DECLARE i INT DEFAULT 0; WHILE I < 5ITERATE
SET i = i +1; END WHILE;
C. DECLARE i INT DEFAULT 0; WHILE i < 5 Do
SET i = i + 1; END WHILE;
D. DECLARE i INT DEFAULT 0;
Test _loop; LOOP SET i =i +1;
IF i >=5 THEN LEAVE; END IF;
END LOOP test_loop;
Answer: C,D
Q4. 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 general query log file
B. The syslog on Linux/UNIX or the Event view on windows
C. The slow query log file
D. The MYSQL server error log file
E. The binary log file
Answer: D,E
Q5. Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?
A. An error that @ a is undefined
B. A single NULL
C. An empty string
D. The value of GLOBAL variable @ a
Answer: B
Q6. 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.
Answer: E
Q7. You attempt to create two new tables: CREATE TABLE ‘warehouse’ (
‘id’ int (11) NOT NULL AUTO_INCREMENT,
‘name’ varchar (20) NOT NULL, ‘phone’ varchar (20) NOT NULL,
PRIMARY KEY (‘ id)
) ENGINE=MyISAM
CREATE TABLE ‘warehouseitem’ ( ‘warehouse_id’ bigint (11) NOT NULL, ‘item_id’ int (11) NOT NULL,
‘count’ int(11) NOT NULL DEFAULT ‘0’,
KEY “warehouse_id’ (‘warehouse-id) ,
FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id)
) ENGINE= InnoDB
You get this error :
ERROR 1215 ( HYooo): cannot add foreign key constraint
Which two changes are required to permit these statements to execute without any error?
A. The ‘warehouseitem’ table must be managed by the MySAm storage engine.
B. The ‘warehouse-table must be managed by the InnoDB storage engine.
C. The foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES (warehouse-id).
D. The data types of the ‘warehouse’.’id’ and ‘ warehouseitem.warehouse_is columns must match.
E. The warehouse_id’ column must be renamed ‘id’ to match the definition on the ‘warehouse’ table.
F. A UNIQUE key must be defined for the columns (‘item_id’,’warehouse_id’).
Answer: C,D
Q8. 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.
Answer: D
Explanation:
Routine Functions must provide a RETURNS clause noting data-type just after func_name and parameters, before characteristics.