[单项选择] You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）
A. Include-master-info
B. Master-binlog
C. Include-log-file
D. Master-data

[单项选择] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）
A. Use the DESCRIBE command in the EMP_DEPT VU view.
B. Use the DEFINE VIEW command on the EMP_DEPT VU view.
C. Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
D. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F. Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

[单项选择] You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）
A. Create a passive file screen.
B. Create an active file screen.
C. Modify the Data Manager settings of the DCS.
D. Modify the Stop Conditions settings of the DCS.

[简答题]What kind of knowledge do you need to have if you say you know a word?

[多项选择] You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
A. Each extra column in the copy with more columns must not have a default value
B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C. The slave database cannot have more columns than the master. Only the master database can have more columns
D. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

[单项选择]From this amount you need to（）something to cover utility bills.
A. contribute
B. attribute
C. subtract
D. contract

[单项选择]You need to capture the HTTP traffic to and from a server every day between 09:00 and 10:00. What should you do? （）
A. Create a scheduled task that runs the Netsh tool.
B. Create a scheduled task that runs the Nmcap tool.
C. From Network Monitor，configure the General options.
D. From Network Monitor，configure the Capture options.

[单项选择]Data from Voyager II have presented astronomers with a {{U}}puzzle{{/U}} about why our outermost planet exists.
A. problem
B. mystery
C. question
D. point

[单项选择]Data from Voyager Ⅱ have presented astronomers with a {{U}}puzzle{{/U}} about why our outermost planet exists.
A. problem
B. mystery
C. question
D. point

[单项选择] A:The senior managers need the results from last month straight away, so I can't stop to talk. I've got to hurry. B:（）
A.  Stay longer
B.  Go slowly
C.  Ok， see you later

[单项选择] Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CUST_ID 12-JAN- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 25-JUN- 104 15 6000 18-JUL- 105 20 5000 106 18-JUL- 35 7000 21-JUL- 107 20 6500 04-AUG- 109 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Lind New York Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）
A. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.

[单项选择]Input data from keyboard are stored in （） for processing.
A. modem
B. bus
C. memory
D. printer

[单项选择]Selected financial data from Krandall, Inc. ' s balance sheet for the year ended December 31 was as follows (in $ ) :
A. Cash
B. $1100000
C. Accounts Payable
D. $ 400000
E. Accounts Receivable
F. 300000
G. Deferred Tax Liability
H. 700000
I. Inventory
J. 2400000
K. Long-term Debt
L.

8200000

M. Property, Plant & Eq.
N. 8000000

[单项选择]Input data from keyboard are stored in （72） for processing.
A. modem B
B. bus
C. memory
D. printer