98-364 Exam
How to pass 98-364 answers in Nov 2021
Actual of 98-364 actual test materials and practice exam for Microsoft certification for IT learners, Real Success Guaranteed with Updated 98-364 pdf dumps vce Materials. 100% PASS Microsoft Database Fundamentals exam Today!
2021 Nov database administration fundamentals mta exam 98-364 training:
Q1. You have the database table named Cars as defined below:
You have the following Structured Query Language (SQL) statement:
How many rows are returned by the SQL statement?
A. 4
B. 5
C. 6
D. 7
Answer: A
Q2. 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
Q3. Which statement deletes the rows where the employee's phone number is not entered?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q4. One reason to add an index is to:
A. Decrease storage space.
B. Increase database security.
C. Improve performance of select statements.
D. Improve performance of insert statements.
Answer: C
Q5. 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
Renew 98-364 exam pdf:
Q6. You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)
A. ChapterId
B. LanguageId
C. Country
D. Region
E. City
F. LanguageName
Answer: A,E
Q7. You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?
A. Nonclustered index
B. Primary key
C. Foreign key
D. Clustered index
Answer: B
Q8. DRAG DROP
You need to set up a database to provide a view of North American mammals.
Match the Structured Query Language (SQL) statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:
Q9. You have two tables named Cars and Color as defined below. The two tables are related by ColorId.
You run the following SQL statement: select:
How many rows does the SQL statement return?
A. 0
B. 2
C. 3
D. 6
Answer: C
Q10. You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
A. Inherited delete
B. Cascade delete
C. Functional delete
D. Waterfall delete
E. Domino delete
Answer: B