Details of this Paper

MySql Quiz




Question 1 (1 point);Chapter 7: MySQL is a commercial product and is not free. Question 1 options;True;False;Question 2 (1 point);MySQL is part of PHP. Question 2 options;True;False;Question 3 (1 point);Relational databases are preferred solutions for large and complex collections of information. Question 3 options;True;False;Question 4 (1 point);Primary and foreign keys link records across multiple tables in a relational database. Question 4 options;True;False;Question 5 (1 point);Primary and foreign keys are the only pieces of information in a relational database table that should be duplicated. Question 5 options;True;False;Question 6 (1 point);SQL stands for sequential query language. Question 6 options;True;False;Question 7 (1 point);reduces the size of a database and makes the data easier to work with. Question 7 options;The primary key;The foreign key;The child key;Normalization;Question 8 (1 point);Chapter 8: The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn?t. Question 8 options;True;False;Question 9 (1 point);The mysql_close() function is used to explicitly close a database connection. Question 9 options;True;False;Question 10 (1 point);The mysql_error() function returns a value of FALSE if it detects an error. Question 10 options;True;False;Question 11 (1 point);The mysql_delete_db("dbname"[, connection]), script is used to delete a database. Question 11 options;True;False;Question 12 (1 point);The NOT NULL keywords are often used with primary keys to require that a field include a value. Question 12 options;True;False;Question 13 (1 point);The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0. Question 13 options;True;False;Question 14 (1 point);To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function. Question 14 options;True;False;Question 15 (1 point);To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function. Question 15 options;True;False;Question 16 (1 point);With queries that return results, such as SELECT queries, you can use the mysql_num_rows() function to find the number of records returned from a query. Question 16 options;True;False;Question 17 (1 point);The mysql_fetch_row() function returns the fields in the current row of a resultset into an indexed array and moves the result pointer to the next row. Question 17 options;True;False;Question 18 (1 point);To open a connection to a MySQL database server, use ____. Question 18 options;mysql_connect();open_connect();connection_mysql();open_mysql();Question 19 (1 point);To close a database connection, use ____. Question 19 options;close_connection();mysql_close();mysql_exit();close_mysql();Question 20 (1 point);The ___ function returns a text string describing the error in PHP code. Question 20 options;mysql_error();mysql_errno();mysql_err();mysql_error_number();Question 21 (1 point);To delete a database (table), use the ____ function. Question 21 options;mysql_delete_db();mysql_drop_database();mysql_delete_database();mysql_drop_db();Question 22 (1 point);Almost every command sent to MySQL from PHP is executed with the ____ function. Question 22 options;mysql_connect();mysql_select();mysql_query();mysql_send();Question 23 (1 point);A result pointer is a special type of ____ that refers to the currently selected row in a resultset. Question 23 options;variable;option;function;command;Question 24 (1 point);The list of records that is returned from a mysql_query() is a called a ____. Question 24 options;recordset;resultset;result;result query;Question 25 (1 point);The ___ keyword is often used with the primary key to generate a unique id for each new row in a table. Question 25 options;UNIQUE_ID;INCREMENT_ID;AUTO_INCREMENT;AUTO_INCREMENT_ID;Question 26 (1 point);The ___ keyword, often used with the primary key, requires that the field include a value. Question 26 options;NOT NULL;NOT BLANK;NOT EMPTY;NOT VOID;Question 27 (1 point);To change records in a table, use the UPDATE keyword to specify the name of the table to update and the ___ keyword to specify the value to assign to the fields in the records that match the condition in the WHERE keyword. Question 27 options;CHANGE;INSERT;PUT;SET;Question 28 (1 point);To delete records in a table, use the keywords ____. Question 28 options;DELETE, RECORD;DELETE, WHERE;REMOVE, WHERE;REMOVE, RECORD;Question 29 (1 point);With an INSERT query, the ___ function returns the number of records added and duplicated along with the number of warnings. Question 29 options;mysql_update_info();mysql_info();mysql_update();mysql_info_update();Question 30 (1 point);The function ____ returns the fields in the current row into an indexed array. Question 30 options;mysql_fetch_assoc();mysql_data_seek();mysql_fetch_row();mysql_fetch_lengths()


Paper#69347 | Written in 18-Jul-2015

Price : $22