Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Cisco 642-980 Exam - Cheat-Test.com

Free 642-980 Sample Questions:

Q: 1
What is the purpose of the mysqlimport program?
A. To import log files into a MySQL database table.
B. To import data from a binary log into a MySQL database table.
C. To import data from a text file into a MySQL database table.
D. To import tables from a non-MySQL database into a MySQL database.
Answer: C

Q: 2
What is the purpose of the mysqldump program?
A. To migrate a non-MySQL database to a MySQL database.
B. To export MySQL databases to a text file.
C. To make a binary backup of a MySQL database.
D. To convert the binary log into a human readable format.
Answer: B

Q: 3
What is the main reason for adding indexes to tables?
A. Only indexed columns may be used in expressions.
B. Indexes enforce referential integrity.
C. Indexes can speed up execution of queries.
D. Indexes can speed up table maintenance tasks.
Answer: C

Q: 4
How many PRIMARY KEYs can be defined for a given table?
A. At most one PRIMARY KEY may be defined.
B. Exactly one PRIMARY KEY must be defined.
C. At least one PRIMARY KEY must be defined.
D. For each column, at most one PRIMARY KEY may be defined.
Answer: A

Q: 5
What is the effect of the ROLLBACK statement?
A. Issuing a ROLLBACK statement will undo all changes on transactional tables performed since the beginning of the session.
B. Issuing a ROLLBACK statement will undo all changes on transactional tables performed since the beginning of the transaction.
C. Issuing a ROLLBACK statement will undo all changes made by the previous statement.
D. Issuing a ROLLBACK statement will undo the effect of the previous COMMIT statement.
Answer: B

Q: 6
Is it possible to save the result of a SELECT statement into a file using an SQL statement?
A. No, not with SQL alone.
B. Yes, by using the FILE() function.
C. Yes, by using the INTO OUTFILE clause.
D. Yes, by using the LOAD DATA INFILE clause.
Answer: C


© 2014 Cheat-Test.com, All Rights Reserved