MySQL Database Operations
- What is the general statement-issuing routine?
-
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.
- To reload a delimited text data file use ______________.
-
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.
- Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.
-
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.
- SBR replication is ______________.
-
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.
- For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________.
-
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.