98-364 Exam
Ideas to moac mta 98-364 database fundamentals
We tend to be proud of each of our high-quality and wonderful value Microsoft Microsoft practice resources. Because weve got got high passing rate given that we began. Most of each of our customers have got through the Microsoft 98-364 real test and made remarkable achievements. So we guarantee that you will also make wonderful success provided that you get full benefit of Testking Microsoft certification simulated tests.
2021 Oct exam 98-364 pdf:
Q21. Which two keys establish a relationship between two tables? (Choose two.)
A. candidate
B. foreign
C. superkey
D. local
E. primary
Answer: B,E
Q22. You have a table named Customer. You need to add a new column named District.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q23. You need to store the contact information for each student in your school database.
You should store each student's information in a:
A. Stored procedure
B. Function
C. Row
D. Variable
Answer: C
Q24. Which keyword can be used in a create table statement?
A. ORDER BY
B. DISTINCT
C. GROUP BY
D. UNIQUE
Answer: D
Q25. While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?
A. Foreign key
B. Index key
C. Link key
D. Default key
Answer: B
Regenerate moac mta 98-364 database fundamentals:
Q26. DRAG DROP
You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.
Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:
Q27. 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
Q28. Which permission does a user need in order to run a stored procedure?
A. EXECUTE
B. ALLOW
C. CALL
D. RUN
Answer: A
Q29. You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?
A. ALTER
B. INSERT
C. CREATE
D. UPDATE
Answer: A
Q30. 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: