Get real exam questions for 1z0-882 Oracle Certified Professional, MySQL 5.6 Developer. 100% Free.
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-i
Q1. Examine this table that contains over two million rows of data:CREATE TABLE ‘news_feed’ (.id’bigint (20) NOT NULL AUTO _INCREMENT,.news _sources_id’varchar (11) NOT NULL,.dataline’ datetime NOT NULL,.headline’ varchar (256) NOT NULL,.story’ text NOT NULL,.tag varchar (32768) DEFAULT NULL, PRIMARY KEY (‘id’)KEY ‘dateline’ ( ‘dateline’))Examine this query that returns
Q1. 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?A. ‘Casper’ and ‘ undefined values are inserted into the ‘name’ and gender’ column.B. The server returns an error indicating that ‘undefined’ cannot be in