17 tips on database administration fundamentals mta exam 98-364 pdf
Exam Code: 98-364 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Microsoft Database Fundamentals
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 98-364 Exam.
2021 Apr 98-364 Study Guide Questions:
Q86. Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q87. 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
Q88. Which keyword can be used in a create table statement?
A. ORDER BY
B. DISTINCT
C. GROUP BY
D. UNIQUE
Answer: D
Q89. You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?
A. A primary key
B. An index
C. A foreign key
D. A unique constraint
E. A data type
Answer: C
Q90. HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Answer:
Latest mta 98-364 syllabus:
Q91. You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?
A. UPDATE
B. CHANGE
C. SELECT
D. INSERT
Answer: A
Q92. 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
Q93. You execute the following statement:
This statement is an example of a/an:
A. Subquery
B. Union
C. Outer join
D. Cartesian product
Answer: A
Q94. In which situation do you need to perform a restore on a database?
A. when data becomes corrupted in the database
B. when you need to roll back a transaction
C. when you encounter an error in your application
D. when data needs to be deleted from the database
Answer: A
Q95. You ate creating a database object named Student to store the following data:
Which syntax should you use to create the object?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
100% Guarantee database administration fundamentals exam 98-364 pdf:
Q96. You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data:
You need to normalize the data to third normal form.
How many tables should you create?
A. 1
B. 2
C. 3
D. 4
Answer: C
Q97. In SQL, an insert statement is used to add a:
A. User to a database.
B. Row of data to a table.
C. Table to a database.
D. Column to a table definition.
Answer: B
Q98. 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:
Q99. The component that holds information for a single entry in a table is called a:
A. Data type
B. Row
C. Column
D. View
Answer: B
Q100. 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:
Q101. Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
Q102. You need to retrieve data from two related database tables based on a column that exists in both tables.
Which command should you use in a query?
A. INTERSECT
B. UNION
C. JOIN
D. TRUNCATE
Answer: B
see more http://www.2passeasy.com/exam/98-364/