MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I 1Z0-873 Prüfungsfragen mit Lösungen:
1. When you set up per-table tablespace files for InnoDB...
A) Occasionally shared tablespace files are still needed.
B) Shared tablespace files are not needed.
C) Shared tablespace files are still needed.
D) Per-table tablespace files cannot be used with InnoDB.
2. Which of following list the default order in which option files are read on UNIX?
A) /etc/my.cnf, $MYSQL_HOME/my.cnf, and ~/.my.cnf
B) $MYSQL_HOME/my.cnf, /etc/my.cnf, and ~/.my.cnf
C) /etc/my.cnf, ~/.my.cnf, and $MYSQL_HOME/my.cnf
D) ~/.my.cnf, /etc/my.cnf, and $MYSQL_HOME/my.cnf
E) ~/.my.cnf, $MYSQL_HOME/my.cnf, and /etc/my.cnf
3. Which of the following are true for how BTREE and HASH index types should be used for MEMORY tables?
A) BTREE index types are only for use with equality comparisons such as those using the = and <=> operators.
B) HASH index types are only for use with equality comparisions such as those using the = and <=> operators.
C) HASH index types are preferable for use with comparisons that do not just use equality operators such as = and <=>
D) BTREE index types are preferable for use with comparisons that do not just use equality operators such as = and <=>
4. Which one of the following statements can be used to start MySQL 5.0 manually from the command line on windows?
A) C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql_start
B) C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld
C) C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin -u root start
5. Which of the following storage engines will ignore foreign keys if they are specified?
A) HEAP
B) InnoDB
C) MERGE
D) MyISAM
E) FEDERATED
Fragen und Antworten:
| 1. Frage Antwort: C | 2. Frage Antwort: A | 3. Frage Antwort: B,D | 4. Frage Antwort: B | 5. Frage Antwort: A,C,D,E |






962 Kundenbewertungen

