We're so confident of our products that we provide no hassle product exchange.
MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I Sample Questions:
1. Assume you compile MySQL from source and invoke configure with the following options.
--with-charset=latin1 --with-extra-charsets=utf8,ucs2
Compared to a standard binary installation that contains many more character sets, which of the following statements is/are true?
A) The compiled version will use less file handles, because only a few files need to be opened when the server is started.
B) The compiled version will use less disk space, because only a few character sets will be installed on disk.
C) The compiled version will use less memory, because only a few character sets will be loaded by the server.
2. You want to lock the three tables a, b and c, and issue the following statements:
mysql> LOCK TABLES a READ;
mysql> LOCK TABLES b READ;
mysql> LOCK TABLES c READ;
Which tables are now locked?
A) Table a only
B) None of the tables are locked
C) Tables a, b and c
D) Table c only
3. 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\mysqladmin -u root start
B) C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql_start
C) C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld
4. When starting the mysqld program, which of the following statements are true?
A) Startup options can only be given on the command line except for Windows Services.
B) Startup options can be given either in option files, or as parameters on the command line, except for Windows services.
C) Startup options can be given either in option files, or as parameters on the command line.
D) Startup options can only be given on the command line.
E) Startup options can only be given in option files.
5. You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance?
A) Yes, provided that binary logging is turned off during the re-reading of the dump.
B) No, the new server instance must be the same version as the one which created the dump for everything to work
C) Always
D) Yes, provided that --max-allowed-packet is set correctly
Solutions:
| Question # 1 Answer: B,C | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: B | Question # 5 Answer: D |
By April
