Mysql miscellaneous
- Which of these exports table definitions and contents?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
In MySQL, some distributions include a set of some client programs. ‘mysqldump’ exports the table definitions and the contents. ‘mysqladmin’ performs adminisitrative tasks.
- The system variable controls the size of the table cache _________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
In MySQL, when the server opens table files it keeps them open to minimize the number of file-opening operations. It maintains information about open files in the table cache.
- Which of these is faster when accessing data?
memory, disk
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
In MySQL, the administrators have more privileges since they have more control of the MySQL server or the machine on which it runs. Accessing data in memory is faster than from disk.
- The default scheduling property of MySQL is implemented by how many of these?
MyISAM, MERGE, MEMORY
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The MyISAM, MERGE and the MEMORY storage engines implement the default scheduling policy of MySQL with the help of the table locks. Whenever a client accesses a table a lock for it must be acquired first.
- What has higher priority?
writes, reads
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
A client performing an operation that modifies a table is a writer and the client that performs a retrieval from the table is a reader. The writes have higher priority than reads.