Share some MTA 98-364 exam questions and answers below.
Which permission does a user need in order to run a stored procedure?
A. EXECUTE
B. ALLOW
C. CALL
D. RUN
Answer: A
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
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
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database.
What is the result of the script?
A. The Customer table no longer exists.
B. The Customer table is unaffected.
C. The Customer table exists but has no data.
D. The script fails.
Answer: A
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
A. VARCHAR (3, 30)
B. CHAR (3, 30)
C. VARCHAR (30)
D. CHAR (30)
Answer: C
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
Which command should you use to give a user permission to read the data in a table?
98-364 関連試験: 98-365 Windows Server Administration Fundamentals 98-365J Windows Server Administration Fundamentals 日本語版 98-361 Microsoft MTA Software Development Fundamentals 98-366 MTA Networking Fundamentals 98-367 MTA Security Fundamentals Practice Test