Online Access Free 1Z0-873 Exam Questions

Which of the following statements are true?

• A.MyISAM tables cannot be recovered after a crash, you have to restore data from backup.
• B.InnoDB tables will be automatically recovered after a crash.
• C.MyISAM tables will be automatically recovered after a crash.
• D.InnoDB tables will be recovered after a crash if the innodb-recover option is configured.
• E.InnoDB tables cannot be recovered after a crash, you have to restore data from backup.
• F.MyISAM tables will be recovered after a crash if the myisam-recover option is configured.

Which mysqld command line option disables incoming TCP/IP connections?

• A.--no-networking
• B.--skip-networking
• C.--shared-memory
• D.--memlock

Which of the following statements are true?

• A.MyISAM supports cascaded DELETE statements.
• B.InnoDB supports Foreign Keys.
• C.InnoDB supports cascaded UPDATE statements.
• D.InnoDB supports cascaded DELETE statements.
• E.MyISAM supports cascaded UPDATE statements.
• F.MyISAM supports Foreign Keys.

Which of the following is true of the mysqldump client program?

• A.It can only backup tables from MyISAM and InnoDB.
• B.It can only backup tables from InnoD
• C.It can only backup tables from MyISAM.
• D.It can backup tables from any of the available storage engines.

Using mysqldump, which of the following commands are used to backup one database?

• A.shell> mysqldump world < world.sql
• B.shell> mysqldump -d world > world.sql
• C.shell> mysqldump world > world.sql
• D.shell> mysqldump world world.sql