Download mySQL.005-002.CertDumps.2016-12-12.140q.vcex

Download Exam

File Info

Exam Certified MySQL 5.0 DBA Part I
Number 005-002
File Name mySQL.005-002.CertDumps.2016-12-12.140q.vcex
Size 113 KB
Posted Dec 12, 2016
Download mySQL.005-002.CertDumps.2016-12-12.140q.vcex

ProfExam Suite - Black Friday

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

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


  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









CONNECT US

Twitter

Mastodon

Facebook

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files