MySQL Database Operations


  1. What is the general statement-issuing routine?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The general statement-issuing routine is mysql_real_query(). The statement is provided as a counted string (a string plus a length). The length of the statement string must be kept track of.


  1. To reload a delimited text data file use ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    A way to create text data files along with files containing ‘CREATE TABLE’ statements for the backed up tables is to use ‘mysqldump’ with –tab. To reload a delimited text data file ‘mysqlimport’ is used.



  1. Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves). Replication is asynchronous by default.


  1. SBR replication is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    There are two main kinds of replication format: Statement Based Replication (SBR) replicates entire SQL statements and Row Based Replication (RBR) replicates only the changed rows.



  1. For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    For InnoDB tables it is possible to perform an online backup that takes no locks on tables using the option ‘–single-transaction’ to ‘mysqldump’. The ‘mysqldump’ can make backups.