98-364 Exam
How to win with studying for 98-364
Microsoft 98-364 exam dumps are written by Pass4sures superb professionals who have quite a lot of experience in compiling the particular Microsoft 98-364 exam demos. They are several kinds of Microsoft 98-364 examination questions and answers that may appear from the real examination. A lot of candidates possess passed the particular Microsoft Microsoft exam since we started. Pass4sure pledges you large quality along with great benefit which guarantee you the passing score.
2021 Nov exam 98-364 examcollection:
Q61. You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q62. You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
A. INTEGER
B. DOUBLE
C. COUNT
D. FLOAT
Answer: A
Q63. In SQL, an insert statement is used to add a:
A. User to a database.
B. Row of data to a table.
C. Table to a database.
D. Column to a table definition.
Answer: B
Q64. The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
A. View
B. Function
C. Index
D. Stored procedure
E. Trigger
Answer: C
Q65. You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?
A. CHAR
B. BYTE
C. DOUBLE
D. SMALLINT
Answer: A
Refresh 98-364 ebook download:
Q66. You have a table of products with fields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?
A. THAT
B. WHERE
C. GROUP BY
D. HAVING
Answer: B
Q67. What are three valid data manipulation language (DML) commands? (Choose three.)
A. INSERT
B. COMMIT
C. DELETE
D. OUTPUT
E. UPDATE
Answer: A,C,E
Explanation: http://en.wikipedia.org/wiki/Data_manipulation_language
Data manipulation languages have their functional capability organized by the initial word ina statement, which is almost always a verb. In the case of SQL, these verbs are:
SELECT ... FROM ... WHERE ...
INSERT INTO ... VALUES ...
UPDATE ... SET ... WHERE ...
DELETE FROM ... WHERE ...
Q68. Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q69. The component that holds information for a single entry in a table is called a:
A. Data type
B. Row
C. Column
D. View
Answer: B
Q70. This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
B. INTERSECT
C. ALL
D. UOIN
Answer: B