1z0-882: MySQL 5.6 Developer Null Practice Questions

Which two queries return a value of NULL?

Select 2 answers.

• AA. SELECT NULL =NULL
• BB. SELECT NULL is NULL
• CC. SELECT NULL <= > NULL
• DD. SELECT 1 > NULL
• EE. SELECT COUNT (NULL);

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?

Select 2 answers.

• AA. The ‘warehouseitem’ table must be managed by the MySAm storage engine.
• BB. The ‘warehouse-table must be managed by the InnoDB storage engine.
• CC. The foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES (warehouse-id).
• DD. The data types of the ‘warehouse’.’id’ and ‘ warehouseitem.warehouse_is columns must match.
• EE. The warehouse_id’ column must be renamed ‘id’ to match the definition on the ‘warehouse’ table.
• FF. A UNIQUE key must be defined for the columns (‘item_id’,’warehouse_id’).