Free Microsoft 98-364 Exam Dumps Questions & Answers
| Exam Code/Number: | 98-364Join the discussion |
| Exam Name: | Microsoft Database Fundamentals |
| Certification: | Microsoft |
| Free Question Number: | 130 |
| Publish Date: | Jul 30, 2026 |
| # of views: | 6219 |
|
|
|
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.)
You have the following table definition:
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?
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?
