98-364 Exam
Amazing exam 98-364 mta database administration fundamentals secrets
We supply the 100% refund policy in case you fail the particular Microsoft Microsoft exam after making use of our exam goods. Or you can claim another Microsoft Microsoft exam dumps in the same value without charging virtually any fees. Should you have every other questions, please seek the on-line customer assistance for help. Our main objective is your current success and also satisfaction.
2021 Nov mta 98-364 study guide:
Q11. HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Answer:
Q12. 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
Q13. 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
Q14. A view can be used to:
A. Save an extra copy of data stored in a separate table.
B. Limit access to specific rows or columns of data in a table.
C. Ensure referential integrity.
D. Save historical data before deleting it from the base table.
Answer: B
Q15. 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
Update mta 98-364 syllabus:
Q16. A named group of SQL statements that can be executed in a database is called a:
A. Subroutine
B. Formula
C. Stored procedure
D. Method
Answer: C
Q17. Which command should you use to add a column to an existing table?
A. MODIFY
B. ALTER
C. UPDATE
D. INSERT
E. CHANGE
Answer: B
Q18. You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?
A. All rows in the table will be deleted.
B. All rows containing a NULL value in the FirstName column will be deleted.
C. You will receive an error message.
D. All rows and the table definition will be deleted.
Answer: A
Q19. This question requires that you evaluate the underlined text to determine if it is correct.
Views are database objects that contain all of the data in a database.
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. Queries
C. Stored procedures
D. Tables
Answer: D
Q20. Which two elements are required to define a column? (Choose two.)
A. A name
B. A key
C. An index
D. A data type
Answer: A,D