Download Certified MySQL 5.0 DBA Part I.005-002.PrepDumps.2016-12-12.140q.vcex

Vendor: mySQL
Exam Code: 005-002
Exam Name: Certified MySQL 5.0 DBA Part I
Date: Dec 12, 2016
File Size: 108 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

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
  1. Yes.
  2. No; the INFORMATION_SCHEMA database does not contain information on itself.
  3. No; the WHERE clause is incorrect. The correct field name is TABLE_SCHEMATA.
  4. 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?
  1. Create and Drop databases
  2. Ping the server
  3. Create, Drop, and modify tables and indexes.
  4. Shutdown the server.
  5. Create users.
  6. 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?
  1. Each time the server is started.
  2. Each time it encounters an error.
  3. Each time it opens the MyISAM table files.
  4. 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?
  1. An error would be issued
  2. A warning would be issued
  3. The row would be deleted from the INFORMATION_SCHEMA.TABLES table, and the table Country would be dropped from the world database
  4. 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?
  1. --shared-memory
  2. --memlock
  3. --no-networking
  4. --skip-networking
Correct answer: D
Question 6
What are some advantages of using the SHOW command rather than using the INFORMATION_SCHEMA?
  1. It is available for releases older than MySQL 5.0.
  2. It returns results quicker than using the INFORMATION_SCHEMA.
  3. Using SHOW can provide more concise information.
  4. 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...
  1. generally never be run manually
  2. be run once the table reaches 100,000 rows or above
  3. be run when more than 5% of the rows are changed by a single statement
  4. be run when EXPLAIN SELECT shows that an inordinate amount of rows is expected to be read during query execution
  5. 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?
  1. VARCHAR
  2. CHAR
  3. TEXT
  4. Either VARCHAR or CHAR
Correct answer: B
Question 9
Which of the following APIs/connectors are included in a MySQL distribution?
  1. Connector/J
  2. Connector/ODBC
  3. C API
  4. Connector/NET
  5. Connector/MJX
Correct answer: C
Question 10
Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?
  1. They are highly optimized.
  2. They are cross-platform.
  3. Many are built using commercial compilers that produce a better quality build than with freely available compilers.
  4. They will work with tools such as MySQL Administrator and MySQL Query Browser.
  5. They may include libraries not available in the standard operating system library.
Correct answer: ACE
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!