File Info
| Exam | Certified MySQL 5.0 DBA Part I |
| Number | 005-002 |
| File Name | mySQL.005-002.PrepDumps.2016-12-12.140q.vcex |
| Size | 108 KB |
| Posted | Dec 12, 2016 |
| Download | mySQL.005-002.PrepDumps.2016-12-12.140q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database? If not, why?
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA'
ORDER BY TABLE_NAME
- Yes.
- No; the INFORMATION_SCHEMA database does not contain information on itself.
- No; the WHERE clause is incorrect. The correct field name is TABLE_SCHEMATA.
- No; there is no table in the INFORMATION_SCHEMA database called TABLES.
Correct answer: A
Question 2
Which of the following are some general capabilites of the mysql client program?
- Create and Drop databases
- Ping the server
- Create, Drop, and modify tables and indexes.
- Shutdown the server.
- Create users.
- Display replication server status.
Correct answer: ACEF
Question 3
Suppose you have a server that has been started with the --myisam-recover option. When does the server perform the check on the MyISAM tables?
- Each time the server is started.
- Each time it encounters an error.
- Each time it opens the MyISAM table files.
- Each time the CHECK TABLE command is issued.
Correct answer: C
Question 4
Consider the following query:
DELETE FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'world'
AND table_name = 'Country'
What would be the result of executing this query?
- An error would be issued
- A warning would be issued
- The row would be deleted from the INFORMATION_SCHEMA.TABLES table, and the table Country would be dropped from the world database
- The row would be deleted from the INFORMATION_SCHEMA, but the table Country in the world database would be unaffected.
Correct answer: A
Question 5
Which mysqld command line option disables incoming TCP/IP connections?
- --shared-memory
- --memlock
- --no-networking
- --skip-networking
Correct answer: D
Question 6
What are some advantages of using the SHOW command rather than using the INFORMATION_SCHEMA?
- It is available for releases older than MySQL 5.0.
- It returns results quicker than using the INFORMATION_SCHEMA.
- Using SHOW can provide more concise information.
- SHOW is a feature of standard SQL, and INFORMATION_SCHEMA is a MySQL specific command.
Correct answer: AC
Question 7
Index analysis and optimization using ANALYZE and OPTIMIZE statements should...
- generally never be run manually
- be run once the table reaches 100,000 rows or above
- be run when more than 5% of the rows are changed by a single statement
- be run when EXPLAIN SELECT shows that an inordinate amount of rows is expected to be read during query execution
- be run when you suspect that a table is heavily fragmented
Correct answer: DE
Question 8
Suppose you have a column in which most records are going to be between 30 and 32 characters.
Which of the following column types would be most efficient?
- VARCHAR
- CHAR
- TEXT
- Either VARCHAR or CHAR
Correct answer: B
Question 9
Which of the following APIs/connectors are included in a MySQL distribution?
- Connector/J
- Connector/ODBC
- C API
- Connector/NET
- Connector/MJX
Correct answer: C
Question 10
Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?
- They are highly optimized.
- They are cross-platform.
- Many are built using commercial compilers that produce a better quality build than with freely available compilers.
- They will work with tools such as MySQL Administrator and MySQL Query Browser.
- They may include libraries not available in the standard operating system library.
Correct answer: ACE
