image


010-002 Dumps

010-002 Braindumps

010-002 Real Questions

010-002 Practice Test

010-002 Actual Questions


mySQL


010-002


Certified MySQL Associate(English)


https://killexams.com/pass4sure/exam-detail/010-002


| District | char(20) | YES | | NULL | |

+-------------+------------------+------+-----+---------+-------+

The following statement is used to return all rows in the table:

SELECT CountryCode,Name FROM City In what order are the rows returned? Select the best response.


  1. ByCountryCode; then by Name.

  2. By Name; then byCountryCode; then by District.

  3. No guarantee can be made about the order.

  4. The rows are returned in the same order as they were added to the table


Answer: C


QUESTION: 45

The following output lists the contents of the City table:

+-------------+------------+

| Name | District |

+-------------+------------+

| Dallas | Texas |

| New York | New York |

| Chicago | Illinois |

| Los Angeles | California |

| Houston | Texas |

+-------------+------------+

Which result will be returned by executing the following statement? SELECT District, Count(District)

FROM City GROUP BY District

Select the best response.


A. +------------+-----------------+

| District | Count(District) |

+------------+-----------------+

| California | 1 |

| Illinois | 1 |

| New York | 1 |

| Texas | 1 |

+------------+-----------------+

B. +------------+-----------------+

| District | Count(District) |

+------------+-----------------+

| California | 1 |


| Illinois | 1 |

| New York | 1 |

| Texas | 2 |

+------------+-----------------+

C. +------------+-----------------+

| District | Count(District) |

+------------+-----------------+

| California | 1 |

| Illinois | 1 |

| New York | 1 |

| Texas | 1 |

| Texas | 2 |

+------------+-----------------+

D. +------------+-----------------+

| District | Count(District) |

+------------+-----------------+

| California | 1 |

| Illinois | 1 |

| New York | 1 |

| Texas | 2 |

| Texas | 2 |

+------------+-----------------+


Answer: B


QUESTION: 46

Which of the following activities would imply using a join in a query? Select the best response.


  1. Aggregating data from a given table.

  2. Making particular groups of the rows in a table.

  3. Making a list of all rows from a given table followed by all rows from another table.

  4. Making a list of rows that combine data from a given table with data from another table.


Answer: D


QUESTION: 47

What is the purpose of the mysqldump program? Select the best response.


  1. To migrate a non-MySQL database to a MySQL database.

  2. To exportMySQL databases to a text file.


  3. To make a binary backup of aMySQL database.

  4. To convert the binary log into a human readable format.


Answer: B


QUESTION: 48

What is the purpose of the mysqlimport program? Select the best response.


  1. To import log files into aMySQL database table.

  2. To import data from a binary log into aMySQL database table.

  3. To import data from a text file into aMySQL database table.

  4. To import tables from a non-MySQL database into a MySQL database.


Answer: C


QUESTION: 49

What is the effect of using the keyword LOCAL with the LOAD DATA INFILE statement? Select the best response.


  1. With LOCAL, the server will request the file from the client host. Without LOCAL, the server will perform the operation using a file located on the server host.

  2. With LOCAL, the server will perform the operation using a file located on the server host. Without LOCAL, the server will request the file from the client host.

  3. The keyword LOCAL is optional. The server always performs the operation using a file located on the server host.

  4. The keyword LOCAL is optional. The server always requests the file from the client host.


Answer: A


QUESTION: 50

Three UPDATE statements have been executed within one transaction. The transaction is still uncommitted when the connection between the server and the client issuing the commands is closed. What will happen to the transaction? Select the best response.


  1. All changes are committed.

  2. All changes are rolled back.

  3. If the connection was closed normally at the clients' request, the changes are committed. If


    the connection closed abnormally, the changes are rolled back.

    image

  4. The changes are neither committed nor rolled back. The entire sessionstate, including the pending changes are saved separately by the server, and the session is restored when the client reconnects.


Answer: B


image

6$03/( 48(67,216


7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP


([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP


3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV


*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\


'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU

.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG