98-364 Exam
Dec 2021 updated: Actualtests Microsoft 98-364 download 31-40
It is more faster and easier to pass the Microsoft 98-364 exam by using 100% Guarantee Microsoft Microsoft Database Fundamentals questuins and answers. Immediate access to the Renovate 98-364 Exam and find the same core area 98-364 questions with professionally verified answers, then PASS your exam with a high score now.
Q31. This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.
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. DROP TABLE
C. TRUNCATE TABLE
D. ALTER TABLE
Answer: B
Q32. Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q33. You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
A. Empty
B. Deleted
C. Unchanged
D. Archived
Answer: A
Q34. You have a database table named SongInformation as defined below:
You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than 1000 compact discs (CDs).
Which query should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q35. You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.
The table has the following columns and rows:
When volunteer information changes, you must update the table.
You need to change Tia's name to Kimberly.
Which statement should you choose?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q36. Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
Given name
Surname
Telephone number
Email address
You need to recommend a correct way to store the data.
What do you recommend?
A. Create a table that contains columns that are named given name, surname, phone number, and email.
B. Create a table that contains rows that are named given name, surname, phone number, and email.
C. Create a view that contains columns that are named given name surname, phone number, and email.
D. Create a view that contains rows that are named given name surname, phone number, and email
Answer: A
Q37. You need to establish a set of permissions that you can routinely assign to new users.
What should you create?
A. Resource
B. Group
C. List
D. Role
Answer: D
Q38. You need to remove a view named EmployeeView from your database.
Which statement should you use?
A. DELETE VIEW EmployeeView
B. DELETE EmployeeView
C. DROP EmployeeView
D. DROP VIEW EmployeeView
Answer: D
Q39. One difference between a function and a stored procedure is that a function:
A. Must be called from a trigger.
B. Must return a value.
C. Cannot contain a transaction.
D. Cannot accept parameters.
Answer: B
Q40. You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D