we provide Precise Microsoft 98-364 exam guide which are the best for clearing 98-364 test, and to get certified by Microsoft Microsoft Database Fundamentals. The 98-364 Questions & Answers covers all the knowledge points of the real 98-364 exam. Crack your Microsoft 98-364 Exam with latest dumps, guaranteed!
NEW QUESTION 1
HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
- A. Mastered
- B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 2
You have a database table named SongInformation as defined below:
You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than 1000 compact discs (CDs).
Which query should you use?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: A
NEW QUESTION 3
On which database structure does an update statement operate?
- A. Table
- B. User
- C. Trigger
- D. Role
Answer: A
NEW QUESTION 4
You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement: INSERT INTO Road VALUES (1234, 36)
What is the result?
- A. an error stating that NULL values are not allowed
- B. a new row in the table
- C. an error stating that duplicate IDs are not allowed
- D. a syntax error
Answer: B
NEW QUESTION 5
Which statement creates a composite key?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 6
Which category of SQL statements is used to add, remove, and modify database structures?
- A. Data access language (DAL)
- B. Data manipulation language (DML)
- C. Data control language (DCL)
- D. Data definition language (DDL)
Answer: D
NEW QUESTION 7
HOTSPOT
You have the following table:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
- A. Mastered
- B. Not Mastered
Answer: A
Explanation:
NEW QUESTION 8
You develop a database to store data about textbooks. The data must be stored to process at a later time.
Which database object should you use to store the data?
- A. View
- B. Table
- C. Function
- D. Stored procedure
Answer: D
NEW QUESTION 9
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
NEW QUESTION 10
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: AE
NEW QUESTION 11
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department
This type of operation is called a/an:
- A. Intersection
- B. Outer join
- C. Equi-join
- D. Cartesian product
Answer: D
NEW QUESTION 12
You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to
glass.
What should you include in the update statement?
- A. SET ProduetName = 'glass'
- B. LET ProduetName = 'glass'
- C. EXEC ProduetName = 'glass'
- D. ASSIGN ProduetName = 'glass'
Answer: A
NEW QUESTION 13
This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
- A. No change is needed
- B. Table
- C. Index
- D. Row
Answer: D
NEW QUESTION 14
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
- A. Recover
- B. Restore
- C. Commit
- D. Attach
Answer: B
NEW QUESTION 15
Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data. What do you recommend?
- A. Create a table that contains columns that are named given name, surname, phone number, and email.
- B. Create a table that contains rows that are named given name, surname, phone number, and email.
- C. Create a view that contains columns that are named given name surname, phone number, and email.
- D. Create a view that contains rows that are named given name surname, phone number, and email
Answer: A
NEW QUESTION 16
Which key uniquely identifies a row in a table?
- A. foreiqn
- B. primary
- C. local
- D. superkey
Answer: B
NEW QUESTION 17
Which two keys establish a relationship between two tables? (Choose two.)
- A. candidate
- B. foreign
- C. superkey
- D. local
- E. primary
Answer: BE
NEW QUESTION 18
This question requires that you evaluate the underlined text to determine if it is correct. Ports 20 and 21 are the default ports to secure a SQL Server.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
- A. No change is needed
- B. 1433 and 1434
- C. 411 and 412
- D. 67 and 68
Answer: B
NEW QUESTION 19
You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?
- A. FIND
- B. BETWEEN
- C. INCLUDES
- D. LIKE
Answer: D
NEW QUESTION 20
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?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 21
You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.
Which statement should you use?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: B
NEW QUESTION 22
......
P.S. Easily pass 98-364 Exam with 130 Q&As Simply pass Dumps & pdf Version, Welcome to Download the Newest Simply pass 98-364 Dumps: https://www.simply-pass.com/Microsoft-exam/98-364-dumps.html (130 New Questions)