Master the 98-364 Microsoft Database Fundamentals content and be ready for exam day success quickly with this Testking 98-364 free exam. We guarantee it!We make it a reality and give you real 98-364 questions in our Microsoft 98-364 braindumps.Latest 100% VALID Microsoft 98-364 Exam Questions Dumps at below page. You can use our Microsoft 98-364 braindumps and pass your exam.
Q16. 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
Q17. You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?
A. The table will be corrupted.
B. Forty (40) rows will be deleted from the table.
C. The transaction will restart.
D. No rows will be deleted from the table.
Answer: D
Q18. 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
Q19. Which keyword would you use in a select statement to return rows that meet a specific condition?
A. WHERE
B. UNION
C. ORDER BY
D. FROM
Answer: A
Q20. 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
Q21. You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
A. a foreign key constraint violation
B. a syntax error
C. a new row in the Product table
D. a primary key constraint violation
E. a new row in the Category table
Answer: D
Q22. You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?
A. A cursor
B. A subquery
C. A trigger
D. An index
Answer: D
Q23. 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
Q24. 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.
When volunteers ask to be removed from mailing lists, the table must be updated.
You need to use a transaction to ensure that the database has data integrity and referential integrity.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Q25. Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Answer: B
Q26. 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
Q27. 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
Q28. 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:
Q29. 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
Q30. You have a user that has server roles as defined below:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Answer: