98-364 Exam
Finding Up to date 98-364 item pool
Our pass rate is high to 98.9% and the similarity percentage between our 98-364 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 98-364 exam in just one try? I am currently studying for the Microsoft 98-364 exam. Latest Microsoft 98-364 Test exam practice questions and answers, Try Microsoft 98-364 Brain Dumps First.
Q21. You need to delete a database table.
Which data definition language (DDL) keyword should you use?
A. ALTER
B. DELETE
C. DROP
D. TRUNCATE
Answer: C
Q22. Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
A. Recover
B. Restore
C. Commit
D. Attach
Answer: B
Q23. This question requires that you evaluate the underlined text to determine if it is correct. Create a query that returns a set of table data by using the UPDATE statement.
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. INSERT
C. REPLACE
D. SELECT
Answer: D
Q24. You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?
A. JOIN
B. INSERT
C. CREATE
D. UPDATE
Answer: A
Q25. You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to
43.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q26. You need to retrieve data from two related database tables based on a column that exists in both tables.
Which command should you use in a query?
A. INTERSECT
B. UNION
C. JOIN
D. TRUNCATE
Answer: B
Q27. This question requires that you evaluate the underlined text to determine if it is correct.
First normal form requires that a database excludes repeating groups.
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. Composite keys
C. Duplicate rows
D. Foreign keys
Answer: A
Q28. You need to enable a new employee to authenticate to your database.
Which command should you use?
A. ALLOW USER
B. CREATE USER
C. ADD USER
D. INSERT USER
E. ALTER USER
Answer: B
Q29. You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?
A. READ
B. SELECT
C. OUTPUT
D. GET
Answer: B
Q30. You execute the following statement:
This statement is an example of a/an:
A. Subquery
B. Union
C. Outer join
D. Cartesian product
Answer: A