What are two ways in which normalizing your tables helps improve performance In MySQL?

A. Smaller table sizes and row lengths improve sorting operations.

B. Separate tables allow indexing more columns.

C. Fewer nullable column improve index usage.

D. Normalizing Improves the performance of innodb_file_per _table.

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''

Your application is running slow.

Which two features provide information that help to identify problems?

A. The MYSQL error log

B. The slow query log

C. The performance schema

D. The GET DIAGNOSTICS statement

Using the query:

SELECT Code FROM country WHERE Name = `united states' Which statement executed in the mysql client would create a prepared statement?

A. PREPARE STATEMENT countrycode FROM `SELECT code FROM counyry WHERE Name =?.;

B. PREPARE countrycode As `SELECT code FROM country WHERE Name =?.;

C. PREPARE countrycode FROM `SELECT code FROM country WHERE Name =?.;

D. PREPARE STATEMENT countrycode As `SELECT code FROM country WHERE Name =?.;

Which statement is true when working with PHP and prepared statement?

A. The mysql extension supports only client-side emulation.

B. The mysql1 extension support client-side emulation.

C. The PDO_MySQL extension supports both client side and server side emulation.

D. The PDO_MySQL extension supports only server side emulation.

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 (warehouseid).

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').

Which statement describes the process of normalizing databases?

A. All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.

B. Redundant tables are combined into one larger table to simplify the schema design.

C. Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.

D. Columns that contain repeating data values are split into separate tables to reduce item duplication.

E. Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.

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 inserted into a column of ENUM type

C. The server returns a warning and the empty string is inserted to the `gender' column.

D. The server returns a warning and the first specified value ,"male" is inserted to the gender column.

You have created your connector/Net object to connect to MySQL. What are three valid database operations you can call?

A. ExecuteReader, ExecuteNonQuery, ExecuteScalar

B. PreformReadonly, performNonQuery,perforIndexRead

C. Query, Execute.MySql, Read. Execute. MySQl, Execute,Mysql

D. Insert Mysql, UpdateMysql,DeleteMysql

E. Query .Apply ,Mysql.Delete.Mysql,Query. Update .Mysql

You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables. Which query accomplishes this?

A. SELECT * FROM tableA. tableB

B. SELECT * FROM tableA JOIN tableB

C. SELECT * FROM table A INNER JOIN tableB

D. SELECT * FROM tableA NATURAL JOIN tableB

E. SELECT and FROM tableA STRAIGHT JOIN tableB