It is impossible to pass Microsoft 98-364 exam without any help in the short term. Come to Certleader soon and find the most advanced, correct and guaranteed Microsoft 98-364 practice questions. You will get a surprising result by our Most up-to-date Microsoft Database Fundamentals practice guides.
NEW QUESTION 1
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 2
You have a table named Employee that includes the following columns:
EmployeeID Smp1oyeeName
Which statement should you use to return the number of rows in the table?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: D
NEW QUESTION 3
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 4
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: A
NEW QUESTION 5
A view can be used to:
- A. Save an extra copy of data stored in a separate table.
- B. Limit access to specific rows or columns of data in a table.
- C. Ensure referential integrity.
- D. Save historical data before deleting it from the base table.
Answer: B
NEW QUESTION 6
This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
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. INTERSECT
- C. ALL
- D. UOIN
Answer: B
NEW QUESTION 7
You need to disable User1's access to view the data in the Customer table. Which statement should you use?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer: C
NEW QUESTION 8
This question requires that you evaluate the underlined text to determine if it is correct. Use indexing to create, remove, or change database objects.
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. Data manipulation language (DML) statements
- C. Data definition language (DDL) statements
- D. A unique constraint
Answer: C
NEW QUESTION 9
A named group of SQL statements that can be executed in a database is called a:
- A. Subroutine
- B. Formula
- C. Stored procedure
- D. Method
Answer: C
NEW QUESTION 10
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
NEW QUESTION 11
Which key uniquely identifies a row in a table?
- A. foreiqn
- B. primary
- C. local
- D. superkey
Answer: B
NEW QUESTION 12
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
NEW QUESTION 13
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
NEW QUESTION 14
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
NEW QUESTION 15
One reason to create a stored procedure is to:
- A. Improve performance.
- B. Minimize storage space.
- C. Bypass case sensitivity requirements.
- D. Give the user control of the query logic.
Answer: A
NEW QUESTION 16
This question requires that you evaluate the underlined text to determine if it is correct.
Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database.
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 corrector.
- A. Change is needed
- B. Commit
- C. Attach
- D. Restore
Answer: D
NEW QUESTION 17
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 18
You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?
- A. JOIN
- B. INSERT
- C. CREATE
- D. UPDATE
Answer: B
NEW QUESTION 19
This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.
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. DROP TABLE
- C. TRUNCATE TABLE
- D. ALTER TABLE
Answer: B
NEW QUESTION 20
Which command should you use to remove a table from a database?
- A. REMOVE TABLE
- B. UPDATE TABLE
- C. DROP TABLE
- D. DELETE TABLE
Answer: C
NEW QUESTION 21
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: D
NEW QUESTION 22
You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?
- A. Primary key
- B. Secondary key
- C. Foreign key
- D. Default key
Answer: C
NEW QUESTION 23
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
NEW QUESTION 24
DRAG DROP
You need to set up a database to provide a view of North American mammals. Match the Structured Query Language (SQL) statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.
- A. Mastered
- B. Not Mastered
Answer: A
Explanation: 
NEW QUESTION 25
......
P.S. Easily pass 98-364 Exam with 130 Q&As Passcertsure Dumps & pdf Version, Welcome to Download the Newest Passcertsure 98-364 Dumps: https://www.passcertsure.com/98-364-test/ (130 New Questions)