564 お客様のコメント
質問 1：
Which data type should be used to store data in a column that represents money and accurately returns a two position scale?
A. BIGINT
B. BINARY
C. DECIMAL
D. DOUBLE
正解：C
質問 2：
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT * FROM employee WHERE salary GREATER THAN 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT salary FROM employee WHERE salary > 100000
正解：D
質問 3：
If a table named MY_TAB contains 100 rows and the following statement is executed:
How many rows will be updated?
A. 0
B. 99
C. 1
D. 10
正解：D
質問 4：
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
A. SELECT name, COUNT(*) AS transactions FROM sales
B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales
C. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions
D. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name
正解：D
質問 5：
A table named EMPLOYEES was created as follows:
What will be the results?
A. 0
B. 1
C. 3
D. 2
正解：D
Which data type should be used to store data in a column that represents money and accurately returns a two position scale?
A. BIGINT
B. BINARY
C. DECIMAL
D. DOUBLE
正解：C
質問 2：
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT * FROM employee WHERE salary GREATER THAN 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT salary FROM employee WHERE salary > 100000
正解：D
質問 3：
If a table named MY_TAB contains 100 rows and the following statement is executed:
How many rows will be updated?
A. 0
B. 99
C. 1
D. 10
正解：D
質問 4：
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
A. SELECT name, COUNT(*) AS transactions FROM sales
B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales
C. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions
D. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name
正解：D
質問 5：
A table named EMPLOYEES was created as follows:
What will be the results?
A. 0
B. 1
C. 3
D. 2
正解：D
萩野** -
全力を尽くして勉強していただきます。A2090-610学習教材は有効です。そして、合格率は高いです。