I am getting ready for a test and have a few questions There is a tab delimited
ID: 3643816 • Letter: I
Question
I am getting ready for a test and have a few questionsThere is a tab delimited file named input.txt which is in the TEMP direcotry on the server. What is the command to insert rows from the file into the orders table in the test database?
Describe two advantages of Transaction-safe tables
List the three advantages of NonTransaction-safe tables
Faster, Less Space, Less Memory (correct?)
What is the file extension that Each MyISAM table uses jto store the data.
Which engine has been designed for maximum performance when
processing large data volumes.--> InnoDB. Right?
What happens to a BLACKHOLE table in database TEST when the database server shuts down?
Explanation / Answer
Solution:
Import command used to do so. See link:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0008304.htm
Advantages of Transaction-Safe Tables
1. Safer. Even if MySQL crashes or you get hardware problems, you can get your data back, either by automatic recovery or from a backup + the transaction log.
2. You can combine many statements and accept these all in one go with the COMMIT command.
3. You can execute ROLLBACK to ignore your changes (if you are not running in auto-commit mode).
4. If an update fails, all your changes will be restored.
Advantages of Not Transaction-Safe Tables
1. Much faster as there is no transaction overhead.
2. Will use less disk space as there is no overhead of transactions.
3. Will use less memory to perform updates.
Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension.
InnoDB has been designed for maximum performance when processing large data volumes.
BLACKHOLE table is lost in such a case.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.