98-364 Exam
Resources to mta exam 98-364
Highest Quality of 98-364 study guide materials and testing software for Microsoft certification for client, Real Success Guaranteed with Updated 98-364 pdf dumps vce Materials. 100% PASS Microsoft Database Fundamentals exam Today!
2021 Sep 98-364 dumps free:
Q51. 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
Q52. You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the charged amounts.
Which data type should you recommend?
A. Money
B. Bit
C. Varchar
D. Binary
Answer: C
Q53. This question requires that you evaluate the underlined text to determine if it is correct.
Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.
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. ORDER BY
C. UNION
D. WHERE
Answer: D
Q54. Data in a database is stored in:
A. Tables
B. Queries
C. Data types
D. Stored procedures
Answer: A
Q55. Which command should you use to remove a table from a database?
A. REMOVE TABLE
B. UPDATE TABLE
C. DROP TABLE
D. DELETE TABLE
Answer: C
Most recent mta 98-364:
Q56. On which database structure does an update statement operate?
A. Table
B. User
C. Trigger
D. Role
Answer: A
Q57. You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
A. all columns
B. only the last column
C. only the first column
D. only the first and last columns
Answer: A
Q58. You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
A. a foreign key constraint violation
B. a syntax error
C. a new row in the Product table
D. a primary key constraint violation
E. a new row in the Category table
Answer: D
Q59. Which command should you use to give a user permission to read the data in a table?
A. ALLOW SELECT
B. LET READ
C. PERMIT READ
D. GRANT SELECT
Answer: D
Q60. You have the following table definition:
CREATE TABLE Product
(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D